| id |
integer |
Yes |
Yes |
nextval('gl_transactions_id_seq'::regclass) |
|
| division |
character varying(3) |
No |
No |
|
The division of the transaction |
| account_no |
character varying(24) |
No |
No |
|
GL Account number |
| currency |
character varying(3) |
No |
No |
|
Currency of the account posted to |
| date |
date |
No |
No |
|
Transaction date |
| trans_no |
character varying(10) |
No |
No |
|
Transaction number |
| recno |
integer |
No |
No |
|
Record number for th eline of the transaction starting from 1, up to the number of lines in this complete transaction |
| where_from |
character varying(4) |
No |
No |
|
Where the transaction was posted from AP = Accounts payable AR = Accounts Receivable GL = General Ledger SORD = Sales order invoiced PORD = Purchase Order INVR = Inventory adjustment LWAY = Deposit order MFG - Production Order build PAYR = Payroll IMP = Import |
| gl_user |
character varying(12) |
No |
No |
|
User initials that posted the transaction |
| gl_memo |
character varying(60) |
No |
No |
|
The memo the user added for posting or sub ledgers that post details automatically |
| mf_who |
character varying(10) |
No |
No |
|
The type of transaction |
| mf_key |
character varying(20) |
No |
No |
|
The code that transaction came from. Can be Vendor Customer Employee code |
| mf_tran |
character varying(25) |
No |
No |
|
The invoice or PO number the transaction came from. |
| reconcile_date |
date |
No |
No |
|
Date the transaction was reconciled |
| reconcile_flag |
boolean |
No |
No |
|
Recconcile flag TRUE = Reconciled FALSE = Not reconciled |
| post_date |
date |
No |
No |
|
The date the transaction was posted on. Comes from the users log on date. |
| debit_amt |
numeric(15,2) |
No |
No |
|
Amount debited |
| credit_amt |
numeric(15,2) |
No |
No |
|
Amount credited |
| source_dept |
character varying(3) |
No |
No |
|
|
| rate_method |
character varying(1) |
No |
No |
|
Currency rate method used / = Direct * = Indirect |
| rate |
numeric(13,7) |
No |
No |
|
Currency rate used |
| frn_debit_amt |
numeric(15,2) |
No |
No |
|
Foreign amount debited |
| frn_credit_amt |
numeric(15,2) |
No |
No |
|
Foreign amount credited |
| job_cost_flag |
boolean |
No |
No |
|
Not used |
| recurr_entry |
boolean |
No |
No |
|
|
| _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 |
|
|
| job_no |
character varying(10) |
No |
No |
|
|
| job_acct_no |
character varying(10) |
No |
No |
|
|