General Ledger Amounts

The General Ledger Amounts-Period file contains beginning and period account balances by accounting unit, account, and subaccount.

REFERENCED BY

AC191	AC40.4	AC41.4	AC42.1	AM180	AP125
AP126	AP131	AP170	AP193	AP20.1	AP20.2
AP20.3	AP20.4	AP20.5	AP20.7	AP21.1	AP23.1
AP25.1	AP25.2	AP26.1	AP27.1	AP30.2	AP30.4
AP520	API1.1	API2.1	BR41.4	BR44.1	CB10.1
CB15.1	CB15.2	CB150	CB191	CB20.1	CB222
CB30.1	CB45.1	CB46.1	CB500	CB543	CB544
CB55.1	CB554	CX100	CX20.1	CX20.2	CX20.4
CX20.5	CX220	CX30.1	CX300	CX506	CXCP.1
EE135	EE35.1	EE35.2	EE520	CA195	CA290
FB121	FB122	FB145	FB165	FB190	FB40.1
FB40.2	FB40.3	FB45.1	GL165	GL170	GL65.1
GL70.1	GL70.2	GL70.3	GL70.5	GL70.6	GL75.1
GL76.1	GL90.1	GL90.4	GL90.6	DR100	IC140
IC141	IC142	IC222	IC66.1	IC83.1	CU01.1
CU01.2	CU02.1	CU02.2	CU03.1	CU10.1	CU10.2
EX545	GL02.1	GL02.2	GL02.3	GL02.6	GL03.2
GL03.4	GL10.1	IFAC.1	IFEB.1	IFGT.1	MA180
MA41.1	MA41.2	MA41.4	MA41.7	MA42.2	MA43.2
MA43.7	MA44.1	MA44.2	MA530	MA531	MA60.2
MA60.3	MA60.5	MA61.1	MA66.2	MA67.2	MA67.3
MA68.2	MA68.3	MA68.5	MA70.1	MA75.1	MA80.1
MAI1.1	ML165	ML65.1	PD10.1	PD10.2	PD130
PD20.1	PD20.2	PD20.3	PO100	PO101	PO122
PO131	PO136	PO150	PO190	PO20.1	PO20.6
PO20.9	PO21.1	PO21.2	PO21.3	PO21.4	PO21.5
PO22.1	PO22.3	PO22.4	PO23.1	PO24.1	PO25.1
PO25.5	PO25.6	PO25.7	PO26.2	PO26.3	PO26.4
PO26.5	PO26.6	PO26.7	PO26.9	PO27.2	PO28.2
PO29.1	PO30.1	PO30.2	PO30.3	PO30.4	PO300
PO31.1	PO31.2	PO32.2	PO32.4	PO33.1	PO34.1
PO35.1	PO36.1	PO36.2	PO38.1	PO39.1	PO39.2
PO44.1	PO50.1	PO52.1	PO520	PO536	PO54.5
POCP.1	POI3.1	POID.1	POII.1	POIJ.1	POIK.1
POIM.1	RQ10.1	RQ10.2	RQ10.3	RQ10.4	RQ11.1
RQ12.1	RQ13.1	RQ13.2	RQ35.1	RQ500	RQIB.1
RQIF.1	RQIJ.1	WAOP.1	WH130	WH132	WH190
WH20.2	WH20.7	WH222	WH30.1	WH30.2	WH30.3
WH30.4	WH31.1	WH31.2	WH31.3	WH31.4	WH32.1
WH32.2	WH32.3	WH32.4	WH32.5	WH33.1	WH33.2
WH33.3	WH33.4	WH33.5	WH33.6	WH33.8	WH33.9
WH34.1	WH34.2	WH34.3	WH34.4	WH40.1	WH40.2
WH520	WH830	ZW130	AD190	AD191	AD290
AD97.2	AD97.3	AD98.2	AD98.3	FB100	FB101
FB120	FB20.1	FB20.3	FB20.4	FB20.6	FB20.7
FB21.1	FB30.1	FB31.1	GL141	GL147	GL191
GL195	GL281	GL320	GL198	GLOP.1	ML290
ML291	GL135	GLSV.1	RW80.1	GL296	GL295

UPDATED BY

CA110	CA190	FB11.1	FB111	FB160	FB211
GL110	GL120	GL122	GL146	GL148	GL167
GL190	GL194	GL196	GL197	GL199	GL290
GL291	GL300	GL325	GL327	GL330	GL40.1
GL40.2	GL40.3	GL40.7	GL40.8	GL44.1	GL45.1
GL500	GL00.7	GL20.2	GLRV.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
GAM-COMPANY Element: Company	Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	CA110 GL110 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL325 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1
GAM-FISCAL-YEAR Element: Fiscal Year	Numeric 4 Select the fiscal year. If you leave this field blank, the current year defaults.	CA110 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL325 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1
GAM-ACCT-UNIT Element: Accounting Unit	Alpha 15 The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	CA110 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL325 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1
GAM-ACCOUNT Element: Account	Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	CA110 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL325 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1
GAM-SUB-ACCOUNT Element: Subaccount	Numeric 4 This field along with the accounting unit and account make up the location (account) where amounts and other account information is stored.	CA110 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL325 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1
GAM-VAR-LEVELS Element: Variable Levels	Alpha 30 A level that represents the location of an accounting unit in an organization's level structure.	CA110 GL120 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL325 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1
GAM-CHART-NAME Element: Chart Name	Alpha 12 This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system.	CA110 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL325 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1
GAM-DB-BEG-BAL Debit Beginning Balance	Signed 18.2	FB20.6 GL110 GL167 GL194 GL199 GL281 GL291 GL325 GL330 GL500 GLSV.1 ML291
GAM-CR-BEG-BAL Credit Beginning Balance	Signed 18.2	FB20.6 GL110 GL167 GL194 GL199 GL281 GL291 GL325 GL330 GL500 GLSV.1 ML291
GAM-DB-AMOUNT Element: Debit Amount	Signed 18.2 Occurs 13 Times The debit amount.	FB20.6 GL110 GL146 GL148 GL167 GL190 GL197 GL281 GL291 GL325 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1 ML291
GAM-CR-AMOUNT Element: Credit Amount	Signed 18.2 Occurs 13 Times The credit amount.	FB20.6 GL110 GL146 GL148 GL167 GL190 GL197 GL281 GL291 GL325 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1 ML291
GAM-ACTIVITY-FLAG Element: Activity Flag	Alpha 1 Occurs 13 Times This field indicates if transaction activity has occurred in a period.	GL146 GL148 GL167 GL190 GL197 GL325 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500
GAM-MAINT-DATE Element: Maint Date	Numeric 8 (yyyymmdd) The date last changed.	GL120 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500
GAM-MAINT-TIME Element: Sys Time	Numeric 6 (hhmmss)	GL120 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500
GAM-CPAMT-DR Current Period Amt Debit	Derived The current period debit amount.
GAM-CPAMT-CR Current Period Amt Credit	Derived The current period credit amount.
GAM-CPAMT Element: Cpamt	Derived The total current period amount.
GAM-CYBAMT Element: Cybamt	Derived The current year beginning amount.
GAM-CUR-PD-SUM-DR Element: Cur Pd Sum Dr	Derived The current period summary debit amount.
GAM-CUR-PD-SUM-CR Element: Cur Pd Sum Cr	Derived The current period summary credit amount.
GAM-CUR-PD-SUM Element: Cur Pd Sum	Derived The current period summary amount.
GAM-CYDAMT Element: Cydamt	Derived The current year-to-date amount.
GAM-CYPAMT1-DR Element: Cypamt1 Dr	Derived The current year period 1 debit amount.
GAM-CYPAMT1-CR Element: Cypamt1 Cr	Derived The current year period 1 credit amount.
GAM-CYPAMT1 Element: Cypamt1	Derived The current year period 1 amount.
GAM-CYPYTD1 Element: Cypamt1	Derived Current year period year to date period 1.
GAM-CYPAMT2-DR Element: Cypamt2 Dr	Derived The current year period 2 debit amount.
GAM-CYPAMT2-CR Element: Cypamt2 Cr	Derived The current year period 2 credit amount.
GAM-CYPAMT2 Element: Cypamt2	Derived The current year period 2 amount.
GAM-CYPYTD2 Element: Cypamt2	Derived Current year period year to date period 2.
GAM-CYPAMT3-DR Element: Cypamt3 Dr	Derived The current year period 3 debit amount.
GAM-CYPAMT3-CR Element: Cypamt3 Cr	Derived The current year period 3 credit amount.
GAM-CYPAMT3 Element: Cypamt3	Derived The current year period 3 amount.
GAM-CYPYTD3 Element: Cypamt3	Derived Current year period year to date period 3.
GAM-CYPAMT4-DR Element: Cypamt4 Dr	Derived The current year period 4 debit amount.
GAM-CYPAMT4-CR Element: Cypamt4 Cr	Derived The current year period 4 credit amount.
GAM-CYPAMT4 Element: Cypamt4	Derived The current year period 4 amount.
GAM-CYPYTD4 Element: Cypamt4	Derived Current year period year to date period 4.
GAM-CYPAMT5-DR Element: Cypamt5 Dr	Derived The current year period 5 debit amount.
GAM-CYPAMT5-CR Element: Cypamt5 Cr	Derived The current year period 5 credit amount.
GAM-CYPAMT5 Element: Cypamt5	Derived The current year period 5 amount.
GAM-CYPYTD5 Element: Cypamt5	Derived Current year period year to date period 5.
GAM-CYPAMT6-DR Element: Cypamt6 Dr	Derived The current year period 6 debit amount.
GAM-CYPAMT6-CR Element: Cypamt6 Cr	Derived The current year period 6 credit amount.
GAM-CYPAMT6 Element: Cypamt6	Derived The current year period 6 amount.
GAM-CYPYTD6 Element: Cypamt6	Derived Current year period year to date period 6.
GAM-CYPAMT7-DR Element: Cypamt7 Dr	Derived The current year period 7 debit amount.
GAM-CYPAMT7-CR Element: Cypamt7 Cr	Derived The current year period 7 credit amount.
GAM-CYPAMT7 Element: Cypamt7	Derived The current year period 7 amount.
GAM-CYPYTD7 Element: Cypamt7	Derived Current year period year to date period 7.
GAM-CYPAMT8-DR Element: Cypamt8 Dr	Derived The current year period 8 debit amount.
GAM-CYPAMT8-CR Element: Cypamt8 Cr	Derived The current year period 8 credit amount.
GAM-CYPAMT8 Element: Cypamt8	Derived The current year period 8 amount.
GAM-CYPYTD8 Element: Cypamt8	Derived Current year period year to date period 8.
GAM-CYPAMT9-DR Element: Cypamt9 Dr	Derived The current year period 9 debit amount.
GAM-CYPAMT9-CR Element: Cypamt9 Cr	Derived The current year period 9 credit amount.
GAM-CYPAMT9 Element: Cypamt9	Derived The current year period 9 amount.
GAM-CYPYTD9 Element: Cypamt9	Derived Current year period year to date period 9.
GAM-CYPAMT10-DR Element: Cypamt10 Dr	Derived The current year period 10 debit amount.
GAM-CYPAMT10-CR Element: Cypamt10 Cr	Derived The current year period 10 credit amount.
GAM-CYPAMT10 Element: Cypamt10	Derived The current year period 10 amount.
GAM-CYPYTD10 Element: Cypamt10	Derived Current year period year to date period 10.
GAM-CYPAMT11-DR Element: Cypamt11 Dr	Derived The current year period 11 debit amount.
GAM-CYPAMT11-CR Element: Cypamt11 Cr	Derived The current year period 11 credit amount.
GAM-CYPAMT11 Element: Cypamt11	Derived The current year period 11 amount.
GAM-CYPYTD11 Element: Cypamt11	Derived Current year period year to date period 11.
GAM-CYPAMT12-DR Element: Cypamt12 Dr	Derived The current year period 12 debit amount.
GAM-CYPAMT12-CR Element: Cypamt12 Cr	Derived The current year period 12 credit amount.
GAM-CYPAMT12 Element: Cypamt12	Derived The current year period 12 amount.
GAM-CYPYTD12 Element: Cypamt12	Derived Current year period year to date period 12.
GAM-CYPAMT13-DR Element: Cypamt13 Dr	Derived The current year period 13 debit amount.
GAM-CYPAMT13-CR Element: Cypamt13 Cr	Derived The current year period 13 credit amount.
GAM-CYPAMT13 Element: Cypamt13	Derived The current year period 13 amount.
GAM-CYPYTD13 Element: Cypamt13	Derived Current year period year to date period 13.
GAM-BLANK Element: Blank	Derived This derived field is always blank. It is used in the Drill Around feature for column headings.
GAM-CPAMT-THOU Element: Cpamt Thou	Derived The current period amount divided by 1,000.
GAM-CYDAMT-THOU Element: Cydamt Thou	Derived The current year-to-date amount divided by 1,000.
GAM-PARENT-VAR-LEV Element: Parent Var Lev	Alpha 30 The variable level address of the parent accounting unit.	CA110 GL120 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL325 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500

GLAMOUNTS FILE INDEX

GLAMOUNTS FILE RELATIONS

ONE TO ONE RELATIONS

GLAMOUNTS FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.