Table: dbo.Vendor_Amortization_Schedule_Entry
Individual payments scheduled as part of an amortization schedule.
Columns
Name | Type | Constraints | Description
vendor_amortization_schedule_entry_KEY | int (4) | NOT NULL | Primary key for Vendor_Amortization_Schedule_Entry
vendor_amortization_schedule_KEY | int (4) | NOT NULL | Foreign key for Vendor_Amortization_Schedule
due_date | smalldatetime (4) | NOT NULL | Payment due date
principal_amount | decimal (9, 2) | NOT NULL | Amount for the principal distribution of the payment
interest_amount | decimal (9, 2) | NOT NULL | Amount for the interest distribution of the payment

Primary key
Name | Columns | Description
PK_Vendor_Amortization_Schedule_Entry | vendor_amortization_schedule_entry_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Vendor_Amortization_Schedule_Entry__Vendor_Amortization_Schedule__vendor_amortization_schedule_KEY | vendor_amortization_schedule_KEY | Vendor_Amortization_Schedule (vendor_amortization_schedule_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Vendor_Bank_Transaction__Vendor_Amortization_Schedule_Entry__vendor_amortization_schedule_entry_KEY | vendor_amortization_schedule_entry_KEY | Vendor_Bank_Transaction |
FK_Payable_Transaction__Vendor_Amortization_Schedule_Entry__vendor_amortization_schedule_entry_KEY | vendor_amortization_schedule_entry_KEY | Payable_Transaction |