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