| id |
integer |
Yes |
Yes |
nextval('ap_transactions_id_seq'::regclass) |
Unique identifier |
| vendor_no |
character varying(20) |
No |
No |
|
Vendor code - links to vendors.vendor_no |
| link_date |
date |
No |
No |
|
Transaction date |
| link_trans_no |
character varying(10) |
No |
No |
|
General Ledger transaction number |
| recno |
integer |
No |
No |
|
Record number for transactions with multiple records |
| date |
date |
No |
No |
|
Transaction date |
| credit_amt |
numeric(15,2) |
No |
No |
|
Credit amount |
| debit_amt |
numeric(15,2) |
No |
No |
|
Debit amount |
| balance |
numeric(15,2) |
No |
No |
|
Balance outstanding on transaction |
| trans_no |
character varying(10) |
No |
No |
|
General Ledger transaction number - links to gl_transactions.trans_no |
| ref_no |
character varying(25) |
No |
No |
|
Reference number - Invoice or Cheque number |
| code |
character varying(1) |
No |
No |
|
Transaction code; C = Credit memo D = Debit memo I = Invoice P = Payment |
| open_close_flag |
character varying(1) |
No |
No |
|
Transaction status flag; C = Closed O = Open |
| 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 |
| apf_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 |
|
Credit amount in base currency |
| po_no |
character varying(10) |
No |
No |
|
Purchase Order number |
| cheque_void_flag |
character varying(1) |
No |
No |
|
Payment Void flag; 'Y' = payment was voided |
| note |
character varying(60) |
No |
No |
|
Note or memo added to transaction |
| _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 1 - 4 rates used on transaction |
| sales_tax_total |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0}'::numeric[] |
Sales tax 1 - 4 totals on transaction |
| freight |
numeric(15,2) |
No |
No |
|
Freight amount on transaction |