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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET2 SET3 SET5
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 SET4 SET5
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 SET6
OBJ_ID		Numeric 12The object ID.GL110, GL124, GL161, GL20.1
#GLN-PARENT-OBJ-ID SET7
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GLNSET1
  1. COMPANY
  2. ACCT-UNIT
PrimaryAC121, AC123, AC130, AC145, AC190, AC191, AC197, AC20.1 +22 more (list truncated in source)
GLNSET2
  1. COMPANY
  2. VAR-LEVELS
  3. ACCT-UNIT
KeyChangeAC191, ACVW.1, ATVW.1, AD120, AP125, AP126, AP20.1, AP20.2 +22 more (list truncated in source)
GLNSET3
  1. VAR-LEVELS
  2. COMPANY
  3. ACCT-UNIT
KeyChange, SubsetWhere POSTING-FLAG = "P"FB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1, FB95.2 +22 more (list truncated in source)
GLNSET4
  1. COMPANY
  2. LEVEL-DEPTH
  3. ACCT-UNIT
KeyChangeGL148, GL190, GL196, GL199, ML190, ML196, ML199
GLNSET5
  1. COMPANY
  2. LEVEL-DEPTH
  3. VAR-LEVELS
  4. ACCT-UNIT
KeyChangeFB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1, FB95.2 +22 more (list truncated in source)
GLNSET6
  1. OBJ-ID
AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
GLNSET7
  1. PARENT-OBJ-ID
  2. COMPANY
  3. ACCT-UNIT
KeyChange—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ADDRDATAGLAUDITGLSYSTEMGLADDRESSGLNAMESBODGLZONEOBJIDGLNAMESGLMASTERGLNAMESAUAUMXCONVAUMXVALUEGLAUDITGLNAMESGLACCTVLDGLCONSOLGLZONEMXLISTMBRGLNAMES

One to one (8) — lookups and parents

RelationTableRulesConditionField map
AddrdataADDRDATANot Required
GAD-ADDR-CODE→GDD-ADDR-CODE (GDDSET1)
Audit PendingGLAUDITNot Required
GLN-COMPANY→GLA-COMPANY
GLN-ACCT-UNIT→GLA-ACCT-UNIT
Zeroes→GLA-PROCESS-DATE
Zeroes→GLA-PROCESS-TIME
CompanyGLSYSTEMRequired
GLN-COMPANY→GLS-COMPANY
GladdressGLADDRESSNot Required, Delete Cascades
GLN-COMPANY→GAD-COMPANY
GLN-ACCT-UNIT→GAD-ACCT-UNIT
GlnamesbodGLNAMESBODNot Required, Delete Cascades
GLN-COMPANY→YBX-COMPANY
GLN-ACCT-UNIT→YBX-ACCT-UNIT
GlzoneGLZONENot Required
GLN-COMPANY→GLZ-COMPANY
GLN-MY-ZONE-GROUP→GLZ-ZONE
Object IdOBJIDNot Required
"ACCTU"→OBI-OBJ-TYPE
ParentGLNAMESNot Required
GLN-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
AcctunitauditGLNAMESAU
GLN-COMPANY→GNA-COMPANY
GLN-ACCT-UNIT→GNA-ACCT-UNIT
—→GNA-ACTION
—→GNA-DATE
—→GNA-TIME
—→GNA-UNIQUE-I-D
AumxconvAUMXCONV
GLN-OLD-COMPANY-D→AUC-OLD-COMPANY
—→AUC-RUN-GROUP
—→AUC-MATRIX-CAT
—→AUC-EFFECTIVE-DATE
AumxvalueAUMXVALUEDelete Cascades
GLN-OBJ-ID→AMV-OBJ-ID
—→AMV-MATRIX-CAT
Aumxvalue UserAUMXVALUE
GLN-OBJ-ID→AMV-OBJ-ID
—→AMV-MATRIX-CAT
Change AuditGLAUDITDelete Cascades
GLN-COMPANY→GLA-COMPANY
GLN-ACCT-UNIT→GLA-ACCT-UNIT
—→GLA-PROCESS-DATE
—→GLA-PROCESS-TIME
ChildrenGLNAMES
GLN-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
GlconsolGLCONSOL
GLN-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
GlnamesGLNAMES
GLN-COMPANY→GLN-COMPANY
—→GLN-VAR-LEVELS
—→GLN-ACCT-UNIT
Glzones ManyGLZONE
GLN-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 AuGLNAMESRequired
GLN-COMPANY→GLN-COMPANY
1→GLN-LEVEL-DEPTH
GLN-MY-ZONE-GROUP→GLN-VAR-LEVELS
—→GLN-ACCT-UNIT
My ZoneGLNAMES
GLN-COMPANY→GLN-COMPANY
1→GLN-LEVEL-DEPTH
GLN-MY-ZONE-GROUP→GLN-VAR-LEVELS
—→GLN-ACCT-UNIT

Programs

Updated by (7)

Referenced by (708)