 |
Lawson Insight Technical Documentation |
|
GLMASTER FILE
General Ledger Account Master
This file contains the chart of accounts. All Lawson subsystems verify the
existence of accounts against this file. The Chart of Accounts, Level
Reorganization, Mass Account Addition, and Mass Account Change Delete are the
primary programs that create and maintain information in the file.
REFERENCED BY
AC121 AC123 AC130 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC30.2 AC30.3 AC32.1 AC490
ACVW.1 AM180 CA10.5 CA10.1 CA10.7 CA110
FB100 FB195 FB20.1 FB20.6 FB20.7 FB20.4
FB20.3 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4
FB95.5 FB95.6 GL191 GL95.1 GL95.2 GL95.3
GL95.4 GL95.5 GL95.6 GL95.7 GL95.8 GL95.9
GL96.1 GL96.2 GL96.3 GL96.4 GL96.5 GL97.1
GL97.2 GL97.3 GL97.4 GL97.5 GL97.6 GL97.7
GL97.8 GL97.9 GL98.1 GL98.2 GL98.3 GL98.4
GL98.5 GL99.1 GL99.2 GL99.3 GL99.4 GL99.5
GL99.6 RW100 RW230 RW270 RW30.1 RW70.1
GL222 GLAV.1 GLCV.1 GLRV.1 GLVW.1 IF720
SLVW.1 CA195 GL130 GL141 GL170 GL288
GL35.1 GL70.2 GL70.5 GL75.1 GL90.1 GL90.2
GL90.4 HCGL.1 HGLM.1 IC02.1 GL10.1 GL14.8
GL221 GL38.1 MX135 SLSE.1 GL50.4 FB120
GL281 GL291 GL100 GL00.3 GL00.7 GL00.2
GL02.1 GL02.2
UPDATED BY
AC191 GL110 GL120 GL122 GL135 GL146
GL167 GL190 GL195 GL196 GL199 GL30.1
GL330 GL45.1 GL500 IC222 CU03.1 GL03.6
GL121 GL124 GL20.2 GL20.4 GL25.1 IFAC.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLM-COMPANY Numeric 4 AC191 GL110
Company The company number. GL121 GL124
GL135 GL167
GL190 GL195
GL196 GL199
GL20.2 GL20.4
GL330 GL45.1
GL500 IC222
IFAC.1 RW100
GLM-VAR-LEVELS Alpha 30 AC191 GL120
Variable Levels Required. The variable level number is GL121 GL124
tied directly to the accounting unit. It GL135 GL167
is used to indicate an accounting unit's GL190 GL195
position within the company hierarchy, GL196 GL199
establishing its consolidation GL20.2 GL20.4
relationship with other units. Must be GL330 GL45.1
defined in the GLNAMES file as a posting GL500 IC222
level. IFAC.1
GLM-ACCT-UNIT Alpha 15 AC191 GL121
Accounting Unit The accounting unit is a shorthand GL124 GL135
notation representing the variable level GL167 GL190
number. GL195 GL196
GL199 GL20.2
GL20.4 GL330
GL45.1 GL500
IC222 IFAC.1
GLM-OLD-COMPANY-D Derived
Old Company Contains the old company derived.
GLM-ACCOUNT Numeric 6 AC191 GL121
Account This field along with the accounting GL124 GL135
unit and subaccount make up the location GL167 GL190
(account) where amounts and other GL195 GL196
account information is stored. GL199 GL20.2
GL20.4 GL330
GL45.1 GL500
IC02.1 IC222
IFAC.1 RW100
GLM-SUB-ACCOUNT Numeric 4 AC191 GL121
Subaccount This field along with the accounting GL124 GL135
unit and account make up the location GL167 GL190
(account) where amounts and other GL195 GL196
account information are stored. GL199 GL20.2
GL20.4 GL330
GL45.1 GL500
IC02.1 IC222
IFAC.1
GLM-OLD-ACCT-NBR-D Derived
Old Account Number Contains the derived old account
number.
GLM-ACTIVE-STATUS Alpha 1 GL121 GL122
Active Status Required field if a detail-type GL124 GL167
account, otherwise this field should be GL20.2
blank. Indicates if a detail account is
either active or inactive. Inactive
accounts cannot be used for posting.
" " = Default
I = Inactive
GLM-STATUS-DERIVED Derived
Status Contains the derived status.
GLM-ACCT-ND Numeric 1 AC191 GL110
Account Number of Account amount decimal positions. GL121 GL124
Decimals GL135 GL167
GL190 GL195
GL196 GL199
GL20.2 GL20.4
GL330 GL45.1
GL500 IC222
IFAC.1
GLM-UNITS-CODE Alpha 1 GL121 GL122
Units Code Required if a detail-type account. This GL124 GL146
field indicates if units are allowed, GL167 GL190
not allowed, or only allowed. GL20.2 GL45.1
" " = Default
Y = Yes
N = No
O = Only Units
I = Inactive
GLM-UNITS-DERIVED Derived
Units Contains the derived units.
GLM-AVG-DAILY-BAL Alpha 1 GL121 GL122
Average Daily Yes value indicates the account is used
Balance for calculating average daily balance.
GLM-ACTIVITY-REQ Alpha 1 GL121 GL122
Activity Required Indicates if an Activity code is GL124 GL20.2
required.
Y = Yes
N = No
" " = Default
GLM-GLINTCO-STAT Numeric 3 CU03.1 GL110
Intercompany Status Not required. This field is used to GL121 GL20.4
count the number of intercompany or GL25.1 GL30.1
interzone relationships using this
account number. Accounts cannot be
deleted if this field is greater than
zero.
GLM-POSTING-LEVEL Alpha 1 GL121 GL122
Posting Level Required if a detail-type account. This GL124 GL20.2
field is used to determine whether
interface transactions should be
combined when creating GLTRANS records.
" " = Default
D = Detail
S = Summary
GLM-OPTION-FLD-1 Alpha 2 (Lower Case) GL121 GL122
Free-form field used to store any GL124 GL167
information relevant to an account. This GL20.2 RW100
field is used for reporting purposes.
GLM-OPTION-FLD-2 Alpha 7 (Lower Case) GL121 GL122
Free-form field used to store GL124 GL167
information relevant to an account. This GL20.2 RW100
field is used for reporting purposes.
GLM-OPTION-FLD-3 Alpha 12 (Lower Case) GL121 GL122
Free-form field used to store any GL124 GL167
information relevant to an account. This GL20.2 RW100
field is used for reporting purposes.
GLM-TRANSL-CODE Alpha 2 FB195 GL121
Contains the translation code. GL122 GL124
GL135 GL167
GL191 GL195
GL196 GL20.2
GLM-CURRENCY-CODE Alpha 5 AC191 GL110
Currency Code The company base currency code. GL121 GL122
GL124 GL135
GL167 GL190
GL195 GL196
GL199 GL20.2
GL20.4 GL330
GL45.1 GL500
IC222 IFAC.1
GLM-CURR-CONTROL Alpha 1 GL121 GL122
Currency Control Flag used to allow posting GL124 GL20.2
to the account in currencies other than
the account currency.
" " = Default
0 = No
1 = Yes
GLM-REVALUE Alpha 1 GL121 GL122
Revalue Determines whether or not this account GL124 GL20.2
will participate in the revaluation
process.
" " = Default
0 = No
1 = Yes
GLM-DATE-ENTERED Numeric 8 (yyyymmdd) AC191 GL121
Date Entered Date used to document account changes. GL124 GL135
GL167 GL190
GL195 GL196
GL199 GL20.2
GL20.4 GL330
GL45.1 GL500
IC222 IFAC.1
GLM-CHART-NAME Alpha 12 AC191 GL121
Chart Name This is the name assigned to the chart GL124 GL135
of accounts when you defined your GL167 GL190
company structure in the Lawson General GL195 GL196
Ledger system. GL199 GL20.2
GL20.4 GL330
GL45.1 GL500
IC02.1 IC222
IFAC.1
GLM-BASE-CURRENCY Alpha 5 AC191 GL110
Base Currency The company base currency. GL121 GL124
GL135 GL167
GL190 GL195
GL196 GL199
GL20.2 GL20.4
GL330 GL45.1
GL500 IC222
IFAC.1
GLM-RESTRICT-SYS Alpha 1 GL03.6 GL121
Restrict System Indicates if system codes are validated GL122 GL124
each time the account is used by a GL20.2
system.
Y = Yes
N = No
" " = Default
GLM-ACCT-CATEGORY Alpha 5 GL121 GL122
Account Category Account categories are groupings of GL124 GL20.2
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
GLM-DER-X-SYS Derived
Der X Sys Indicates if system restrictions exist
for an account.
GLM-SUMM-ACCT-ID Derived
Summary Account ID The summary account ID.
GLM-ACCT-DESC Derived
Account Description This is the account description.
GLM-BLANK Derived
Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
GLM-CUCODE-DESC Derived
Cucode Desc This is the currency code description.
GLM-SL-ACCT-FLAG Alpha 1 GL122 GL20.2
Strategic Ledger This flag determines whether user
analysis values can be assigned to a
specific account. You can select Yes,
No, or use the Summary Account
selection.
Y = Yes
N = No
" " = Default
GLM-RELATION Alpha 15 GL122 GL20.2
User Analysis The user analysis value relation
Relation assigned to the detail or summary
account.
The relation must exist in SL02.1 (User
Analysis Value Relation).
GLM-LEDGER-GROUP Alpha 15 GL20.2
Ledger Group
GLMASTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLMSET1 COMPANY This path is used to retrieve chart of AC121 AC123
ACCOUNT accounts records by variable level then AC130 AC20.1
SUB-ACCOUNT accounting unit. AC20.2 AC20.3
VAR-LEVELS AC20.4 AC20.5
ACCT-UNIT AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
CA10.5 CA110
FB100 FB195
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL110 GL191
...
GLMSET2 COMPANY This path is used to retrieve chart of AC191 CA10.1
ACCT-UNIT accounts records by accounting unit CA10.7 CA110
ACCOUNT without regard to variable level. CA195 FB195
SUB-ACCOUNT FB20.4 GL110
GL120 GL122
GL130 GL135
GL141 GL146
GL167 GL170
GL190 GL191
GL195 GL196
GL199 GL288
GL30.1 GL30.2
GL330 GL35.1
GL45.1 GL500
GL70.2 GL70.5
...
GLMSET3 COMPANY This path is used to retrieve chart of FB20.3 GL50.4
ACCOUNT accounts records by account without RW100 GL121
SUB-ACCOUNT regard to accounting unit. GL20.4 GL222
ACCT-UNIT
GLMSET5 COMPANY This path is used to retrieve only CA110 FB120
VAR-LEVELS Detail Type chart of accounts records by FB95.1 FB95.2
ACCOUNT variable level without regard for FB95.3 FB95.4
SUB-ACCOUNT accounting units. FB95.5 FB95.6
ACCT-UNIT GL281 GL291
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
...
GLMSET6 VAR-LEVELS This path is used to retrieve only GLRV.1
ACCOUNT Detail Type chart of accounts records by
SUB-ACCOUNT variable levels and account.
COMPANY
ACCT-UNIT
GLMSET7 ACCOUNT This path is used to retrieve only FB95.1 FB95.2
SUB-ACCOUNT Detail Type chart of accounts by account FB95.3 FB95.4
VAR-LEVELS and subaccount. FB95.5 FB95.6
COMPANY GL100 GL95.1
ACCT-UNIT GL95.2 GL95.3
GL95.4 GL95.5
GL95.6 GL95.7
GL95.8 GL95.9
GL96.1 GL96.2
GL96.3 GL96.4
GL96.5 GL97.1
GL97.2 GL97.3
GL97.4 GL97.5
GL97.6 GL97.7
GL97.8 GL97.9
...
GLMSET8 CHART-NAME GL100 GL00.2
ACCOUNT
SUB-ACCOUNT
COMPANY
ACCT-UNIT
GLMSET9 LEDGER-GROUP KeyChange, Subset
COMPANY Where LEDGER-GROUP != Spaces
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
GLMASTER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accountunit GLNAMES Required
GLM-COMPANY -> GLN-COMPANY (GLNSET1)
GLM-ACCT-UNIT -> GLN-ACCT-UNIT
Acct Unit GLNAMES Required
GLM-COMPANY -> GLN-COMPANY
GLM-ACCT-UNIT -> GLN-ACCT-UNIT
Budget 1 FBDETAIL Not Required
GLM-COMPANY -> FBD-COMPANY
GLS-FISCAL-YEAR -> FBD-FISCAL-YEAR
1 -> FBD-BUDGET-NBR
GLM-ACCT-UNIT -> FBD-ACCT-UNIT
GLM-ACCOUNT -> FBD-ACCOUNT
GLM-SUB-ACCOUNT -> FBD-SUB-ACCOUNT
Chart Detail GLCHARTDTL Required
GLM-CHART-NAME -> GDT-CHART-NAME
GLM-ACCOUNT -> GDT-ACCOUNT
GLM-SUB-ACCOUNT -> GDT-SUB-ACCOUNT
Company GLSYSTEM Required
GLM-COMPANY -> GLS-COMPANY
Consol GLCONSOL Not Required
GLS-FISCAL-YEAR -> GCN-FISCAL-YEAR
Zeroes -> GCN-LEVEL-DEPTH
Zeroes -> GCN-BUDGET-NBR
"A" -> GCN-TRANS-TYPE
GLM-COMPANY -> GCN-COMPANY
Spaces -> GCN-VAR-LEVELS
GLM-ACCOUNT -> GCN-ACCOUNT
GLM-SUB-ACCOUNT -> GCN-SUB-ACCOUNT
Spaces -> GCN-CURRENCY-CODE
Cucodes CUCODES Required
GLM-CURRENCY-CODE -> CUC-CURRENCY-CODE
Summary Acct GLCHARTSUM Required
GLM-CHART-NAME -> GCS-CHART-NAME
GDT-SUMRY-ACCT-ID -> GCS-SUMRY-ACCT-ID
Trcodes TRCODES Required
When GLM-TRANSL-CODE = Spaces
GLM-TRANSL-CODE -> TRC-TRANSL-CODE
Var Levels GLNAMES Required
GLM-COMPANY -> GLN-COMPANY
GLM-VAR-LEVELS -> GLN-VAR-LEVELS
GLM-ACCT-UNIT -> GLN-ACCT-UNIT
Variablelevel GLNAMES Required
GLM-COMPANY -> GLN-COMPANY
GLM-VAR-LEVELS -> GLN-VAR-LEVELS
GLM-ACCT-UNIT -> GLN-ACCT-UNIT
GLMASTER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amounts GLAMOUNTS Delete Restricted
GLM-COMPANY -> GAM-COMPANY
GLM-ACCT-UNIT -> GAM-ACCT-UNIT
GLM-ACCOUNT -> GAM-ACCOUNT
GLM-SUB-ACCOUNT -> GAM-SUB-ACCOUNT
GAM-FISCAL-YEAR
Budget All FBDETAIL Delete Restricted
GLM-COMPANY -> FBD-COMPANY
GLM-ACCT-UNIT -> FBD-ACCT-UNIT
GLM-ACCOUNT -> FBD-ACCOUNT
GLM-SUB-ACCOUNT -> FBD-SUB-ACCOUNT
FBD-BUDGET-NBR
FBD-FISCAL-YEAR
Budgets FBDETAIL Delete Restricted
GLM-COMPANY -> FBD-COMPANY
GLM-ACCT-UNIT -> FBD-ACCT-UNIT
GLM-ACCOUNT -> FBD-ACCOUNT
GLM-SUB-ACCOUNT -> FBD-SUB-ACCOUNT
FBD-BUDGET-NBR
FBD-FISCAL-YEAR
Cuamount1 CUAMOUNT Delete Cascades
GLM-COMPANY -> CAM-COMPANY
GLM-ACCT-UNIT -> CAM-ACCT-UNIT
GLM-ACCOUNT -> CAM-ACCOUNT
GLM-SUB-ACCOUNT -> CAM-SUB-ACCOUNT
1 -> CAM-AMT-TYPE
GLM-CURRENCY-CODE -> CAM-CURRENCY-CODE
CAM-FISCAL-YEAR
CAM-VAR-LEVELS
Cuamount2 CUAMOUNT Delete Cascades
GLM-COMPANY -> CAM-COMPANY
GLM-ACCT-UNIT -> CAM-ACCT-UNIT
GLM-ACCOUNT -> CAM-ACCOUNT
GLM-SUB-ACCOUNT -> CAM-SUB-ACCOUNT
2 -> CAM-AMT-TYPE
CAM-CURRENCY-CODE
CAM-FISCAL-YEAR
CAM-VAR-LEVELS
Cuamount3 CUAMOUNT Delete Cascades
GLM-COMPANY -> CAM-COMPANY
GLM-ACCT-UNIT -> CAM-ACCT-UNIT
GLM-ACCOUNT -> CAM-ACCOUNT
GLM-SUB-ACCOUNT -> CAM-SUB-ACCOUNT
3 -> CAM-AMT-TYPE
GLS-CURR-CODE-1 -> CAM-CURRENCY-CODE
CAM-FISCAL-YEAR
CAM-VAR-LEVELS
Cuamount4 CUAMOUNT Delete Cascades
GLM-COMPANY -> CAM-COMPANY
GLM-ACCT-UNIT -> CAM-ACCT-UNIT
GLM-ACCOUNT -> CAM-ACCOUNT
GLM-SUB-ACCOUNT -> CAM-SUB-ACCOUNT
4 -> CAM-AMT-TYPE
GLS-CURR-CODE-2 -> CAM-CURRENCY-CODE
CAM-FISCAL-YEAR
CAM-VAR-LEVELS
Cuamountx 3 CUAMOUNTX
GLM-COMPANY -> CAX-COMPANY
3 -> CAX-AMT-TYPE
GLM-ACCT-UNIT -> CAX-ACCT-UNIT
GLM-ACCOUNT -> CAX-ACCOUNT
GLM-SUB-ACCOUNT -> CAX-SUB-ACCOUNT
CAX-DATE
Cuamountx 4 CUAMOUNTX
GLM-COMPANY -> CAX-COMPANY
4 -> CAX-AMT-TYPE
GLM-ACCT-UNIT -> CAX-ACCT-UNIT
GLM-ACCOUNT -> CAX-ACCOUNT
GLM-SUB-ACCOUNT -> CAX-SUB-ACCOUNT
CAX-DATE
Dailytrans GLAMOUNTSX
GLM-COMPANY -> GAX-COMPANY
GLM-ACCT-UNIT -> GAX-ACCT-UNIT
GLM-ACCOUNT -> GAX-ACCOUNT
GLM-SUB-ACCOUNT -> GAX-SUB-ACCOUNT
GAX-DATE
Glacctvld Gcs GLACCTVLD
"S" -> VLD-RECORD-TYPE
GLS-CHART-NAME -> VLD-CHART-NAME
GDT-SUMRY-ACCT-ID -> VLD-SUMRY-ACCT-ID
Zeroes -> VLD-ACCOUNT
Zeroes -> VLD-SUB-ACCOUNT
Zeroes -> VLD-COMPANY
Spaces -> VLD-ACCT-UNIT
VLD-SYSTEM
Glacctvld Gdt GLACCTVLD
GLS-CHART-NAME -> VLD-CHART-NAME
GLM-ACCOUNT -> VLD-ACCOUNT
GLM-SUB-ACCOUNT -> VLD-SUB-ACCOUNT
VLD-SYSTEM
Glacctvld Glm GLACCTVLD
GLM-COMPANY -> VLD-COMPANY
GLM-ACCT-UNIT -> VLD-ACCT-UNIT
GLM-ACCOUNT -> VLD-ACCOUNT
GLM-SUB-ACCOUNT -> VLD-SUB-ACCOUNT
VLD-SYSTEM
Glacctvld Sys GLACCTVLD
"M" -> VLD-RECORD-TYPE
GLM-CHART-NAME -> VLD-CHART-NAME
GDT-SUMRY-ACCT-ID -> VLD-SUMRY-ACCT-ID
GLM-ACCOUNT -> VLD-ACCOUNT
GLM-SUB-ACCOUNT -> VLD-SUB-ACCOUNT
GLM-COMPANY -> VLD-COMPANY
GLM-ACCT-UNIT -> VLD-ACCT-UNIT
VLD-SYSTEM
Othr Acct Unit GLMASTER
GLM-COMPANY -> GLM-COMPANY
GLM-ACCOUNT -> GLM-ACCOUNT
GLM-SUB-ACCOUNT -> GLM-SUB-ACCOUNT
GLM-VAR-LEVELS
GLM-ACCT-UNIT
Trans All Prds GLTRANS
GLM-COMPANY -> GLT-TO-COMPANY
GLM-ACCOUNT -> GLT-ACCOUNT
GLM-SUB-ACCOUNT -> GLT-SUB-ACCOUNT
GLM-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
Transactions GLTRANS
GLM-COMPANY -> GLT-TO-COMPANY
GLS-FISCAL-YEAR -> GLT-FISCAL-YEAR
GLS-ACCT-PERIOD -> GLT-ACCT-PERIOD
GLM-ACCT-UNIT -> GLT-ACCT-UNIT
GLM-ACCOUNT -> GLT-ACCOUNT
GLM-SUB-ACCOUNT -> GLT-SUB-ACCOUNT
GLT-POSTING-DATE
GLT-SYSTEM
GLT-CONTROL-GROUP
GLT-JE-TYPE
GLT-LINE-NBR
GLT-COMPANY
GLT-JE-SEQUENCE
Units GLUNITS Delete Restricted
GLM-COMPANY -> GLU-COMPANY
GLM-ACCOUNT -> GLU-ACCOUNT
GLM-SUB-ACCOUNT -> GLU-SUB-ACCOUNT
GLM-VAR-LEVELS -> GLU-VAR-LEVELS
GLM-ACCT-UNIT -> GLU-ACCT-UNIT
GLU-FISCAL-YEAR
|