Table: dbo.Payment_Term
This table contains the fields required for the Payment Term screen.
Columns
NameTypeConstraintsDescription
payment_term_KEYint (4)NOT NULLPrimary key for this table.
payment_term_idnvarchar (22)NOT NULLUser-assigned name.
descriptionnvarchar (60)NOT NULLThe description of the payment term.
is_activebit (1)NOT NULLMakes payment terms unavailable.
discount_percentdecimal (5, 4)NOT NULLPercentage based discount.
discount_amountdecimal (9, 2)NOT NULLDollar amount of discount.
discount_date__payment_term_basis_KEYint (4)NOT NULLPayment Term discount basis. Determines whether the discount payment term is "Days" based or "End of Month" based.
discount_date__days_from_transaction_dateint (4)NOT NULLDays 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_dateint (4)NOT NULLThe 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_monthint (4)NOT NULLDays 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_KEYint (4)NOT NULLPayment 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_dateint (4)NOT NULLDays 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_dateint (4)NOT NULLThe 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_monthint (4)NOT NULLDays 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_dayint (4)NOT NULLCutoff 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_sortablenvarchar (96)NOT NULLSortable for payment_term_id
payment_term_discount_method_KEYtinyint (1)NOT NULLDiscount Method for the payment term. Determines whether the discount is "Percentage" based or "Amount" based
Primary key
NameColumnsDescription
PK_Payment_Termpayment_term_KEY
Unique constraints
NameColumnsDescription
UK_Payment_Term$payment_term_idpayment_term_id
Foreign keys
NameColumnsReferenced tableDescription
FK_Payment_Term__Payment_Term_Basis__discount_date__payment_term_basis_KEYdiscount_date__payment_term_basis_KEYPayment_Term_Basis (payment_term_basis_KEY)
FK_Payment_Term__Payment_Term_Basis__due_date__payment_term_basis_KEYdue_date__payment_term_basis_KEYPayment_Term_Basis (payment_term_basis_KEY)
FK_Payment_Term__Payment_Term_Method__payment_term_discount_method_KEYpayment_term_discount_method_KEYPayment_Term_Discount_Method (payment_term_discount_method_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Spreadsheet_Import_Payment_Term__Payment_Term__payment_term_KEYpayment_term_KEYSpreadsheet_Import_Payment_Term
FK_AR_Transaction_Template__Payment_Term__payment_term_KEYpayment_term_KEYAR_Transaction_Template
FK_AR_Enter_Invoice_Option__Payment_Term__default__payment_term_KEYdefault__payment_term_KEYAR_Enter_Invoice_Option
FK_AP_Enter_Transaction_List_View_Column_Option__Payment_Term__default__payment_term_KEYdefault__payment_term_KEYAP_Enter_Transaction_List_View_Column_Option
FK_Customer__Payment_Term__payment_term_KEYpayment_term_KEYCustomer
FK_Vendor__Payment_Term__payment_term_KEYpayment_term_KEYVendor
FK_Payable_Transaction_Template__Payment_Term__payment_term_KEYpayment_term_KEYPayable_Transaction_Template
FK_AR_Transaction__Payment_Term__payment_term_KEYpayment_term_KEYAR_Transaction
FK_Payable_Transaction__Payment_Term__payment_term_KEYpayment_term_KEYPayable_Transaction

Schema diagram