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 General Ledger Tables.
To view other General Ledger Tables, see the INVISION General Ledger Database Overview.
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) |