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

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 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
GLZSET1
  1. COMPANY
  2. ZONE
PrimaryAP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +22 more (list truncated in source)

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
Bs Acct UnitGLNAMESRequired
GLZ-COMPANY→GLN-COMPANY
GLZ-BS-ACCT-UNIT→GLN-ACCT-UNIT
CompanyGLSYSTEMRequired
GLZ-COMPANY→GLS-COMPANY
Is Acct UnitGLNAMESRequired
GLZ-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)