jrnl_01-jrnl_14
The jrnl_01-jrnl_14 Tables contains the transaction information for each of the 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.
jrnl_01 - jrnl_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) |
Application_Source |
int(11) |
Transaction_Number |
bigint(20) |
History_Year |
int(11) |
Post_Level |
int(11) |
Post_Level |
int(11) |