GLCGCPY – Company Group Company

System
General Ledger Setup (IF)
Prefix
GCC
Primary key
COMPANY, COMPANY-GROUP
Fields
3
Updated by
3 programs
Referenced by
665 programs

GLCGCPY is the Company Group Company table in Lawson General Ledger Setup (prefix GCC). It is indexed by COMPANY, COMPANY-GROUP (GCCSET1); alternate indexes: GCCSET2 and GCCSET3. It is related 1:1 to GLSYSTEM and GLCPYGRP. It is updated by GL11.1, GL11.2 and GL110 and referenced by AC121, AC123, AC130, AC160, AC195, AC20.1, AC20.2, AC20.3 and 657 more. The table has 3 fields, 3 indexes and 2 documented relations.

About GLCGCPY

The General Ledger Company Group file contains the valid groups for an existing company as defined in GL11.1 (Company Group).

Fields (3)

Column = COBOL field name without the GCC- 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
#GCC-COMPANY-GROUP PK
COMPANY_GROUP		Alpha 12The name that identifies the company group.GL11.1
#GCC-COMPANY PK
COMPANY		Numeric 4The company number as defined in GL10.1 (Company).AM190, AM195, AM255, AM266, AM282, AM285, AM295, GL11.1
#GCC-SEQ-NBR SET2
SEQ_NBR		Numeric 4Contains the assigned sequence number.GL11.1

Indexes (3)

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
GCCSET1
  1. COMPANY
  2. COMPANY-GROUP
PrimaryAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
GCCSET2
  1. COMPANY-GROUP
  2. SEQ-NBR
  3. COMPANY
KeyChangeAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
GCCSET3
  1. COMPANY-GROUP
  2. COMPANY
AC160, AC195, AC34.1, AD120, AD190, AD210, AD290, AD300 +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)
GLSYSTEMGLCPYGRPGLCGCPY

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyGLSYSTEMRequired
GCC-COMPANY→GLS-COMPANY
GlcpygrpGLCPYGRPRequired
GCC-COMPANY-GROUP→GCG-COMPANY-GROUP

Programs

Updated by (3)

Referenced by (665)