hjrnl_01-hjrnl_14
The hjrnl_01 - hjrnl14 Tables contains the transaction information for the historical journal periods, including the date, reference, amount and General Ledger account.
Notes:
For information about interpreting General Ledger Tables, see Understanding MySQL Tables.
To view other General Ledger Tables, see the Invision General Ledger MySQL Database Overview.
For more information about a field, click the in the Description column.
|
hjrnl_01 - hjrnl_14 Tables |
|
|
Field |
Type |
|
GL_NumberNumber |
varchar(20) |
|
Row_Index |
int(11) |
|
Date |
int(11) |
|
Description |
varchar(30) |
|
Journal_Code |
char(2) |
|
Reference_Number |
varchar(20) |
|
GL_Account_Number |
varchar(20) |
|
Amount |
decimal(14,2) |
|
Posted |
int(11) |
|
Debit_Credit Flag |
int(11) |
|
Application_ID |
bigint(20) |
|
Transaction_Number |
bigint(20) |
|
History_Year |
int(11) |
|
Post_Level |
int(11) |