GLAMOUNTS FILE
General Ledger Amounts
The General Ledger Amounts-Period file contains beginning and period account
balances by accounting unit, account, and subaccount.
REFERENCED BY
CA290 FB120 FB20.1 FB20.3 FB20.4 FB20.6
FB20.7 GL281 GL290 GL291 GL90.1 GL90.4
GL198 GLOP.1 GL135 GL195 GL196 GLSV.1
RW80.1 GLRV.1 GL122 GL296 GL30.2 GL00.7
GL20.2 GL20.6 GL295 GL320
UPDATED BY
CA110 GL110 GL120 GL146 GL167 GL190
GL199 GL300 GL325 GL330 GL45.1 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GAM-COMPANY Numeric 4 CA110 GL110
Company The company number represents an GL146 GL167
established company and is entered on GL190 GL199
all function codes. GL325 GL330
GL45.1 GL500
GLSV.1
GAM-FISCAL-YEAR Numeric 4 CA110 GL146
Fiscal Year Select the fiscal year. If you leave GL167 GL190
this field blank, the current year GL199 GL325
defaults. GL330 GL45.1
GL500 GLSV.1
GAM-ACCT-UNIT Alpha 15 CA110 GL146
Accounting Unit The accounting unit is a shorthand GL167 GL190
notation representing the variable level GL199 GL325
number. When used in the General Ledger GL330 GL45.1
Account Master file, the accounting unit GL500 GLSV.1
must be defined in the General Ledger
Names file as a posting accounting unit.
GAM-ACCOUNT Numeric 6 CA110 GL146
Account This field along with the accounting GL167 GL190
unit and subaccount make up the location GL199 GL325
(account) where amounts and other GL330 GL45.1
account information is stored. GL500 GLSV.1
GAM-SUB-ACCOUNT Numeric 4 CA110 GL146
Subaccount This field along with the accounting GL167 GL190
unit and account make up the location GL199 GL325
(account) where amounts and other GL330 GL45.1
account information is stored. GL500 GLSV.1
GAM-VAR-LEVELS Alpha 30 CA110 GL120
Variable Levels A level that represents the location of GL146 GL167
an accounting unit in an organization's GL190 GL199
level structure. GL325 GL330
GL45.1 GL500
GLSV.1
GAM-CHART-NAME Alpha 12 CA110 GL146
Chart Name This is the name you assigned to the GL167 GL190
chart of accounts when you defined your GL199 GL325
company structure in the General Ledger GL330 GL45.1
system. GL500 GLSV.1
GAM-DB-BEG-BAL Currency 15.2 FB20.6 GL110
Debit Beginning The debit beginning balance. GL167 GL199
Balance GL281 GL291
GL325 GL500
GLSV.1
GAM-CR-BEG-BAL Currency 15.2 FB20.6 GL110
Credit Beginning The credit beginning balance. GL167 GL199
Balance GL281 GL291
GL325 GL500
GLSV.1
GAM-DB-AMOUNT Currency 15.2 Occurs 13 Times FB20.6 GL110
Debit Amount The debit amount. GL146 GL167
GL190 GL281
GL291 GL325
GL330 GL45.1
GL500 GLSV.1
GAM-CR-AMOUNT Currency 15.2 Occurs 13 Times FB20.6 GL110
Credit Amount The credit amount. GL146 GL167
GL190 GL281
GL291 GL325
GL330 GL45.1
GL500 GLSV.1
GAM-ACTIVITY-FLAG Alpha 1 Occurs 13 Times GL146 GL167
Activity Flag This field indicates if an Activity is GL190 GL325
required. GL45.1 GL500
GAM-MAINT-DATE Numeric 8 (yyyymmdd) GL120 GL146
Maintenance Date The date last changed. GL167 GL190
GL199 GL330
GL45.1 GL500
GAM-MAINT-TIME Numeric 6 (hhmmss) GL120 GL146
Maintenance Time The time last changed. GL167 GL190
GL199 GL330
GL45.1 GL500
GAM-CPAMT-DR Derived
Current Period Amt The current period debit amount.
Debit
GAM-CPAMT-CR Derived
Current Period Amt The current period credit amount.
Credit
GAM-CPAMT Derived
Current Period The total current period amount.
Amount
GAM-CYBAMT Derived
Cybamt The current year beginning amount.
GAM-CUR-PD-SUM-DR Derived
Cur Pd Sum Dr The current period summary debit
amount.
GAM-CUR-PD-SUM-CR Derived
Cur Pd Sum Cr The current period summary credit
amount.
GAM-CUR-PD-SUM Derived
Cur Pd Sum The current period summary amount.
GAM-CYDAMT Derived
Cydamt The current year-to-date amount.
GAM-CYPAMT1-DR Derived
Period 1 Base Debit The current year period 1 debit amount.
Amount
GAM-CYPAMT1-CR Derived
Period 1 Base The current year period 1 credit
Credit Amount amount.
GAM-CYPAMT1 Derived
Period 1 Base Amount The current year period 1 amount.
GAM-CYPAMT2-DR Derived
Period 2 Base Debit The current year period 2 debit amount.
Amount
GAM-CYPAMT2-CR Derived
Period 2 Base The current year period 2 credit
Credit Amount amount.
GAM-CYPAMT2 Derived
Period 2 Base Amount The current year period 2 amount.
GAM-CYPAMT3-DR Derived
Period 3 Base Debit The current year period 3 debit amount.
Amount
GAM-CYPAMT3-CR Derived
Period 3 Base The current year period 3 credit
Credit Amount amount.
GAM-CYPAMT3 Derived
Period 3 Base Amount The current year period 3 amount.
GAM-CYPAMT4-DR Derived
Period 4 Base Debit The current year period 4 debit amount.
Amount
GAM-CYPAMT4-CR Derived
Period 4 Base The current year period 4 credit
Credit Amount amount.
GAM-CYPAMT4 Derived
Period 4 Base Amount The current year period 4 amount.
GAM-CYPAMT5-DR Derived
Period 5 Base Debit The current year period 5 debit amount.
Amount
GAM-CYPAMT5-CR Derived
Peirod 5 Base The current year period 5 credit
Credit Amount amount.
GAM-CYPAMT5 Derived
Peirod 5 Base Amount The current year period 5 amount.
GAM-CYPAMT6-DR Derived
Period 6 Base Debit The current year period 6 debit amount.
Amount
GAM-CYPAMT6-CR Derived
Period 6 Base The current year period 6 credit
Credit Amount amount.
GAM-CYPAMT6 Derived
Period 6 Base Amount The current year period 6 amount.
GAM-CYPAMT7-DR Derived
Period 7 Base Debit The current year period 7 debit amount.
Amount
GAM-CYPAMT7-CR Derived
Period 7 Base The current year period 7 credit
Credit Amount amount.
GAM-CYPAMT7 Derived
Period 7 Base Amount The current year period 7 amount.
GAM-CYPAMT8-DR Derived
Period 8 Base The current year period 8 debit amount.
Detail Amount
GAM-CYPAMT8-CR Derived
Period 8 Base The current year period 8 credit
Credit Amount amount.
GAM-CYPAMT8 Derived
Period 8 Base Amount The current year period 8 amount.
GAM-CYPAMT9-DR Derived
Period 9 Base Debit The current year period 9 debit amount.
Amount
GAM-CYPAMT9-CR Derived
Period 9 Base The current year period 9 credit
Credit Amount amount.
GAM-CYPAMT9 Derived
Period 9 Base Amount The current year period 9 amount.
GAM-CYPAMT10-DR Derived
Period 10 Base The current year period 10 debit
Debit Amount amount.
GAM-CYPAMT10-CR Derived
Period 10 Base The current year period 10 credit
Credit Amount amount.
GAM-CYPAMT10 Derived
Period 10 Baes The current year period 10 amount.
Amount
GAM-CYPAMT11-DR Derived
Period 11 Base The current year period 11 debit
Debit Amount amount.
GAM-CYPAMT11-CR Derived
Period 11 Base The current year period 11 credit
Credit Amount amount.
GAM-CYPAMT11 Derived
Period 11 Base The current year period 11 amount.
Amount
GAM-CYPAMT12-DR Derived
Period 12 Base The current year period 12 debit
Debit Amount amount.
GAM-CYPAMT12-CR Derived
Period 12 Base The current year period 12 credit
Credit Amount amount.
GAM-CYPAMT12 Derived
Period 12 Base The current year period 12 amount.
Amount
GAM-CYPAMT13-DR Derived
Period 13 Base The current year period 13 debit
Debit Amount amount.
GAM-CYPAMT13-CR Derived
Period 13 Base The current year period 13 credit
Credit Amount amount.
GAM-CYPAMT13 Derived
Period 13 Base The current year period 13 amount.
Amount
GAM-CPVAR-PCT Derived
Cpvar Pct The percent variance between the
current period budget and current period
amount.
GAM-BLANK Derived
Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
GAM-CPAMT-THOU Derived
Cpamt Thou The current period amount divided by
1,000.
GAM-CYDAMT-THOU Derived
Cydamt Thou The current year-to-date amount divided
by 1,000.
GAM-PARENT-OBJ-ID Numeric 12 GL146 GL167
Parent Obj Id This is the parent object identifier. GL190 GL199
This unique key facilitates drill around GL325 GL45.1
to the parent record.
GLAMOUNTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GAMSET1 COMPANY CA110 CA290
FISCAL-YEAR FB120 FB20.1
ACCT-UNIT FB20.3 FB20.4
ACCOUNT FB20.6 FB20.7
SUB-ACCOUNT GL110 GL146
GL167 GL190
GL199 GL281
GL290 GL291
GL300 GL325
GL330 GL45.1
GL500 GL90.1
GL90.4 GL198
GLOP.1
GAMSET2 FISCAL-YEAR FB120 GL135
COMPANY GL195 GL196
VAR-LEVELS GL281 GL290
ACCOUNT GL291 GL325
SUB-ACCOUNT GLSV.1 RW80.1
ACCT-UNIT GLRV.1
GAMSET3 COMPANY GL120 GL122
ACCT-UNIT GL296 GL30.2
ACCOUNT GL500 GL00.7
SUB-ACCOUNT GL20.2 GL20.6
FISCAL-YEAR
GAMSET4 FISCAL-YEAR GL199 GL281
COMPANY GL290 GL295
ACCOUNT GL320 GL325
SUB-ACCOUNT GLSV.1 GLRV.1
VAR-LEVELS
ACCT-UNIT
GAMSET5 FISCAL-YEAR GLSV.1 GLRV.1
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
COMPANY
ACCT-UNIT
GAMSET6 FISCAL-YEAR GLSV.1 GLRV.1
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
COMPANY
ACCT-UNIT
GAMSET7 COMPANY
FISCAL-YEAR
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
GAMSET8 MAINT-DATE KeyChange GLOP.1
MAINT-TIME
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
GAMSET9 PARENT-OBJ-ID
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
GLAMOUNTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Unit GLNAMES Required
GAM-COMPANY -> GLN-COMPANY (GLNSET1)
GAM-ACCT-UNIT -> GLN-ACCT-UNIT
Budget 1 FBDETAIL Not Required
GAM-COMPANY -> FBD-COMPANY
GAM-FISCAL-YEAR -> FBD-FISCAL-YEAR
1 -> FBD-BUDGET-NBR
GAM-ACCT-UNIT -> FBD-ACCT-UNIT
GAM-ACCOUNT -> FBD-ACCOUNT
GAM-SUB-ACCOUNT -> FBD-SUB-ACCOUNT
Chart Detail GLCHARTDTL Required
GAM-CHART-NAME -> GDT-CHART-NAME
GAM-ACCOUNT -> GDT-ACCOUNT
GAM-SUB-ACCOUNT -> GDT-SUB-ACCOUNT
Company GLSYSTEM Required
GAM-COMPANY -> GLS-COMPANY
Glmaster GLMASTER Required
GAM-COMPANY -> GLM-COMPANY
GAM-ACCT-UNIT -> GLM-ACCT-UNIT
GAM-ACCOUNT -> GLM-ACCOUNT
GAM-SUB-ACCOUNT -> GLM-SUB-ACCOUNT
GLAMOUNTS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cam Curr 1 CUAMOUNT
GAM-PARENT-OBJ-ID -> CAM-PARENT-OBJ-ID
3 -> CAM-AMT-TYPE
GAM-COMPANY -> CAM-COMPANY
GAM-ACCT-UNIT -> CAM-ACCT-UNIT
GAM-ACCOUNT -> CAM-ACCOUNT
GAM-SUB-ACCOUNT -> CAM-SUB-ACCOUNT
GAM-VAR-LEVELS -> CAM-VAR-LEVELS
GAM-FISCAL-YEAR -> CAM-FISCAL-YEAR
CAM-CURRENCY-CODE
Cam Curr 2 CUAMOUNT
GAM-PARENT-OBJ-ID -> CAM-PARENT-OBJ-ID
4 -> CAM-AMT-TYPE
GAM-COMPANY -> CAM-COMPANY
GAM-ACCT-UNIT -> CAM-ACCT-UNIT
GAM-ACCOUNT -> CAM-ACCOUNT
GAM-SUB-ACCOUNT -> CAM-SUB-ACCOUNT
GAM-VAR-LEVELS -> CAM-VAR-LEVELS
GAM-FISCAL-YEAR -> CAM-FISCAL-YEAR
CAM-CURRENCY-CODE
Company Trans GLTRANS
GAM-COMPANY -> GLT-TO-COMPANY
GAM-FISCAL-YEAR -> GLT-FISCAL-YEAR
GLS-DEFAULT-PERIOD -> GLT-ACCT-PERIOD
GAM-ACCOUNT -> GLT-ACCOUNT
GAM-SUB-ACCOUNT -> GLT-SUB-ACCOUNT
GLT-ACCT-UNIT
GLT-OBJ-ID
Consol Parent GLCONSOL
GAM-PARENT-OBJ-ID -> GCN-OBJ-ID
"A" -> GCN-TRANS-TYPE
GAM-COMPANY -> GCN-COMPANY
GCN-VAR-LEVELS
GCN-ACCOUNT
GCN-SUB-ACCOUNT
GCN-FISCAL-YEAR
GCN-LEVEL-DEPTH
GCN-CURRENCY-CODE
GCN-BUDGET-NBR
Trans One Prd GLTRANS
GAM-COMPANY -> GLT-TO-COMPANY
GAM-FISCAL-YEAR -> GLT-FISCAL-YEAR
GLS-DEFAULT-PERIOD -> GLT-ACCT-PERIOD
GAM-ACCT-UNIT -> GLT-ACCT-UNIT
GAM-ACCOUNT -> GLT-ACCOUNT
GAM-SUB-ACCOUNT -> GLT-SUB-ACCOUNT
GLT-POSTING-DATE
GLT-SYSTEM
GLT-CONTROL-GROUP
GLT-JE-TYPE
GLT-LINE-NBR
GLT-COMPANY
GLT-JE-SEQUENCE
Trans One Prds GLTRANS
GAM-COMPANY -> GLT-TO-COMPANY
GAM-ACCOUNT -> GLT-ACCOUNT
GAM-SUB-ACCOUNT -> GLT-SUB-ACCOUNT
GAM-ACCT-UNIT -> GLT-ACCT-UNIT
GLS-FISCAL-YEAR -> GLT-FISCAL-YEAR
GLT-ACCT-PERIOD
GLT-SYSTEM
GLT-CONTROL-GROUP
GLT-JE-TYPE
GLT-JE-SEQUENCE
GLT-LINE-NBR
GLT-COMPANY
|
