GLCOMCNTRL – No description in the Lawson data dictionary

System
General Ledger (GL)
Prefix
GCL
Primary key
COMPANY, FISCAL-YEAR, ACCT-PERIOD, CONTROL-GROUP
Fields
15
Updated by
3 programs
Referenced by
0 programs

GLCOMCNTRL is a Lawson General Ledger table (prefix GCL); no description in the lawson data dictionary. It is indexed by COMPANY, FISCAL-YEAR, ACCT-PERIOD, CONTROL-GROUP (GCLSET1). It is related 1:1 to GLSYSTEM and 1:M to GLCOMTRANS. It is updated by GL276, GL76.1 and GL76.2. The table has 15 fields, 1 index and 3 documented relations.

About GLCOMCNTRL

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the GCL- 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
#GCL-COMPANY PK
COMPANY		Numeric 4—GL76.1, GL76.2
#GCL-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4—GL76.1, GL76.2
#GCL-ACCT-PERIOD PK
ACCT_PERIOD		Numeric 2—GL76.1, GL76.2
#GCL-CONTROL-GROUP PK
CONTROL_GROUP		Numeric 8—GL76.1, GL76.2
#GCL-STATUS
STATUS		Numeric 1—
  • 0 Unreleased
  • 1 Released
GL76.1, GL76.2
#GCL-ENTRY-DATE
ENTRY_DATE		Numeric 8 (yyyymmdd)—GL76.1, GL76.2
#GCL-EXP-DATE
EXP_DATE		Numeric 8 (yyyymmdd)—GL76.1, GL76.2
#GCL-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)—GL76.1, GL76.2
#GCL-LINE-NBR
LINE_NBR		Numeric 6—GL76.1
#GCL-NBR-LINES
NBR_LINES		Numeric 6—GL76.1
#GCL-OPERATOR
OPERATOR		Alpha 10—GL76.1, GL76.2
#GCL-REL-OPERATOR
REL_OPERATOR		Alpha 10—GL76.1, GL76.2
#GCL-ENTRY-TOTAL
ENTRY_TOTAL		Signed 18.2—GL76.1, GL76.2
#GCL-UNIT-TOTAL
UNIT_TOTAL		Signed 15.2—GL76.1
#GCL-USER-REFERENCE
USER_REFERENCE		Alpha 3—GL76.1, GL76.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
GCLSET1
  1. COMPANY
  2. FISCAL-YEAR
  3. ACCT-PERIOD
  4. CONTROL-GROUP
PrimaryGL276, GL76.1, GL76.2

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CompanyGLSYSTEMRequired
GCL-COMPANY→GLS-COMPANY

One to many (2) — child tables

RelationTableRulesConditionField map
GlcomcntrlGLCOMTRANS
GCL-COMPANY→GCT-COMPANY
GCL-FISCAL-YEAR→GCT-FISCAL-YEAR
GCL-ACCT-PERIOD→GCT-ACCT-PERIOD
GCL-CONTROL-GROUP→GCT-CONTROL-GROUP
—→GCT-LINE-NBR
GlcomtransGLCOMTRANS
GCL-COMPANY→GCT-COMPANY
GCL-FISCAL-YEAR→GCT-FISCAL-YEAR
GCL-ACCT-PERIOD→GCT-ACCT-PERIOD
GCL-CONTROL-GROUP→GCT-CONTROL-GROUP
—→GCT-LINE-NBR

Programs

Updated by (3)