GLZONE – General Ledger Zone

System
General Ledger (GL)
Prefix
GLZ
Primary key
COMPANY, ZONE
Fields
4
Updated by
2 programs
Referenced by
88 programs

GLZONE is the General Ledger Zone table in Lawson General Ledger (prefix GLZ). It is indexed by COMPANY, ZONE (GLZSET1). It is related 1:1 to GLNAMES and GLSYSTEM and 1:M to GLINTCO. It is updated by GL110 and GL30.2 and referenced by AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 and 80 more. The table has 4 fields, 1 index and 4 documented relations.

About GLZONE

This file contains the zone relationships set up in the interzone processing programs. The zone relationships contain companies with payable and receivable accounts. If you request automatic zone balancing when you define your company, error suspense, and retained earnings accounts are also stored in this file.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
GLZ-COMPANY PK
COMPANY		Numeric 4The company number as defined in GL10.1 (Company).GL110, GL30.2
GLZ-ZONE PK
ZONE		Alpha 15A zone identifies a group of accounting units that stay in balance when transactions pass between defined zone areas.GL30.2
GLZ-BS-ACCT-UNIT
BS_ACCT_UNIT		Alpha 15The zone balance sheet accounting unit.GL30.2
GLZ-IS-ACCT-UNIT
IS_ACCT_UNIT		Alpha 15The zone Income Statement accounting unit.GL30.2

Indexes (1)

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

IndexKeysFlagsConditionUsed in
GLZSET1COMPANY, ZONEPrimaryAP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
Bs Acct UnitGLNAMESRequiredGLZ-COMPANY → GLN-COMPANY, GLZ-BS-ACCT-UNIT → GLN-ACCT-UNIT
CompanyGLSYSTEMRequiredGLZ-COMPANY → GLS-COMPANY
Is Acct UnitGLNAMESRequiredGLZ-COMPANY → GLN-COMPANY, GLZ-IS-ACCT-UNIT → GLN-ACCT-UNIT

One to many (1) — child tables

RelationTableRulesConditionField map
GlintcoGLINTCO"L" → GIC-RECORD-TYPE, GLZ-COMPANY → GIC-COMPANY-A, Zeroes → GIC-COMPANY-B, GLZ-ZONE → GIC-ZONE-A, → GIC-ZONE-B, → GIC-SYSTEM

Programs

Updated by (2)

Referenced by (88)