Table Data dictionary report - ar_transactions

Generated: 2018-10-17 7:37:20 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for Accounts Receivable transactions

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('ar_transactions_id_seq'::regclass) Unique identifier
cust_no character varying(20) No No Customer code - links to customers.cust_no
link_date date No No Transaction date
link_trans_no character varying(10) No No Transaction number
recno integer No No Record number for transactions with multiple records
date date No No Date of transaction
debit_amt numeric(15,2) No No Debit amoount
credit_amt numeric(15,2) No No Credit amount
balance numeric(15,2) No No Balance outstanding
trans_no character varying(10) No No Transaction number - links to gl_transactions.trans_no
ref_no character varying(25) No No Reference or invoice number
code character varying(1) No No Transaction type code; C = Credit memo D = Debit memo I = Invoice P = Payment S = Service Charge
open_close_flag character varying(1) No No Transaction status flag; O = Open C = Closed
item_hold_flag boolean No No Transaction hold flag; FALSE or empty = No TRUE = Yes
due_date date No No Transaction due date
terms_code character varying(10) No No Terms code for transaction - links to table payment_terms.terms_code
terms_description character varying(60) No No Payment terms description
terms_days_before_due smallint No No Number of days before the payment is due calculated from transaction date
terms_days_allowed smallint No No Number of days allowed for discount
terms_discount_rate numeric(5,2) No No Early payment discount percentage rate
arf_user character varying(3) No No User initials that posted the transaction
rate_method character varying(1) No No Currency rate conversion method used; / = direct * = indirect
rate numeric(13,7) No No Currency rate used
base_debit_amt numeric(15,2) No No Debit amount in base currency
base_credit_amt numeric(15,2) No No Debit amount in base currency
upload_flag boolean No No Not used
note character varying(60) No No Transaction memo entered by user or Ship to ID and Location code from Sales Iinvoice
_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 record was last modified
_modified_by character varying(3) No No User initials that modified this record
sales_tax_no smallint[] Yes No '{0,0,0,0}'::smallint[] Sales tax codes 1 - 4 used on transaction
sales_tax_rate numeric(7,4)[] Yes No '{0,0,0,0}'::numeric[] Sales tax rates 1 - 4 used on transaction
sales_tax_total numeric(15,2)[] Yes No '{0,0,0,0}'::numeric[] Sales tax 1 - 4 amounts on transaction
freight numeric(15,2) No No Freight amount on transaction
cust_po_no character varying(20) No No Customer Purchase Order number
payment_account character varying(24) No No General Ledger account used for payment - links to gl_accounts.account_no
last_four character varying(4) No No Last 4 characters from credit card
payment_method integer No No Payment method - links to payment_methods.id

Constraints

Name Type Definition Comment
ar_transactions_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL