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.

Field / column	Type	Description & values	Updated 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`GCLSET1`	`COMPANY`, `FISCAL-YEAR`, `ACCT-PERIOD`, `CONTROL-GROUP`	Primary		GL276, GL76.1, GL76.2

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	GLSYSTEM	Required		`GCL-COMPANY` → `GLS-COMPANY`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Glcomcntrl	GLCOMTRANS			`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`
Glcomtrans	GLCOMTRANS			`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)

GL276 Manual Commitment Entry Report
GL76.1 Manual Commitment Entry
GL76.2 Manual Commitment Entry Copy