| id |
integer |
Yes |
Yes |
nextval('payment_terms_id_seq'::regclass) |
Unique identifier |
| terms_code |
character varying(10) |
Yes |
No |
|
Code set by user for this terms record |
| description |
character varying(60) |
Yes |
No |
|
Description for this terms record |
| days_before_due |
smallint |
Yes |
No |
|
Number of days from the Invoice date that the payment is due - this is used for invoices in Accounts Receivable and Accounts Payable |
| days_allowed |
smallint |
Yes |
No |
|
Number of days from the Invoice date for which a discount is allowed - this is used for invoices in Accounts Receivable and Accounts Payable |
| discount_rate |
numeric(5,2) |
Yes |
No |
|
Rate of the discount - this is used for invoices in Accounts Receivable and Accounts Payable |
| discount_net |
boolean |
Yes |
No |
|
Only apply discount to Net Invoice amount; FALSE = Discount is allowed for the full invoice amount TRUE = Discount is available for the net amount of the invoice |
| discount_freight |
boolean |
Yes |
No |
|
Allow discount on freight amount; FALSE = Freight portion is not discountable TRUE = Freight is included in the discountable amount |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time this record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that last modified this record |
| udf_data |
hstore |
No |
No |
''::hstore |
User defined data for this record |