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.

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
SEQ_NBR
Numeric 4Contains the assigned sequence number.GL11.1

Indexes (3)

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

IndexKeysFlagsConditionUsed in
GCCSET1COMPANY, COMPANY-GROUPPrimaryAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
GCCSET2COMPANY-GROUP, SEQ-NBR, COMPANYKeyChangeAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
GCCSET3COMPANY-GROUP, COMPANYAC160, AC195, AC34.1, AD120, AD190, AD210, AD290, AD300 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyGLSYSTEMRequiredGCC-COMPANYGLS-COMPANY
GlcpygrpGLCPYGRPRequiredGCC-COMPANY-GROUPGCG-COMPANY-GROUP

Programs

Updated by (3)

Referenced by (665)