GLMASTER – General Ledger Account Master

System
General Ledger Setup (IF)
Prefix
GLM
Primary key
COMPANY, ACCOUNT, SUB-ACCOUNT, VAR-LEVELS, ACCT-UNIT
Fields
41
Updated by
144 programs
Referenced by
396 programs

GLMASTER is the General Ledger Account Master table in Lawson General Ledger Setup (prefix GLM). It is indexed by COMPANY, ACCOUNT, SUB-ACCOUNT, VAR-LEVELS, ACCT-UNIT (GLMSET1); alternate indexes: GLMSET2, GLMSET3, GLMSET5, GLMSET6, GLMSET7, GLMSET8 and GLMSET9. It is related 1:1 to GLNAMES, FBDETAIL, GLCHARTDTL, GLSYSTEM, GLCONSOL, CUCODES, GLMSTBOD, POCOMPANY and 3 more and 1:M to GLAMOUNTS, FBDETAIL, CUAMOUNT, CUAMOUNTX, GLAMOUNTSX, GLACCTVLD, GLCOMMIT, GLCOMMITX and 5 more. It is updated by AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 136 more and referenced by AC121, AC123, AC130, AC131, AC20.1, AC20.2, AC20.3, AC20.4 and 388 more. The table has 41 fields, 8 indexes and 36 documented relations.

About GLMASTER

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.

Fields (41)

Column = COBOL field name without the GLM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
GLM-COMPANY PK
COMPANY
Numeric 4The company number.AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLM-VAR-LEVELS PK
VAR_LEVELS
Alpha 30Required. The variable level number is tied directly to the accounting unit. It is used to indicate an accounting unit's position within the company hierarchy, establishing its consolidation relationship with other units. Must be defined in the GLNAMES file as a posting level.AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLM-ACCT-UNIT PK
ACCT_UNIT
Alpha 15The accounting unit is a shorthand notation representing the variable level number.AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLM-OLD-COMPANY-D
OLD_COMPANY_D
DerivedContains the old company derived.
GLM-ACCOUNT PK
ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLM-SUB-ACCOUNT PK
SUB_ACCOUNT
Numeric 4This field along with the accounting unit and account make up the location (account) where amounts and other account information are stored.AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLM-OLD-ACCT-NBR-D
OLD_ACCT_NBR_D
DerivedContains the derived old account number.
GLM-ACTIVE-STATUS
ACTIVE_STATUS
Alpha 1Required field if a detail-type account, otherwise this field should be blank. Indicates if a detail account is either active or inactive. Inactive accounts cannot be used for posting. " " = Default
  • I Inactive
GL121, GL122, GL124, GL167, GL20.2, ML167
GLM-STATUS-DERIVED
STATUS_DERIVED
DerivedContains the derived status.
GLM-ACCT-ND
ACCT_ND
Numeric 1Account amount decimal positions.AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLM-UNITS-CODE
UNITS_CODE
Alpha 1Required if a detail-type account. This field indicates if units are allowed, not allowed, or only allowed. " " = Default
  • Y Yes - Not Required
  • N No
  • O Only Units
  • R Yes - Required
GL121, GL122, GL124, GL146, GL167, GL190, GL197, GL20.2 +17 more
GLM-UNITS-DERIVED
UNITS_DERIVED
DerivedContains the derived units.
GLM-AVG-DAILY-BAL
AVG_DAILY_BAL
Alpha 1Yes value indicates the account is used for calculating average daily balance. " " = No
  • N No
  • Y Yes
  • I Inactive
GL121, GL122, GL20.2
GLM-ACTIVITY-REQ
ACTIVITY_REQ
Alpha 1Indicates if an Activity code is required. " " = Default
  • Y Yes
  • N No
GL121, GL122, GL124, GL20.2
GLM-GLINTCO-STAT
GLINTCO_STAT
Numeric 3Not required. This field is used to count the number of intercompany or interzone relationships using this account number. Accounts cannot be deleted if this field is greater than zero.CU03.1, FB35.1, GL110, GL121, GL20.4, GL25.1, GL30.1
GLM-POSTING-LEVEL
POSTING_LEVEL
Alpha 1Required if a detail-type account. This field is used to determine whether interface transactions should be combined when creating GLTRANS records. " " = Default
  • D Detail
  • S Summary
GL121, GL122, GL124, GL20.2
GLM-OPTION-FLD-1
OPTION_FLD_1
Alpha 2 (Lower Case)Free-form field used to store any information relevant to an account. This field is used for reporting purposes.GL121, GL122, GL124, GL167, GL20.2, ML167, RW100
GLM-OPTION-FLD-2
OPTION_FLD_2
Alpha 7 (Lower Case)Free-form field used to store information relevant to an account. This field is used for reporting purposes.GL121, GL122, GL124, GL167, GL20.2, ML167, RW100
GLM-OPTION-FLD-3
OPTION_FLD_3
Alpha 12 (Lower Case)Free-form field used to store any information relevant to an account. This field is used for reporting purposes.GL121, GL122, GL124, GL167, GL20.2, ML167, RW100
GLM-TRANSL-CODE
TRANSL_CODE
Alpha 2Contains the translation code.FB145, FB190, FB195, FB40.1, FB40.2, FB40.3, FB45.1, GL121 +14 more
GLM-CURRENCY-CODE
CURRENCY_CODE
Alpha 5The company base currency code.AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLM-CURR-CONTROL
CURR_CONTROL
Alpha 1Flag used to allow posting to the account in currencies other than the account currency. " " = Default
  • 0 No
  • 1 Yes
GL121, GL122, GL124, GL20.2
GLM-REVALUE
REVALUE
Alpha 1Determines whether or not this account will participate in the revaluation process. " " = Default
  • 0 No
  • 1 Yes
GL121, GL122, GL124, GL20.2
GLM-DATE-ENTERED
DATE_ENTERED
Numeric 8 (yyyymmdd)Date used to document account changes.AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLM-CHART-NAME
CHART_NAME
Alpha 12This is the name assigned to the chart of accounts when you defined your company structure in the Lawson General Ledger system.AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLM-BASE-CURRENCY
BASE_CURRENCY
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLM-RESTRICT-SYS
RESTRICT_SYS
Alpha 1Indicates if system codes are validated each time the account is used by a system. " " = Default
  • Y Yes
  • N No
GL03.6, GL121, GL122, GL124, GL20.2
GLM-ACCT-CATEGORY
ACCT_CATEGORY
Alpha 5Account categories are groupings of 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. Valid account category types are: cost revenue accrual pass thruGL121, GL122, GL124, GL20.2
GLM-DER-X-SYS
DER_X_SYS
DerivedIndicates if system restrictions exist for an account.
GLM-SUMM-ACCT-ID
SUMM_ACCT_ID
DerivedThe summary account ID.
GLM-ACCT-DESC
ACCT_DESC
DerivedThis is the account description.
GLM-BLANK
BLANK
DerivedThis derived field is always blank. It is used in the Drill Around feature for column headings.
GLM-CUCODE-DESC
CUCODE_DESC
DerivedThis is the currency code description.
GLM-SL-ACCT-FLAG
SL_ACCT_FLAG
Alpha 1This flag determines whether user analysis values can be assigned to a specific account. You can select Yes, No, or use the Summary Account selection. " " = Default
  • Y Yes
  • N No
GL122, GL20.2
GLM-RELATION
RELATION
Alpha 15The user analysis value relation assigned to the detail or summary account. The relation must exist in SL02.1 (User Analysis Value Relation).GL122, GL20.2
GLM-LEDGER-GROUP
LEDGER_GROUP
Alpha 15GL122, GL20.2
GLM-GL-BUD-FL
GL_BUD_FL
Alpha 1This is the Yes/No flag for budget editing. " " = Default
  • N No Edit
  • Y Yes
GL122, GL20.2
GLM-CREATED-BY
CREATED_BY
Alpha 10AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLM-LAST-UPDT-DATE
LAST_UPDT_DATE
Numeric 8 (yyyymmdd)AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLM-LAST-UPDT-TIME
LAST_UPDT_TIME
Numeric 8AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLM-LAST-UPDATE-BY
LAST_UPDATE_BY
Alpha 10AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (8)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GLMSET1COMPANY, ACCOUNT, SUB-ACCOUNT, VAR-LEVELS, ACCT-UNITPrimaryAC121, AC123, AC130, AC191, AC20.1, AC20.2, AC20.3, AC20.4 +22 more (list truncated in source)
GLMSET2COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNTAC131, AC191, AD190, AD191, AD220, AM19.1, AM19.2, AP115 +22 more (list truncated in source)
GLMSET3COMPANY, ACCOUNT, SUB-ACCOUNT, ACCT-UNITFB20.3, GL120, GL50.4, RW100, GL121, GL20.4, GL222, ML50.4
GLMSET5COMPANY, VAR-LEVELS, ACCOUNT, SUB-ACCOUNT, ACCT-UNITCA110, FB11.1, FB111, FB120, FB160, FB211, FB296, FB60.1 +22 more (list truncated in source)
GLMSET6VAR-LEVELS, ACCOUNT, SUB-ACCOUNT, COMPANY, ACCT-UNITGLRV.1
GLMSET7ACCOUNT, SUB-ACCOUNT, VAR-LEVELS, COMPANY, ACCT-UNITFB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1, FB95.2 +22 more (list truncated in source)
GLMSET8CHART-NAME, ACCOUNT, SUB-ACCOUNT, COMPANY, ACCT-UNITKeyChangeAC191, AC40.4, AC41.4, AC42.1, AP125, AP126, AP131, AP170 +22 more (list truncated in source)
GLMSET9LEDGER-GROUP, COMPANY, ACCOUNT, SUB-ACCOUNT, VAR-LEVELS, ACCT-UNITKeyChange, SubsetWhere LEDGER-GROUP != SpacesML11.1

Relations

One to one (14) — lookups and parents

RelationTableRulesConditionField map
AccountunitGLNAMESRequiredGLM-COMPANY-COMPANY, GLM-ACCT-UNIT-ACCT-UNIT
Acct UnitGLNAMESRequiredGLM-COMPANYGLN-COMPANY, GLM-ACCT-UNITGLN-ACCT-UNIT
Budget 1FBDETAILNot RequiredGLM-COMPANYFBD-COMPANY, GLS-FISCAL-YEARFBD-FISCAL-YEAR, 1FBD-BUDGET-NBR, GLM-ACCT-UNITFBD-ACCT-UNIT, GLM-ACCOUNTFBD-ACCOUNT, GLM-SUB-ACCOUNTFBD-SUB-ACCOUNT
Chart DetailGLCHARTDTLRequiredGLM-CHART-NAMEGDT-CHART-NAME, GLM-ACCOUNTGDT-ACCOUNT, GLM-SUB-ACCOUNTGDT-SUB-ACCOUNT
CompanyGLSYSTEMRequiredGLM-COMPANYGLS-COMPANY
ConsolGLCONSOLNot RequiredGLS-FISCAL-YEARGCN-FISCAL-YEAR, ZeroesGCN-LEVEL-DEPTH, ZeroesGCN-BUDGET-NBR, "A"GCN-TRANS-TYPE, GLM-COMPANYGCN-COMPANY, SpacesGCN-VAR-LEVELS, GLM-ACCOUNTGCN-ACCOUNT, GLM-SUB-ACCOUNTGCN-SUB-ACCOUNT, SpacesGCN-CURRENCY-CODE
CucodesCUCODESRequiredGLM-CURRENCY-CODECUC-CURRENCY-CODE
GlmstbodGLMSTBODNot Required, Delete CascadesGLM-COMPANYYBW-COMPANY, GLM-ACCOUNTYBW-ACCOUNT, GLM-SUB-ACCOUNTYBW-SUB-ACCOUNT, GLM-VAR-LEVELSYBW-VAR-LEVELS, GLM-ACCT-UNITYBW-ACCT-UNIT
PocompanyPOCOMPANYNot RequiredGLM-COMPANYPCY-COMPANY
ProcuregrpPROCUREGRPNot RequiredPCY-PROCURE-GROUPPCG-PROCURE-GROUP
Summary AcctGLCHARTSUMRequiredGLM-CHART-NAMEGCS-CHART-NAME, GDT-SUMRY-ACCT-IDGCS-SUMRY-ACCT-ID
TrcodesTRCODESRequiredWhen GLM-TRANSL-CODE = SpacesGLM-TRANSL-CODETRC-TRANSL-CODE
Var LevelsGLNAMESRequiredGLM-COMPANYGLN-COMPANY, GLM-VAR-LEVELSGLN-VAR-LEVELS, GLM-ACCT-UNITGLN-ACCT-UNIT
VariablelevelGLNAMESRequiredGLM-COMPANYGLN-COMPANY, GLM-VAR-LEVELSGLN-VAR-LEVELS, GLM-ACCT-UNITGLN-ACCT-UNIT

One to many (22) — child tables

RelationTableRulesConditionField map
AmountsGLAMOUNTSDelete RestrictedGLM-COMPANYGAM-COMPANY, GLM-ACCT-UNITGAM-ACCT-UNIT, GLM-ACCOUNTGAM-ACCOUNT, GLM-SUB-ACCOUNTGAM-SUB-ACCOUNT, GAM-FISCAL-YEAR
Budget AllFBDETAILDelete RestrictedGLM-COMPANYFBD-COMPANY, GLM-ACCT-UNITFBD-ACCT-UNIT, GLM-ACCOUNTFBD-ACCOUNT, GLM-SUB-ACCOUNTFBD-SUB-ACCOUNT, FBD-BUDGET-NBR, FBD-FISCAL-YEAR
BudgetsFBDETAILDelete RestrictedGLM-COMPANYFBD-COMPANY, GLM-ACCT-UNITFBD-ACCT-UNIT, GLM-ACCOUNTFBD-ACCOUNT, GLM-SUB-ACCOUNTFBD-SUB-ACCOUNT, FBD-BUDGET-NBR, FBD-FISCAL-YEAR
Cuamount1CUAMOUNTDelete CascadesGLM-COMPANYCAM-COMPANY, GLM-ACCT-UNITCAM-ACCT-UNIT, GLM-ACCOUNTCAM-ACCOUNT, GLM-SUB-ACCOUNTCAM-SUB-ACCOUNT, 1CAM-AMT-TYPE, GLM-CURRENCY-CODECAM-CURRENCY-CODE, CAM-FISCAL-YEAR, CAM-VAR-LEVELS
Cuamount2CUAMOUNTDelete CascadesGLM-COMPANYCAM-COMPANY, GLM-ACCT-UNITCAM-ACCT-UNIT, GLM-ACCOUNTCAM-ACCOUNT, GLM-SUB-ACCOUNTCAM-SUB-ACCOUNT, 2CAM-AMT-TYPE, CAM-CURRENCY-CODE, CAM-FISCAL-YEAR, CAM-VAR-LEVELS
Cuamount3CUAMOUNTDelete CascadesGLM-COMPANYCAM-COMPANY, GLM-ACCT-UNITCAM-ACCT-UNIT, GLM-ACCOUNTCAM-ACCOUNT, GLM-SUB-ACCOUNTCAM-SUB-ACCOUNT, 3CAM-AMT-TYPE, GLS-CURR-CODE-1CAM-CURRENCY-CODE, CAM-FISCAL-YEAR, CAM-VAR-LEVELS
Cuamount4CUAMOUNTDelete CascadesGLM-COMPANYCAM-COMPANY, GLM-ACCT-UNITCAM-ACCT-UNIT, GLM-ACCOUNTCAM-ACCOUNT, GLM-SUB-ACCOUNTCAM-SUB-ACCOUNT, 4CAM-AMT-TYPE, GLS-CURR-CODE-2CAM-CURRENCY-CODE, CAM-FISCAL-YEAR, CAM-VAR-LEVELS
Cuamountx 3CUAMOUNTXGLM-COMPANYCAX-COMPANY, 3CAX-AMT-TYPE, GLM-ACCT-UNITCAX-ACCT-UNIT, GLM-ACCOUNTCAX-ACCOUNT, GLM-SUB-ACCOUNTCAX-SUB-ACCOUNT, CAX-DATE
Cuamountx 4CUAMOUNTXGLM-COMPANYCAX-COMPANY, 4CAX-AMT-TYPE, GLM-ACCT-UNITCAX-ACCT-UNIT, GLM-ACCOUNTCAX-ACCOUNT, GLM-SUB-ACCOUNTCAX-SUB-ACCOUNT, CAX-DATE
DailytransGLAMOUNTSXGLM-COMPANYGAX-COMPANY, GLM-ACCT-UNITGAX-ACCT-UNIT, GLM-ACCOUNTGAX-ACCOUNT, GLM-SUB-ACCOUNTGAX-SUB-ACCOUNT, GAX-DATE
Glacctvld GcsGLACCTVLD"S"VLD-RECORD-TYPE, GLS-CHART-NAMEVLD-CHART-NAME, GDT-SUMRY-ACCT-IDVLD-SUMRY-ACCT-ID, ZeroesVLD-ACCOUNT, ZeroesVLD-SUB-ACCOUNT, ZeroesVLD-COMPANY, SpacesVLD-ACCT-UNIT, VLD-SYSTEM
Glacctvld GdtGLACCTVLDGLS-CHART-NAMEVLD-CHART-NAME, GLM-ACCOUNTVLD-ACCOUNT, GLM-SUB-ACCOUNTVLD-SUB-ACCOUNT, VLD-SYSTEM
Glacctvld GlmGLACCTVLDGLM-COMPANYVLD-COMPANY, GLM-ACCT-UNITVLD-ACCT-UNIT, GLM-ACCOUNTVLD-ACCOUNT, GLM-SUB-ACCOUNTVLD-SUB-ACCOUNT, VLD-SYSTEM
Glacctvld SysGLACCTVLD"M"VLD-RECORD-TYPE, GLM-CHART-NAMEVLD-CHART-NAME, GDT-SUMRY-ACCT-IDVLD-SUMRY-ACCT-ID, GLM-ACCOUNTVLD-ACCOUNT, GLM-SUB-ACCOUNTVLD-SUB-ACCOUNT, GLM-COMPANYVLD-COMPANY, GLM-ACCT-UNITVLD-ACCT-UNIT, VLD-SYSTEM
GlcommitGLCOMMITGLM-COMPANYGOT-COMPANY, GLM-ACCT-UNITGOT-ACCT-UNIT, GLM-ACCOUNTGOT-ACCOUNT, GLM-SUB-ACCOUNTGOT-SUB-ACCOUNT, GOT-FISCAL-YEAR, GOT-SYSTEM
GlcommitxGLCOMMITXGLM-COMPANYGOX-COMPANY, GLM-ACCT-UNITGOX-ACCT-UNIT, GLM-ACCOUNTGOX-ACCOUNT, GLM-SUB-ACCOUNTGOX-SUB-ACCOUNT, GOX-FISCAL-YEAR, GOX-PERIOD, GOX-SYSTEM, GOX-CURRENCY-CODE, GOX-GLT-OBJ-ID
GlhistcomGLHISTCOMGLM-COMPANYGHT-COMPANY, GLM-ACCT-UNITGHT-ACCT-UNIT, GLM-ACCOUNTGHT-ACCOUNT, GLM-SUB-ACCOUNTGHT-SUB-ACCOUNT, GHT-YEAR, GHT-SYSTEM, GHT-UNIQUE-I-D
GlmasteruaGLMASTERAUGLM-COMPANYGLK-COMPANY, GLM-ACCT-UNITGLK-ACCT-UNIT, GLM-ACCOUNTGLK-ACCOUNT, GLM-SUB-ACCOUNTGLK-SUB-ACCOUNT, GLK-ACTION, GLK-DATE, GLK-TIME, GLK-UNIQUE-I-D
Othr Acct UnitGLMASTERGLM-COMPANYGLM-COMPANY, GLM-ACCOUNTGLM-ACCOUNT, GLM-SUB-ACCOUNTGLM-SUB-ACCOUNT, GLM-VAR-LEVELS, GLM-ACCT-UNIT
Trans All PrdsGLTRANSGLM-COMPANYGLT-TO-COMPANY, GLM-ACCOUNTGLT-ACCOUNT, GLM-SUB-ACCOUNTGLT-SUB-ACCOUNT, GLM-ACCT-UNITGLT-ACCT-UNIT, GLS-FISCAL-YEARGLT-FISCAL-YEAR, GLT-ACCT-PERIOD, GLT-SYSTEM, GLT-CONTROL-GROUP, GLT-JE-TYPE, GLT-JE-SEQUENCE, GLT-LINE-NBR, GLT-COMPANY
TransactionsGLTRANSGLM-COMPANYGLT-TO-COMPANY, GLS-FISCAL-YEARGLT-FISCAL-YEAR, GLS-ACCT-PERIODGLT-ACCT-PERIOD, GLM-ACCT-UNITGLT-ACCT-UNIT, GLM-ACCOUNTGLT-ACCOUNT, GLM-SUB-ACCOUNTGLT-SUB-ACCOUNT, GLT-POSTING-DATE, GLT-SYSTEM, GLT-CONTROL-GROUP, GLT-JE-TYPE, GLT-LINE-NBR, GLT-COMPANY, GLT-JE-SEQUENCE
UnitsGLUNITSDelete RestrictedGLM-COMPANYGLU-COMPANY, GLM-ACCOUNTGLU-ACCOUNT, GLM-SUB-ACCOUNTGLU-SUB-ACCOUNT, GLM-VAR-LEVELSGLU-VAR-LEVELS, GLM-ACCT-UNITGLU-ACCT-UNIT, GLU-FISCAL-YEAR

Programs

Updated by (144)

Referenced by (396)