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