Lawson Insight Technical Documentation |
|
GLAMOUNTS
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
AC191 AC40.4 AC41.4 AC42.1 AP125 AP126
AP25.1 AP25.2 AP26.1 AP27.1 AP30.2 BR41.4
BR44.1 CB10.1 CB15.1 CB15.2 CB191 CB20.1
CB30.1 CB500 EE135 EE35.1 EE35.2 EE520
CA195 CA290 FB100 FB101 FB120 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 GL147 GL165
GL170 GL191 GL195 GL281 GL290 GL291
GL320 GL65.1 GL70.1 GL70.2 GL70.3 GL70.5
GL70.6 GL75.1 GL90.1 GL90.4 GL90.6 IC222
GL198 GLOP.1 IFAC.1 IFGT.1 PO150 PO25.1
PO25.6 PO25.7 PO536 POIM.1 GL135 GL196
GLSV.1 RW80.1 GLRV.1 FB11.1 FB111 FB160
FB211 GL122 GL296 GL00.7 GL20.2 GL295
UPDATED BY
CA110 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GAM-COMPANY Numeric 4 CA110 GL110
Element: Company Identifies the AP company if the GL146 GL148
resource type = V. Identifies the HR GL167 GL190
company if the resource type = E. It is GL197 GL199
blank for type A, P or Q resources. GL325 GL327
GL330 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 GLSV.1
GAM-FISCAL-YEAR Numeric 4 CA110 GL146
Element: Fiscal Year Select the fiscal year. If you leave GL148 GL167
this field blank, the current year GL190 GL197
defaults. GL199 GL325
GL327 GL330
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GAM-ACCT-UNIT Alpha 15 CA110 GL146
Element: Accounting UniThe accounting unit is a shorthand GL148 GL167
notation representing the variable level GL190 GL197
number. When used in the General Ledger GL199 GL325
Account Master file, the accounting unit GL327 GL330
must be defined in the General Ledger GL40.1 GL40.2
Names file as a posting accounting unit. GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GAM-ACCOUNT Numeric 6 CA110 GL146
Element: Account This field along with the accounting GL148 GL167
unit and subaccount make up the location GL190 GL197
(account) where amounts and other GL199 GL325
account information is stored. GL327 GL330
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GAM-SUB-ACCOUNT Numeric 4 CA110 GL146
Element: Subaccount This field along with the accounting GL148 GL167
unit and account make up the location GL190 GL197
(account) where amounts and other GL199 GL325
account information is stored. GL327 GL330
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GAM-VAR-LEVELS Alpha 30 CA110 GL120
Element: Variable LevelA level that represents the location of GL146 GL148
an accounting unit in an organization's GL167 GL190
level structure. 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 Alpha 12 CA110 GL146
Element: Chart Name This is the name you assigned to the GL148 GL167
chart of accounts when you defined your GL190 GL197
company structure in the General Ledger GL199 GL325
system. GL327 GL330
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GAM-DB-BEG-BAL Signed 18.2 FB20.6 GL110
Debit Beginning The debit beginning balance. GL167 GL199
Balance GL281 GL291
GL325 GL500
GLSV.1
GAM-CR-BEG-BAL Signed 18.2 FB20.6 GL110
Credit Beginning The credit beginning balance. GL167 GL199
Balance GL281 GL291
GL325 GL500
GLSV.1
GAM-DB-AMOUNT Signed 18.2 Occurs 13 Times FB20.6 GL110
Element: Debit Amount The debit amount. 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 Signed 18.2 Occurs 13 Times FB20.6 GL110
Element: Credit Amount The credit amount. 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 Alpha 1 Occurs 13 Times GL146 GL148
Element: Activity Flag This field indicates if an Activity is GL167 GL190
required. GL197 GL325
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GAM-MAINT-DATE Numeric 8 (yyyymmdd) GL120 GL146
Element: Maintenance DaThe date last changed. GL148 GL167
GL190 GL197
GL199 GL330
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GAM-MAINT-TIME Numeric 6 (hhmmss) GL120 GL146
Element: Sys Time The time last changed. GL148 GL167
GL190 GL197
GL199 GL330
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
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
Element: Cybamt The current year beginning amount.
GAM-CUR-PD-SUM-DR Derived
Element: Cur Pd Sum Dr The current period summary debit
amount.
GAM-CUR-PD-SUM-CR Derived
Element: Cur Pd Sum Cr The current period summary credit
amount.
GAM-CUR-PD-SUM Derived
Element: Cur Pd Sum The current period summary amount.
GAM-CYDAMT Derived
Element: 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
Element: Period 1 Base The current year period 1 amount.
GAM-CYPYTD1 Derived
Element: Period 1 Base Current year period year to date
period 1.
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
Element: Period 2 Base The current year period 2 amount.
GAM-CYPYTD2 Derived
Element: Period 2 Base Current year period year to date
period 2.
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
Element: Period 3 Base The current year period 3 amount.
GAM-CYPYTD3 Derived
Element: Period 3 Base Current year period year to date
period 3.
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
Element: Period 4 Base The current year period 4 amount.
GAM-CYPYTD4 Derived
Element: Period 4 Base Current year period year to date
period 4.
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
Element: Peirod 5 Base The current year period 5 amount.
GAM-CYPYTD5 Derived
Element: Peirod 5 Base Current year period year to date
period 5.
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
Element: Period 6 Base The current year period 6 amount.
GAM-CYPYTD6 Derived
Element: Period 6 Base Current year period year to date
period 6.
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
Element: Period 7 Base The current year period 7 amount.
GAM-CYPYTD7 Derived
Element: Period 7 Base Current year period year to date
period 7.
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
Element: Period 8 Base The current year period 8 amount.
GAM-CYPYTD8 Derived
Element: Period 8 Base Current year period year to date
period 8.
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
Element: Period 9 Base The current year period 9 amount.
GAM-CYPYTD9 Derived
Element: Period 9 Base Current year period year to date
period 9.
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-CYPYTD10 Derived
Period 10 Baes Current year period year to date
Amount period 10.
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-CYPYTD11 Derived
Period 11 Base Current year period year to date
Amount period 11.
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-CYPYTD12 Derived
Period 12 Base Current year period year to date
Amount period 12.
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-CYPYTD13 Derived
Period 13 Base Current year period year to date
Amount period 13.
GAM-CPVAR-PCT Derived
Element: Cpvar Pct The percent variance between the
current period budget and current period
amount.
GAM-BLANK Derived
Element: Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
GAM-CPAMT-THOU Derived
Element: Cpamt Thou The current period amount divided by
1,000.
GAM-CYDAMT-THOU Derived
Element: Cydamt Thou The current year-to-date amount divided
by 1,000.
GAM-PARENT-VAR-LEV Alpha 30 CA110 GL120
Element: Parent Var LevThe variable level address of the parent GL146 GL148
accounting unit. 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
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GAMSET1 COMPANY AC191 AC40.4
FISCAL-YEAR AC41.4 AC42.1
ACCT-UNIT AP125 AP126
ACCOUNT AP25.1 AP25.2
SUB-ACCOUNT AP26.1 AP27.1
AP30.2 BR41.4
BR44.1 CB10.1
CB15.1 CB15.2
CB191 CB20.1
CB30.1 CB500
EE135 EE35.1
EE35.2 EE520
CA110 CA195
CA290 FB100
FB101 FB120
...
GAMSET10 PARENT-VAR-LEV
COMPANY
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
ACCT-UNIT
GAMSET2 FISCAL-YEAR KeyChange FB120 GL135
COMPANY GL195 GL196
VAR-LEVELS GL281 GL290
ACCOUNT GL291 GL325
SUB-ACCOUNT GLSV.1 RW80.1
ACCT-UNIT GLOP.1 GLRV.1
GAMSET3 COMPANY FB11.1 FB111
ACCT-UNIT FB160 FB211
ACCOUNT GL120 GL122
SUB-ACCOUNT GL148 GL296
FISCAL-YEAR GL500 GL00.7
GL20.2
GAMSET4 FISCAL-YEAR KeyChange GL199 GL281
COMPANY GL290 GL295
ACCOUNT GL320 GLSV.1
SUB-ACCOUNT GLRV.1
VAR-LEVELS
ACCT-UNIT
GAMSET5 FISCAL-YEAR KeyChange GLSV.1 GLRV.1
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
COMPANY
ACCT-UNIT
GAMSET6 FISCAL-YEAR KeyChange GLSV.1 GLRV.1
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
COMPANY
ACCT-UNIT
GAMSET7 COMPANY GL325 GL330
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
Adbalance B ADBALANCE Required
GAM-COMPANY -> ADE-COMPANY
GAM-FISCAL-YEAR -> ADE-FISCAL-YEAR
GAM-ACCT-UNIT -> ADE-ACCT-UNIT
GAM-ACCOUNT -> ADE-ACCOUNT
GAM-SUB-ACCOUNT -> ADE-SUB-ACCOUNT
"B" -> ADE-RECORD-TYPE
Adbalance C ADBALANCE Required
GAM-COMPANY -> ADE-COMPANY
GAM-FISCAL-YEAR -> ADE-FISCAL-YEAR
GAM-ACCT-UNIT -> ADE-ACCT-UNIT
GAM-ACCOUNT -> ADE-ACCOUNT
GAM-SUB-ACCOUNT -> ADE-SUB-ACCOUNT
"C" -> ADE-RECORD-TYPE
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-VAR-LEV -> CAM-PARENT-VAR-LEV
3 -> CAM-AMT-TYPE
GAM-COMPANY -> CAM-COMPANY
GAM-ACCOUNT -> CAM-ACCOUNT
GAM-SUB-ACCOUNT -> CAM-SUB-ACCOUNT
GAM-FISCAL-YEAR -> CAM-FISCAL-YEAR
GAM-ACCT-UNIT -> CAM-ACCT-UNIT
GAM-VAR-LEVELS -> CAM-VAR-LEVELS
CAM-CURRENCY-CODE
Cam Curr 2 CUAMOUNT
GAM-PARENT-VAR-LEV -> CAM-PARENT-VAR-LEV
4 -> CAM-AMT-TYPE
GAM-COMPANY -> CAM-COMPANY
GAM-ACCOUNT -> CAM-ACCOUNT
GAM-SUB-ACCOUNT -> CAM-SUB-ACCOUNT
GAM-FISCAL-YEAR -> CAM-FISCAL-YEAR
GAM-ACCT-UNIT -> CAM-ACCT-UNIT
GAM-VAR-LEVELS -> CAM-VAR-LEVELS
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-VAR-LEV -> GCN-VAR-LEVELS
"A" -> GCN-TRANS-TYPE
GAM-COMPANY -> GCN-COMPANY
GAM-ACCOUNT -> GCN-ACCOUNT
GAM-SUB-ACCOUNT -> GCN-SUB-ACCOUNT
GAM-FISCAL-YEAR -> GCN-FISCAL-YEAR
GCN-BUDGET-NBR
GCN-LEVEL-DEPTH
GCN-CURRENCY-CODE
Glcommit GLCOMMIT
GAM-COMPANY -> GOT-COMPANY
GAM-ACCT-UNIT -> GOT-ACCT-UNIT
GAM-ACCOUNT -> GOT-ACCOUNT
GAM-SUB-ACCOUNT -> GOT-SUB-ACCOUNT
GAM-FISCAL-YEAR -> GOT-FISCAL-YEAR
GOT-SYSTEM
Glcommitx GLCOMMITX
GAM-COMPANY -> GOX-COMPANY
GAM-ACCT-UNIT -> GOX-ACCT-UNIT
GAM-ACCOUNT -> GOX-ACCOUNT
GAM-SUB-ACCOUNT -> GOX-SUB-ACCOUNT
GAM-FISCAL-YEAR -> GOX-FISCAL-YEAR
GOX-PERIOD
GOX-SYSTEM
GOX-CURRENCY-CODE
GOX-GLT-OBJ-ID
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
|