| id |
integer |
Yes |
Yes |
nextval('gl_history_transactions_id_seq'::regclass) |
Unique identifier |
| division |
character varying(3) |
No |
No |
|
Division code; 000 = non divisionlized company or consolidated division for multi division company Note: if the divsion <> "000" on this record then another duplicate of this record will exist where division = "000" to post the same transaction to the consolidated division - links to gl_history_divisions.division |
| account_no |
character varying(24) |
No |
No |
|
General Ledger account number - links to gl_history_accounts.account_no |
| currency |
character varying(3) |
No |
No |
|
General Ledger account currency; blank = base currency - links to currencies.code |
| date |
date |
No |
No |
|
Transaction date used to set fiscal period for transaction |
| trans_no |
character varying(10) |
No |
No |
|
General Ledger transaction number |
| recno |
integer |
No |
No |
|
Transaction record number, increments sequentially |
| where_from |
character varying(4) |
No |
No |
|
The module that the transaction originated from; AP = Accounts Payable AR = Accounts Receivable GL = General Ledger INVC = Inventory Count INVR = Inventory Receipts LWAY = Sales Deposits MFG = Manufacturing PAYR = Payroll PORD = Purchase Orders SORD = Sales Orders |
| gl_user |
character varying(12) |
No |
No |
|
User initials that posted the transaction |
| gl_memo |
character varying(60) |
No |
No |
|
General Ledger memo created automatically by some subledger transactions or entered manually by the user |
| mf_who |
character varying(10) |
No |
No |
|
Transaction type |
| mf_key |
character varying(20) |
No |
No |
|
The code of the associated record involved in the transaction; Vendor code Customer code Employee code Inventory code |
| mf_tran |
character varying(25) |
No |
No |
|
Document reference or document number for transaction, Invoice or Purchase Order number |
| reconcile_date |
date |
No |
No |
|
Reconcile date for Bank Account transactions |
| reconcile_flag |
boolean |
No |
No |
|
Reconcile flag for Bank Account transactions; FALSE = Not reconciled TRUE = Reconciled |
| post_date |
date |
No |
No |
|
The date the transaction was posted to General Ledger as per user's log on date |
| debit_amt |
numeric(15,2) |
No |
No |
|
Debit amount posted to the General Ledger |
| credit_amt |
numeric(15,2) |
No |
No |
|
Credit amount posted to the General Ledger |
| source_dept |
character varying(3) |
No |
No |
|
Source division for multi divisional companies. Field only populated on the 000 division record showing the division the posting originated from. |
| rate_method |
character varying(1) |
No |
No |
|
Currency rate conversion method used; / = direct * = indirect |
| rate |
numeric(13,7) |
No |
No |
|
Currency conversion rate used |
| frn_debit_amt |
numeric(15,2) |
No |
No |
|
Debit amount posted to the General Ledger in foreign currency |
| frn_credit_amt |
numeric(15,2) |
No |
No |
|
Credit amount posted to the General Ledger in foreign currency |
| job_cost_flag |
boolean |
No |
No |
|
not used |
| recurr_entry |
boolean |
No |
No |
|
Transaction was created by a recurring General Ledger transaction; False = normal transaction True = created by recurring process |
| _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 |
| year_end |
date |
No |
No |
|
Fiscal Year End for this history record |
| job_no |
character varying(10) |
No |
No |
|
Job cost number - links to jobs.job_no |
| job_acct_no |
character varying(10) |
No |
No |
|
Job cost account number - links to jobs.account |