Table: dbo.Payment_Term
This table contains the fields required for the Payment Term screen.
Columns
Name | Type | Constraints | Description
payment_term_KEY | int (4) | NOT NULL | Primary key for this table.
payment_term_id | nvarchar (22) | NOT NULL | User-assigned name.
description | nvarchar (60) | NOT NULL | The description of the payment term.
is_active | bit (1) | NOT NULL | Makes payment terms unavailable.
discount_percent | decimal (5, 4) | NOT NULL | Percentage based discount.
discount_amount | decimal (9, 2) | NOT NULL | Dollar amount of discount.
discount_date__payment_term_basis_KEY | int (4) | NOT NULL | Payment Term discount basis. Determines whether the discount payment term is "Days" based or "End of Month" based.
discount_date__days_from_transaction_date | int (4) | NOT NULL | Days from transaction date for the discount date. The discount will expire in the number of days entered in this field.
discount_date__end_of_month_from_transaction_date | int (4) | NOT NULL | The discount expiration date is based on the payables current month or a month beyond the month of the payable date.
discount_date__days_from_end_of_month | int (4) | NOT NULL | Days before or after the end of the month that a user would want the application to use to calculate the due date.
due_date__payment_term_basis_KEY | int (4) | NOT NULL | Payment Term due date basis. Determines whether the due date for the payable is "Days" based or "End of Month" based.
due_date__days_from_transaction_date | int (4) | NOT NULL | Days from transaction date for the due date. The due date will arrive in the number of days specified in this field.
due_date__end_of_month_from_transaction_date | int (4) | NOT NULL | The due date is based on the payables current month or a month beyond the month of the payable date.
due_date__days_from_end_of_month | int (4) | NOT NULL | Days before or after the end of the month that a user would want the application to use to calculate the due date.
payment_cut_off_day | int (4) | NOT NULL | Cutoff day for payments.The value in this column represents the cutoff day in a month where the due date is moved to the following month
payment_term_id_sortable | nvarchar (96) | NOT NULL | Sortable for payment_term_id
payment_term_discount_method_KEY | tinyint (1) | NOT NULL | Discount Method for the payment term. Determines whether the discount is "Percentage" based or "Amount" based

Primary key
Name | Columns | Description
PK_Payment_Term | payment_term_KEY |
Unique constraints
Name | Columns | Description
UK_Payment_Term$payment_term_id | payment_term_id |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payment_Term__Payment_Term_Basis__discount_date__payment_term_basis_KEY | discount_date__payment_term_basis_KEY | Payment_Term_Basis (payment_term_basis_KEY) |
FK_Payment_Term__Payment_Term_Basis__due_date__payment_term_basis_KEY | due_date__payment_term_basis_KEY | Payment_Term_Basis (payment_term_basis_KEY) |
FK_Payment_Term__Payment_Term_Method__payment_term_discount_method_KEY | payment_term_discount_method_KEY | Payment_Term_Discount_Method (payment_term_discount_method_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Spreadsheet_Import_Payment_Term__Payment_Term__payment_term_KEY | payment_term_KEY | Spreadsheet_Import_Payment_Term |
FK_AR_Transaction_Template__Payment_Term__payment_term_KEY | payment_term_KEY | AR_Transaction_Template |
FK_AR_Enter_Invoice_Option__Payment_Term__default__payment_term_KEY | default__payment_term_KEY | AR_Enter_Invoice_Option |
FK_AP_Enter_Transaction_List_View_Column_Option__Payment_Term__default__payment_term_KEY | default__payment_term_KEY | AP_Enter_Transaction_List_View_Column_Option |
FK_Customer__Payment_Term__payment_term_KEY | payment_term_KEY | Customer |
FK_Vendor__Payment_Term__payment_term_KEY | payment_term_KEY | Vendor |
FK_Payable_Transaction_Template__Payment_Term__payment_term_KEY | payment_term_KEY | Payable_Transaction_Template |
FK_AR_Transaction__Payment_Term__payment_term_KEY | payment_term_KEY | AR_Transaction |
FK_Payable_Transaction__Payment_Term__payment_term_KEY | payment_term_KEY | Payable_Transaction |