| 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 |