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