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 |