Table: dbo.Vendor_Amortization_Schedule
Amortization schedules are used to display payments over time that have principal and interest amounts.
Columns
NameTypeConstraintsDescription
vendor_amortization_schedule_KEYint (4)NOT NULLPrimary key for Vendor_Amortization_Schedule
vendor_KEYint (4)NOT NULLForeign key to the associated vendor
vendor_amortization_schedule_idnvarchar (22)NOT NULLID for the vendor amortization schedule
descriptionnvarchar (100)NOT NULLDescription for the vendor amortization schedule
next_due_datesmalldatetime (4)Next payment due date - optional until dates are imported
principal__gl_account_KEYint (4)Optional GL account to associated with the principal payment distribution
interest__gl_account_KEYint (4)Optional GL account to associated with the interest payment distribution
recurring_enabledbit (1)NOT NULLIndicator that recurring payments will be applied
days_before_due_date_to_create_recurring_paymentint (4)How many days before the due date to create recurring payments - optional unless recurring payments is enabled
memonvarchar (480)Optional schedule memo
is_activebit (1)NOT NULLIndicator that the schedule is active
principal__vendor_1099_box_setup_KEYint (4)Optional foreign key to Vendor_1099_Box_Setup for principal payment distribution.
interest__vendor_1099_box_setup_KEYint (4)Optional foreign key to Vendor_1099_Box_Setup for interest payment distribution.
Primary key
NameColumnsDescription
PK_Vendor_Amortization_Schedulevendor_amortization_schedule_KEY
Unique constraints
NameColumnsDescription
UK_Vendor_Amortization_Schedule$vendor_KEY$vendor_amortization_schedule_idvendor_KEY, vendor_amortization_schedule_id
Foreign keys
NameColumnsReferenced tableDescription
FK_Vendor_Amortization_Schedule__GL_Account__interest__gl_account_KEYinterest__gl_account_KEYGL_Account (gl_account_KEY)
FK_Vendor_Amortization_Schedule__GL_Account__principal__gl_account_KEYprincipal__gl_account_KEYGL_Account (gl_account_KEY)
FK_Vendor_Amortization_Schedule__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
FK_Vendor_Amortization_Schedule__Vendor_1099_Box_Setup__interest__vendor_1099_box_setup_KEYinterest__vendor_1099_box_setup_KEYVendor_1099_Box_Setup (vendor_1099_box_setup_KEY)
FK_Vendor_Amortization_Schedule__Vendor_1099_Box_Setup__principal__vendor_1099_box_setup_KEYprincipal__vendor_1099_box_setup_KEYVendor_1099_Box_Setup (vendor_1099_box_setup_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Vendor_Amortization_Schedule_Entry__Vendor_Amortization_Schedule__vendor_amortization_schedule_KEYvendor_amortization_schedule_KEYVendor_Amortization_Schedule_Entry

Schema diagram