Table: dbo.Vendor_Amortization_Schedule_Entry
Individual payments scheduled as part of an amortization schedule.
Columns
NameTypeConstraintsDescription
vendor_amortization_schedule_entry_KEYint (4)NOT NULLPrimary key for Vendor_Amortization_Schedule_Entry
vendor_amortization_schedule_KEYint (4)NOT NULLForeign key for Vendor_Amortization_Schedule
due_datesmalldatetime (4)NOT NULLPayment due date
principal_amountdecimal (9, 2)NOT NULLAmount for the principal distribution of the payment
interest_amountdecimal (9, 2)NOT NULLAmount for the interest distribution of the payment
Primary key
NameColumnsDescription
PK_Vendor_Amortization_Schedule_Entryvendor_amortization_schedule_entry_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Vendor_Amortization_Schedule_Entry__Vendor_Amortization_Schedule__vendor_amortization_schedule_KEYvendor_amortization_schedule_KEYVendor_Amortization_Schedule (vendor_amortization_schedule_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Vendor_Bank_Transaction__Vendor_Amortization_Schedule_Entry__vendor_amortization_schedule_entry_KEYvendor_amortization_schedule_entry_KEYVendor_Bank_Transaction
FK_Payable_Transaction__Vendor_Amortization_Schedule_Entry__vendor_amortization_schedule_entry_KEYvendor_amortization_schedule_entry_KEYPayable_Transaction

Schema diagram