Table Data dictionary report - payment_terms

Generated: 2018-10-18 7:24:51 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for Payment Terms for Sales and Purchases

Columns

Name Data type Not Null? Primary key? Default Comment
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

Constraints

Name Type Definition Comment
terms_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL