nds_glmast_gl_nds

nds_glmast_gl_nds_glbalh

The nds_glmast_gl_nds_glbalh Table contains the historical balance information for the General Ledger accounts including beginning balances and the accounts' balance for each period of the historical year.

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.

nds_glmast_gl_nds_glbalh Table
Field	Type
Gl_Mast_ID	varchar(20)
Row_Index	int(11)
Numeric_Bytes	int(11)
Alpha_Fields	int(11)
Record_Type_3	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)
History_Year	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)