|
|
GLAMOUNTS FILE
General Ledger Amounts-Period
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 GL141 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 GL324 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. GL324 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 GL324
defaults. GL325 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 GL324
number. When used in the General Ledger GL325 GL330
Account Master file, the accounting unit GL45.1 GL500
must be defined in the General Ledger GLSV.1
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 GL324
(account) where amounts and other GL325 GL330
account information is stored. GL45.1 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 GL324
(account) where amounts and other GL325 GL330
account information is stored. GL45.1 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. GL324 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 GL324
company structure in the General Ledger GL325 GL330
system. GL45.1 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 GL324
required. GL325 GL45.1
GL500
GAM-MAINT-DATE Numeric 8 (yyyymmdd) GL120 GL146
Last Date Maintained The date last changed. GL167 GL190
GL199 GL330
GL45.1 GL500
GAM-MAINT-TIME Numeric 6 (hhmmss) GL120 GL146
Last Time Maintained 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
Current Year Per 1 The current year period 1 debit amount.
Debit Amt
GAM-CYPAMT1-CR Derived
Current Year Per 1 The current year period 1 credit amount.
Credit Amt
GAM-CYPAMT1 Derived
Current Year Per 1 The current year period 1 amount.
Amount
GAM-CYPAMT2-DR Derived
Current Year Per 2 The current year period 2 debit amount.
Debit Amt
GAM-CYPAMT2-CR Derived
Current Year Per 2 The current year period 2 credit amount.
Credit Amt
GAM-CYPAMT2 Derived
Current Year Per 2 The current year period 2 amount.
Amount
GAM-CYPAMT3-DR Derived
Current Year Per 3 The current year period 3 debit amount.
Debit Amt
GAM-CYPAMT3-CR Derived
Current Year Per 3 The current year period 3 credit amount.
Credit Amt
GAM-CYPAMT3 Derived
Current Year Per 3 The current year period 3 amount.
Amount
GAM-CYPAMT4-DR Derived
Current Year Per 4 The current year period 4 debit amount.
Debit Amt
GAM-CYPAMT4-CR Derived
Current Year Per 4 The current year period 4 credit amount.
Credit Amt
GAM-CYPAMT4 Derived
Current Year Per 4 The current year period 4 amount.
Amount
GAM-CYPAMT5-DR Derived
Current Year Per 5 The current year period 5 debit amount.
Debit Amt
GAM-CYPAMT5-CR Derived
Current Year Per 5 The current year period 5 credit amount.
Credit Amt
GAM-CYPAMT5 Derived
Current Year Per 5 The current year period 5 amount.
Amount
GAM-CYPAMT6-DR Derived
Current Year Per 6 The current year period 6 debit amount.
Debit Amt
GAM-CYPAMT6-CR Derived
Current Year Per 6 The current year period 6 credit amount.
Credit Amt
GAM-CYPAMT6 Derived
Current Year Per 6 The current year period 6 amount.
Amount
GAM-CYPAMT7-DR Derived
Current Year Per 7 The current year period 7 debit amount.
Debit Amt
GAM-CYPAMT7-CR Derived
Current Year Per 7 The current year period 7 credit amount.
Credit Amt
GAM-CYPAMT7 Derived
Current Year Per 7 The current year period 7 amount.
Amount
GAM-CYPAMT8-DR Derived
Current Year Per 8 The current year period 8 debit amount.
Debit Amt
GAM-CYPAMT8-CR Derived
Current Year Per 8 The current year period 8 credit amount.
Credit Amt
GAM-CYPAMT8 Derived
Current Year Per 8 The current year period 8 amount.
Amount
GAM-CYPAMT9-DR Derived
Current Year Per 9 The current year period 9 debit amount.
Debit Amt
GAM-CYPAMT9-CR Derived
Current Year Per 9 The current year period 9 credit amount.
Credit Amt
GAM-CYPAMT9 Derived
Current Year Per 9 The current year period 9 amount.
Amount
GAM-CYPAMT10-DR Derived
Current Year Per 10 The current year period 10 debit amount.
Debit Amt
GAM-CYPAMT10-CR Derived
Current Year Per 10 The current year period 10 credit
Credit Amt amount.
GAM-CYPAMT10 Derived
Current Year Per 10 The current year period 10 amount.
Amount
GAM-CYPAMT11-DR Derived
Current Year Per 11 The current year period 11 debit amount.
Debit Amt
GAM-CYPAMT11-CR Derived
Current Year Per 11 The current year period 11 credit
Credit Amt amount.
GAM-CYPAMT11 Derived
Current Year Per 11 The current year period 11 amount.
Amount
GAM-CYPAMT12-DR Derived
Current Year Per 12 The current year period 12 debit amount.
Debit Amt
GAM-CYPAMT12-CR Derived
Current Year Per 12 The current year period 12 credit
Credit Amt amount.
GAM-CYPAMT12 Derived
Current Year Per 12 The current year period 12 amount.
Amount
GAM-CYPAMT13-DR Derived
Current Year Per 13 The current year period 13 debit amount.
Debit Amt
GAM-CYPAMT13-CR Derived
Current Year Per 13 The current year period 13 credit
Credit Amt amount.
GAM-CYPAMT13 Derived
Current Year Per 13 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.
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 GL141
GL146 GL167
GL190 GL199
GL281 GL290
GL291 GL300
GL324 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 GLSV.1
SUB-ACCOUNT RW80.1 GLRV.1
ACCT-UNIT
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 GLSV.1
SUB-ACCOUNT 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
GLAMOUNTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Unit GLNAMES Required
GAM-COMPANY -> GLN-COMPANY
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
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
GAM-FISCAL-YEAR -> GLT-FISCAL-YEAR
GLT-ACCT-PERIOD
GLT-SYSTEM
GLT-CONTROL-GROUP
GLT-JE-TYPE
GLT-JE-SEQUENCE
GLT-LINE-NBR
GLT-COMPANY
|