GLNAMES – General Ledger Names

System
General Ledger Setup (IF)
Prefix
GLN
Primary key
COMPANY, ACCT-UNIT
Fields
28
Updated by
7 programs
Referenced by
708 programs

GLNAMES is the General Ledger Names table in Lawson General Ledger Setup (prefix GLN). It is indexed by COMPANY, ACCT-UNIT (GLNSET1); alternate indexes: GLNSET2, GLNSET3, GLNSET4, GLNSET5, GLNSET6 and GLNSET7. It is related 1:1 to ADDRDATA, GLAUDIT, GLSYSTEM, GLADDRESS, GLNAMESBOD, GLZONE, OBJID and GLNAMES and 1:M to GLMASTER, GLNAMESAU, AUMXCONV, AUMXVALUE, GLAUDIT, GLNAMES, GLACCTVLD, GLCONSOL and 2 more. It is updated by CA110, GL110, GL120, GL124, GL125, GL161 and GL20.1 and referenced by AC121, AC123, AC130, AC145, AC190, AC191, AC197, AC20.1 and 700 more. The table has 28 fields, 7 indexes and 22 documented relations.

About GLNAMES

This file contains information about accounting units and their corresponding levels. This information represents the hierarchical structure of each company defined in the Lawson General Ledger System. All Lawson subsystems verify the existence of the accounting unit against this file.

Fields (28)

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

Field / columnTypeDescription & valuesUpdated by
GLN-COMPANY PK
COMPANY		Numeric 4Required. The identifier of the highest level entity throughout all Lawson applications. Must be defined in the GLSYSTEM file.GL110, GL124, GL161, GL20.1
GLN-ACCT-UNIT PK
ACCT_UNIT		Alpha 15Required. The accounting unit is a shorthand notation representing the variable level number.GL124, GL161, GL20.1
GLN-OLD-COMPANY-D
OLD_COMPANY_D		DerivedContains the old company derived.—
GLN-VAR-LEVELS
VAR_LEVELS		Alpha 30Required field if Lawson General Ledger user. 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.GL120, GL124, GL161, GL20.1
GLN-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The company description.GL124, GL161, GL20.1
GLN-SHORT-DESC
SHORT_DESC		DerivedThe short description.—
GLN-CHART-SECTION
CHART_SECTION		Alpha 1The chart section. " " = All Sections
  • 1 Balance Sheet
  • 2 Income Statement
GL124, GL161, GL20.1
GLN-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company's base currency code.GL124, GL125, GL161, GL20.1
GLN-PERSON-RESP
PERSON_RESP		Alpha 15 (Lower Case)This field is used to store a name of a person responsible for an accounting unit. This field is not edited in any way. Used in Lawson's Report Writer.GL124, GL125, GL161, GL20.1
GLN-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1Required. This field is used to indicate if an accounting unit is active or inactive. If an accounting unit is inactive, all associated accounts are also inactive and no posting can occur.
  • A Active
  • I Inactive
GL124, GL125, GL161, GL20.1
GLN-ACCT-GENERATE
ACCT_GENERATE		Alpha 1Indicates if an account is automatically generated against a group of accounting units.—
GLN-POSTING-FLAG
POSTING_FLAG		Alpha 1This field is used to indicate posting accounting units and summary level accounting units. Posting levels may have a chart of accounts and transaction activity. Summary levels are used to consolidate information from lower level accounting units. Summary levels do not have a chart of accounts, nor do they allow transaction activity. They are created to meet reporting needs.
  • P Posting
  • S Summary
GL124, GL161, GL20.1
GLN-POSTING-FLG-1
POSTING_FLG_1		DerivedDerived.—
GLN-VAR-LEVEL-DISP
VAR_LEVEL_DISP		Alpha 34Variable level field in display format.GL120, GL124, GL161, GL20.1
GLN-VL-DISP-SHORT
VL_DISP_SHORT		DerivedDerived.—
GLN-LEVEL-DEPTH
LEVEL_DEPTH		Numeric 1The depth assigned to the accounting unit.
  • 1 Level 1
  • 2 Level 2
  • 3 Level 3
  • 4 Level 4
  • 5 Level 5
GL120, GL124, GL161, GL20.1
GLN-LEVEL-DETAIL
LEVEL_DETAIL		Numeric 15 Occurs 5 Times ×5Identifies the accounting unit location in the company structure. The value of each variable level determines how the general ledger combines the accounting units.GL120, GL124, GL161, GL20.1
GLN-ADDRESS-EXIST
ADDRESS_EXIST		DerivedIndicates address information exists.—
GLN-MY-ZONE
MY_ZONE		DerivedThe zone value.—
GLN-MY-ZONE-GROUP
MY_ZONE_GROUP		DerivedThe zone group.—
GLN-ZONE-EXISTS
ZONE_EXISTS		DerivedIndicates company zone balancing exists.—
GLN-OBJ-TYPE-ACCTU
OBJ_TYPE_ACCTU		DerivedThe accounting unit object type.—
GLN-OBJ-ID
OBJ_ID		Numeric 12The object ID.GL110, GL124, GL161, GL20.1
GLN-PARENT-OBJ-ID
PARENT_OBJ_ID		Numeric 12The parent object ID.GL110, GL120, GL124, GL161, GL20.1
GLN-CREATED-BY
CREATED_BY		Alpha 10—GL124, GL161, GL20.1
GLN-LAST-UPDT-DATE
LAST_UPDT_DATE		Numeric 8 (yyyymmdd)—GL110, GL120, GL124, GL125, GL161, GL20.1
GLN-LAST-UPDT-TIME
LAST_UPDT_TIME		Numeric 8—GL120, GL124, GL125, GL161, GL20.1
GLN-LAST-UPDATE-BY
LAST_UPDATE_BY		Alpha 10—GL110, GL120, GL124, GL125, GL161, GL20.1

Indexes (7)

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

IndexKeysFlagsConditionUsed in
GLNSET1COMPANY, ACCT-UNITPrimaryAC121, AC123, AC130, AC145, AC190, AC191, AC197, AC20.1 +22 more (list truncated in source)
GLNSET2COMPANY, VAR-LEVELS, ACCT-UNITKeyChangeAC191, ACVW.1, ATVW.1, AD120, AP125, AP126, AP20.1, AP20.2 +22 more (list truncated in source)
GLNSET3VAR-LEVELS, COMPANY, ACCT-UNITKeyChange, SubsetWhere POSTING-FLAG = "P"FB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1, FB95.2 +22 more (list truncated in source)
GLNSET4COMPANY, LEVEL-DEPTH, ACCT-UNITKeyChangeGL148, GL190, GL196, GL199, ML190, ML196, ML199
GLNSET5COMPANY, LEVEL-DEPTH, VAR-LEVELS, ACCT-UNITKeyChangeFB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1, FB95.2 +22 more (list truncated in source)
GLNSET6OBJ-IDAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
GLNSET7PARENT-OBJ-ID, COMPANY, ACCT-UNITKeyChange—

Relations

One to one (8) — lookups and parents

RelationTableRulesConditionField map
AddrdataADDRDATANot RequiredGAD-ADDR-CODE → GDD-ADDR-CODE (GDDSET1)
Audit PendingGLAUDITNot RequiredGLN-COMPANY → GLA-COMPANY, GLN-ACCT-UNIT → GLA-ACCT-UNIT, Zeroes → GLA-PROCESS-DATE, Zeroes → GLA-PROCESS-TIME
CompanyGLSYSTEMRequiredGLN-COMPANY → GLS-COMPANY
GladdressGLADDRESSNot Required, Delete CascadesGLN-COMPANY → GAD-COMPANY, GLN-ACCT-UNIT → GAD-ACCT-UNIT
GlnamesbodGLNAMESBODNot Required, Delete CascadesGLN-COMPANY → YBX-COMPANY, GLN-ACCT-UNIT → YBX-ACCT-UNIT
GlzoneGLZONENot RequiredGLN-COMPANY → GLZ-COMPANY, GLN-MY-ZONE-GROUP → GLZ-ZONE
Object IdOBJIDNot Required"ACCTU" → OBI-OBJ-TYPE
ParentGLNAMESNot RequiredGLN-PARENT-OBJ-ID → GLN-OBJ-ID

One to many (14) — child tables

RelationTableRulesConditionField map
Accts AuGLMASTERDelete RestrictedValid When GLN-POSTING-FLAG = "P"GLN-COMPANY → GLM-COMPANY, GLN-ACCT-UNIT → GLM-ACCT-UNIT, → GLM-ACCOUNT, → GLM-SUB-ACCOUNT
AcctunitauditGLNAMESAUGLN-COMPANY → GNA-COMPANY, GLN-ACCT-UNIT → GNA-ACCT-UNIT, → GNA-ACTION, → GNA-DATE, → GNA-TIME, → GNA-UNIQUE-I-D
AumxconvAUMXCONVGLN-OLD-COMPANY-D → AUC-OLD-COMPANY, → AUC-RUN-GROUP, → AUC-MATRIX-CAT, → AUC-EFFECTIVE-DATE
AumxvalueAUMXVALUEDelete CascadesGLN-OBJ-ID → AMV-OBJ-ID, → AMV-MATRIX-CAT
Aumxvalue UserAUMXVALUEGLN-OBJ-ID → AMV-OBJ-ID, → AMV-MATRIX-CAT
Change AuditGLAUDITDelete CascadesGLN-COMPANY → GLA-COMPANY, GLN-ACCT-UNIT → GLA-ACCT-UNIT, → GLA-PROCESS-DATE, → GLA-PROCESS-TIME
ChildrenGLNAMESGLN-OBJ-ID → GLN-PARENT-OBJ-ID, → GLN-COMPANY, → GLN-ACCT-UNIT
Glacctvld SysGLACCTVLD"N" → VLD-RECORD-TYPE, Spaces → VLD-CHART-NAME, Zeroes → VLD-SUMRY-ACCT-ID, Zeroes → VLD-ACCOUNT, Zeroes → VLD-SUB-ACCOUNT, GLN-COMPANY → VLD-COMPANY, GLN-ACCT-UNIT → VLD-ACCT-UNIT, → VLD-SYSTEM
GlconsolGLCONSOLGLN-COMPANY → GCN-COMPANY, "A" → GCN-TRANS-TYPE, Zeroes → GCN-BUDGET-NBR, GLS-FISCAL-YEAR → GCN-FISCAL-YEAR, GLN-VAR-LEVELS → GCN-VAR-LEVELS, → GCN-ACCOUNT, → GCN-SUB-ACCOUNT, → GCN-CURRENCY-CODE, → GCN-LEVEL-DEPTH
GlnamesGLNAMESGLN-COMPANY → GLN-COMPANY, → GLN-VAR-LEVELS, → GLN-ACCT-UNIT
Glzones ManyGLZONEGLN-COMPANY → GLZ-COMPANY, → GLZ-ZONE
Member In ListMXLISTMBRDelete Cascades"ACCTU" → MLM-OBJ-TYPE, GLN-OBJ-ID → MLM-OBJ-ID, → MLM-MATRIX-LIST
My Lvl 1 AuGLNAMESRequiredGLN-COMPANY → GLN-COMPANY, 1 → GLN-LEVEL-DEPTH, GLN-MY-ZONE-GROUP → GLN-VAR-LEVELS, → GLN-ACCT-UNIT
My ZoneGLNAMESGLN-COMPANY → GLN-COMPANY, 1 → GLN-LEVEL-DEPTH, GLN-MY-ZONE-GROUP → GLN-VAR-LEVELS, → GLN-ACCT-UNIT

Programs

Updated by (7)

Referenced by (708)