Table Data dictionary report - ar_transactions

Generated: 9/23/2016 2:28:39 PM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict
Schema: public

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('ar_transactions_id_seq'::regclass)
cust_no character varying(20) No No Customer number
link_date date No No Transaction number linked
link_trans_no character varying(10) No No Transaction number linked
recno integer No No Always 0
date date No No Date of transaction
debit_amt numeric(15,2) No No Amount debited
credit_amt numeric(15,2) No No Amount credited
balance numeric(15,2) No No Balance of this transaction
trans_no character varying(10) No No Transaction number
ref_no character varying(25) No No Reference or invoice number
code character varying(1) No No Code of the transaction I = Invoice P = Payment S = Service Charge C = Credit memo D = Debit memo
open_close_flag character varying(1) No No Open Close Flag O = Open C = Closed
item_hold_flag boolean No No Hold Flag FALSE or blank = Not Held TRUE = Held
due_date date No No Due date for transaction
terms_code character varying(10) No No Terms code used for the transaction
terms_description character varying(60) No No Terms description used for the transaction
terms_days_before_due smallint No No Days before transaction due based on invoice date
terms_days_allowed smallint No No Days before discount allowed based on invoice date
terms_discount_rate numeric(5,2) No No Rate of discount
arf_user character varying(3) No No Initials of user that posted transaction
rate_method character varying(1) No No Multi Currency rate method used Direct Indirect
rate numeric(13,7) No No Currency rate used
base_debit_amt numeric(15,2) No No Base amount credited
base_credit_amt numeric(15,2) No No Base amount debited
upload_flag boolean No No Not used
note character varying(60) No No Ship to ID and Location code from sales invoice
_dbversion integer No No
_created timestamp without time zone No No
_created_by character varying(3) No No
_modified timestamp without time zone No No
_modified_by character varying(3) No No
sales_tax_no smallint[] Yes No '{0,0,0,0}'::smallint[] Array field containing tax codes charged
sales_tax_rate numeric(7,4)[] Yes No '{0,0,0,0}'::numeric[] Array fields containing tax percentages charged
sales_tax_total numeric(15,2)[] Yes No '{0,0,0,0}'::numeric[] Array fields containing tax amounts charged
freight numeric(15,2) No No Freight charged
cust_po_no character varying(20) No No Customers PO number
payment_account character varying(24) No No GL account used for payment

Constraints

Name Type Definition Comment
ar_transactions_pkey Primary key (id)

Report generated by pgAdmin III