Table: dbo.Vendor_Amortization_Schedule | |||
Amortization schedules are used to display payments over time that have principal and interest amounts. | |||
Columns | |||
Name | Type | Constraints | Description |
vendor_amortization_schedule_KEY | int (4) | NOT NULL | Primary key for Vendor_Amortization_Schedule |
vendor_KEY | int (4) | NOT NULL | Foreign key to the associated vendor |
vendor_amortization_schedule_id | nvarchar (22) | NOT NULL | ID for the vendor amortization schedule |
description | nvarchar (100) | NOT NULL | Description for the vendor amortization schedule |
next_due_date | smalldatetime (4) | Next payment due date - optional until dates are imported | |
principal__gl_account_KEY | int (4) | Optional GL account to associated with the principal payment distribution | |
interest__gl_account_KEY | int (4) | Optional GL account to associated with the interest payment distribution | |
recurring_enabled | bit (1) | NOT NULL | Indicator that recurring payments will be applied |
days_before_due_date_to_create_recurring_payment | int (4) | How many days before the due date to create recurring payments - optional unless recurring payments is enabled | |
memo | nvarchar (480) | Optional schedule memo | |
is_active | bit (1) | NOT NULL | Indicator that the schedule is active |
principal__vendor_1099_box_setup_KEY | int (4) | Optional foreign key to Vendor_1099_Box_Setup for principal payment distribution. | |
interest__vendor_1099_box_setup_KEY | int (4) | Optional foreign key to Vendor_1099_Box_Setup for interest payment distribution. |
Primary key | |||
Name | Columns | Description | |
PK_Vendor_Amortization_Schedule | vendor_amortization_schedule_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Vendor_Amortization_Schedule$vendor_KEY$vendor_amortization_schedule_id | vendor_KEY, vendor_amortization_schedule_id |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Vendor_Amortization_Schedule_Entry__Vendor_Amortization_Schedule__vendor_amortization_schedule_KEY | vendor_amortization_schedule_KEY | Vendor_Amortization_Schedule_Entry |