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 AM180 AP125
AP126 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 AP520 API1.1
API2.1 BR41.4 BR44.1 CB10.1 CB15.1 CB15.2
CB150 CB191 CB20.1 CB30.1 CB45.1 CB46.1
CB500 CB543 CB544 CB55.1 CB554 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 GL141 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 GL198 GLOP.1 IFAC.1
IFGT.1 MA41.1 MA41.2 MA41.4 MA41.7 MA43.2
MA61.1 MAI1.1 PO150 PO25.1 PO25.6 PO25.7
PO536 POIM.1 RQ10.1 RQ10.3 RQ11.1 RQ13.2
RQ35.1 RQ500 RQIB.1 RQIF.1 RQIJ.1 GL135
GL196 GLSV.1 RW80.1 GLRV.1 FB11.1 FB111
FB160 FB211 GL122 GL296 GL00.7 GL20.2
GL295
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
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 GL167 GL199
Balance GL281 GL291
GL325 GL330
GL500 GLSV.1
GAM-CR-BEG-BAL Signed 18.2 FB20.6 GL110
Credit Beginning GL167 GL199
Balance GL281 GL291
GL325 GL330
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 transaction GL167 GL190
activity has occurred in a period. 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: Maint Date The 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 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
Element: Cpamt The total current period 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
Element: Cypamt1 Dr The current year period 1 debit amount.
GAM-CYPAMT1-CR Derived
Element: Cypamt1 Cr The current year period 1 credit
amount.
GAM-CYPAMT1 Derived
Element: Cypamt1 The current year period 1 amount.
GAM-CYPYTD1 Derived
Element: Cypamt1 Current year period year to date
period 1.
GAM-CYPAMT2-DR Derived
Element: Cypamt2 Dr The current year period 2 debit amount.
GAM-CYPAMT2-CR Derived
Element: Cypamt2 Cr The current year period 2 credit
amount.
GAM-CYPAMT2 Derived
Element: Cypamt2 The current year period 2 amount.
GAM-CYPYTD2 Derived
Element: Cypamt2 Current year period year to date
period 2.
GAM-CYPAMT3-DR Derived
Element: Cypamt3 Dr The current year period 3 debit amount.
GAM-CYPAMT3-CR Derived
Element: Cypamt3 Cr The current year period 3 credit
amount.
GAM-CYPAMT3 Derived
Element: Cypamt3 The current year period 3 amount.
GAM-CYPYTD3 Derived
Element: Cypamt3 Current year period year to date
period 3.
GAM-CYPAMT4-DR Derived
Element: Cypamt4 Dr The current year period 4 debit amount.
GAM-CYPAMT4-CR Derived
Element: Cypamt4 Cr The current year period 4 credit
amount.
GAM-CYPAMT4 Derived
Element: Cypamt4 The current year period 4 amount.
GAM-CYPYTD4 Derived
Element: Cypamt4 Current year period year to date
period 4.
GAM-CYPAMT5-DR Derived
Element: Cypamt5 Dr The current year period 5 debit amount.
GAM-CYPAMT5-CR Derived
Element: Cypamt5 Cr The current year period 5 credit
amount.
GAM-CYPAMT5 Derived
Element: Cypamt5 The current year period 5 amount.
GAM-CYPYTD5 Derived
Element: Cypamt5 Current year period year to date
period 5.
GAM-CYPAMT6-DR Derived
Element: Cypamt6 Dr The current year period 6 debit amount.
GAM-CYPAMT6-CR Derived
Element: Cypamt6 Cr The current year period 6 credit
amount.
GAM-CYPAMT6 Derived
Element: Cypamt6 The current year period 6 amount.
GAM-CYPYTD6 Derived
Element: Cypamt6 Current year period year to date
period 6.
GAM-CYPAMT7-DR Derived
Element: Cypamt7 Dr The current year period 7 debit amount.
GAM-CYPAMT7-CR Derived
Element: Cypamt7 Cr The current year period 7 credit
amount.
GAM-CYPAMT7 Derived
Element: Cypamt7 The current year period 7 amount.
GAM-CYPYTD7 Derived
Element: Cypamt7 Current year period year to date
period 7.
GAM-CYPAMT8-DR Derived
Element: Cypamt8 Dr The current year period 8 debit amount.
GAM-CYPAMT8-CR Derived
Element: Cypamt8 Cr The current year period 8 credit
amount.
GAM-CYPAMT8 Derived
Element: Cypamt8 The current year period 8 amount.
GAM-CYPYTD8 Derived
Element: Cypamt8 Current year period year to date
period 8.
GAM-CYPAMT9-DR Derived
Element: Cypamt9 Dr The current year period 9 debit amount.
GAM-CYPAMT9-CR Derived
Element: Cypamt9 Cr The current year period 9 credit
amount.
GAM-CYPAMT9 Derived
Element: Cypamt9 The current year period 9 amount.
GAM-CYPYTD9 Derived
Element: Cypamt9 Current year period year to date
period 9.
GAM-CYPAMT10-DR Derived
Element: Cypamt10 Dr The current year period 10 debit
amount.
GAM-CYPAMT10-CR Derived
Element: Cypamt10 Cr The current year period 10 credit
amount.
GAM-CYPAMT10 Derived
Element: Cypamt10 The current year period 10 amount.
GAM-CYPYTD10 Derived
Element: Cypamt10 Current year period year to date
period 10.
GAM-CYPAMT11-DR Derived
Element: Cypamt11 Dr The current year period 11 debit
amount.
GAM-CYPAMT11-CR Derived
Element: Cypamt11 Cr The current year period 11 credit
amount.
GAM-CYPAMT11 Derived
Element: Cypamt11 The current year period 11 amount.
GAM-CYPYTD11 Derived
Element: Cypamt11 Current year period year to date
period 11.
GAM-CYPAMT12-DR Derived
Element: Cypamt12 Dr The current year period 12 debit
amount.
GAM-CYPAMT12-CR Derived
Element: Cypamt12 Cr The current year period 12 credit
amount.
GAM-CYPAMT12 Derived
Element: Cypamt12 The current year period 12 amount.
GAM-CYPYTD12 Derived
Element: Cypamt12 Current year period year to date
period 12.
GAM-CYPAMT13-DR Derived
Element: Cypamt13 Dr The current year period 13 debit
amount.
GAM-CYPAMT13-CR Derived
Element: Cypamt13 Cr The current year period 13 credit
amount.
GAM-CYPAMT13 Derived
Element: Cypamt13 The current year period 13 amount.
GAM-CYPYTD13 Derived
Element: Cypamt13 Current year period year to date
period 13.
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 AM180 AP125
ACCOUNT AP126 AP170
SUB-ACCOUNT 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
AP520 API1.1
API2.1 BR41.4
BR44.1 CB10.1
CB15.1 CB15.2
...
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
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 Fis Year 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
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
|