| 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) | |