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 |