GLCOMPREL – GL Organization Relationships

System
General Ledger Setup (IF)
Prefix
GCR
Primary key
OLD-COMPANY
Fields
4
Updated by
2 programs
Referenced by
24 programs

GLCOMPREL is the GL Organization Relationships table in Lawson General Ledger Setup (prefix GCR). It is indexed by OLD-COMPANY (GCRSET1). It is related 1:1 to GLNAMES and GLSYSTEM. It is updated by GL08.1 and GL08.2 and referenced by AC527, CA160, CA60.1, FB165, FB195, FB265, FB65.1, GL162 and 16 more. The table has 4 fields, 1 index and 2 documented relations.

About GLCOMPREL

This file contains information needed to create the Lawson Company structure when converting from a non-Lawson system as defined in GL08.1 (Organization Relationship).

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
GCR-OLD-COMPANY PK
OLD_COMPANY		Alpha 35The organization code defined for the old company number.GL08.1, GL08.2
GCR-COMPANY
COMPANY		Numeric 4The company number as defined in GL10.1 (Company).GL08.1, GL08.2
GCR-ACCT-UNIT
ACCT_UNIT		Alpha 15The alphanumeric name that represents the 30-digit variable level number. The name is a unique location within the company. Once defined, the accounting unit's name cannot be changed.GL08.1, GL08.2
GCR-OLD-CPY-SHORT
OLD_CPY_SHORT		DerivedThe short description.—

Indexes (1)

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

IndexKeysFlagsConditionUsed in
GCRSET1OLD-COMPANYPrimaryAC527, CA160, CA60.1, FB165, FB195, FB265, FB65.1, GL165 +18 more

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
Acct UnitGLNAMESRequiredGCR-COMPANY → GLN-COMPANY, GCR-ACCT-UNIT → GLN-ACCT-UNIT
CompanyGLSYSTEMRequiredGCR-COMPANY → GLS-COMPANY

Programs

Updated by (2)

Referenced by (24)