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 |

Foreign keys
Name | Columns | Referenced table | Description
FK_Vendor_Amortization_Schedule__GL_Account__interest__gl_account_KEY | interest__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Vendor_Amortization_Schedule__GL_Account__principal__gl_account_KEY | principal__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Vendor_Amortization_Schedule__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |
FK_Vendor_Amortization_Schedule__Vendor_1099_Box_Setup__interest__vendor_1099_box_setup_KEY | interest__vendor_1099_box_setup_KEY | Vendor_1099_Box_Setup (vendor_1099_box_setup_KEY) |
FK_Vendor_Amortization_Schedule__Vendor_1099_Box_Setup__principal__vendor_1099_box_setup_KEY | principal__vendor_1099_box_setup_KEY | Vendor_1099_Box_Setup (vendor_1099_box_setup_KEY) |

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 |