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 |