nds_glmast_gl_nds_glbal
The nds_glmast_gl_nds_glbal Table contains the balance information for the General Ledger accounts including beginning balances and the accounts' balance for each period.
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.
nds_glmast_gl_nds_glbal Table |
|
Field |
Type |
Gl_Mast_ID |
varchar(20) |
Row_Index |
int(11) |
Numeric_Bytes |
int(11) |
Alpha_Fields |
int(11) |
Record_Type_1 |
int(11) |
Beginning_Balance |
decimal(14,2) |
Balance_Period_1 |
decimal(14,2) |
Balance_Period_2 |
decimal(14,2) |
Balance_Period_3 |
decimal(14,2) |
Balance_Period_4 |
decimal(14,2) |
Balance_Period_5 |
decimal(14,2) |
Balance_Period_6 |
decimal(14,2) |
Balance_Period_7 |
decimal(14,2) |
Balance_Period_8 |
decimal(14,2) |
Balance_Period_9 |
decimal(14,2) |
Balance_Period_10 |
decimal(14,2) |
Balance_Period_11 |
decimal(14,2) |
Balance_Period_12 |
decimal(14,2) |
Balance_Period_13 |
decimal(14,2) |
Balance_Period_14 |
decimal(14,2) |
Post_Date |
int(11) |
nFiller_1 |
bigint(20) |
nFiller_2 |
bigint(20) |
nFiller_3 |
bigint(20) |
nFiller_4 |
bigint(20) |
nFiller_5 |
bigint(20) |
nFiller_6 |
bigint(20) |
nFiller_7 |
bigint(20) |
nFiller_8 |
bigint(20) |
nFiller_9 |
bigint(20) |
nFiller_10 |
bigint(20) |
nFiller_11 |
bigint(20) |
nFiller_12 |
bigint(20) |
nFiller_13 |
bigint(20) |
nFiller_14 |
bigint(20) |
aFiller_1 |
char(1) |
aFiller_2 |
char(1) |
aFiller_3 |
char(1) |
aFiller_4 |
char(1) |
aFiller_5 |
char(1) |
aFiller_6 |
char(1) |