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 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.
|
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) |