General Ledger Amounts

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

REFERENCED BY

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	CB10.1
CB15.1	CB15.2	CB150	CB191	CB20.1	CB222
CB30.1	CB45.1	CB46.1	CB500	CB543	CB544
CB55.1	CB554	EE135	EE35.1	EE35.2	EE520
CA195	CA290	FB100	FB101	FB121	FB122
FB145	FB165	FB190	FB20.1	FB20.3	FB20.4
FB20.6	FB20.7	FB21.1	FB30.1	FB31.1	FB40.1
FB40.2	FB40.3	FB45.1	GL141	GL165	GL170
GL191	GL65.1	GL70.1	GL70.2	GL70.3	GL70.5
GL70.6	GL75.1	GL76.1	GL90.1	GL90.4	GL90.6
EX545	IFAC.1	IFEB.1	IFGT.1	MA41.1	MA41.2
MA41.4	MA41.7	MA43.1	MA43.2	MA43.3	MA43.4
MA43.6	MA43.7	MAI1.1	PO136	PO190	PO300
PO520	POCP.1	POI3.1	POII.1	POIJ.1	POIM.1
GLSV.1	GL296

UPDATED BY

CA110	CA190	GL110	GL120	GL146	GL148
GL167	GL190	GL197	GL199	GL300	GL325
GL327	GL330	GL40.1	GL40.2	GL40.3	GL40.7
GL40.8	GL44.1	GL45.1	GL500	FB120	GL147
GL195	GL281	GL290	GL291	GL320	XG870
GL198	GLOP.1	GL135	GL196	RW80.1	GLRV.1
FB11.1	FB111	FB160	FB211	GL122	GL00.7
GL20.2	GL295

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 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 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 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 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 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 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 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 GL199 GL281 GL291 GL325 GL330 GL500 GLSV.1
GAM-CR-BEG-BAL Credit Beginning Balance	Signed 18.2	FB20.6 GL110 GL167 GL199 GL281 GL291 GL325 GL330 GL500 GLSV.1
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
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
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 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 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 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.