GLCOMTRANS – No description in the Lawson data dictionary

System: General Ledger (GL)
Prefix: GCT
Primary key: COMPANY, FISCAL-YEAR, ACCT-PERIOD, CONTROL-GROUP, LINE-NBR
Fields: 17
Updated by: 2 programs
Referenced by: 1 program

GLCOMTRANS is a Lawson General Ledger table (prefix GCT); no description in the lawson data dictionary. It is indexed by COMPANY, FISCAL-YEAR, ACCT-PERIOD, CONTROL-GROUP, LINE-NBR (GCTSET1); alternate indexes: GCTSET2, GCTSET3 and GCTSET4. It is related 1:1 to GLSYSTEM and GLCOMCNTRL. It is updated by GL76.1 and GL76.2 and referenced by GL276. The table has 17 fields, 4 indexes and 2 documented relations.

About GLCOMTRANS

No description in the Lawson data dictionary.

Fields (17)

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

Field / column	Type	Description & values	Updated by
`GCT-COMPANY` PK COMPANY	Numeric 4	—	GL76.1, GL76.2
`GCT-FISCAL-YEAR` PK FISCAL_YEAR	Numeric 4	—	GL76.1, GL76.2
`GCT-ACCT-PERIOD` PK ACCT_PERIOD	Numeric 2	—	GL76.1, GL76.2
`GCT-CONTROL-GROUP` PK CONTROL_GROUP	Numeric 8	—	GL76.1, GL76.2
`GCT-LINE-NBR` PK LINE_NBR	Numeric 6	—	GL76.1
`GCT-ACCT-UNIT` ACCT_UNIT	Alpha 15	—	GL76.1
`GCT-ACCOUNT` ACCOUNT	Numeric 6	—	GL76.1
`GCT-SUB-ACCOUNT` SUB_ACCOUNT	Numeric 4	—	GL76.1
`GCT-ENTRY-DATE` ENTRY_DATE	Numeric 8 (yyyymmdd)	—	GL76.1
`GCT-ENTRY-CODE` ENTRY_CODE	Alpha 3	—	—
`GCT-OPERATOR` OPERATOR	Alpha 10	—	—
`GCT-GOX-OBJ-ID` GOX_OBJ_ID	Numeric 12	—	GL76.1, GL76.2
`GCT-TRANS-AMOUNT` TRANS_AMOUNT	Signed 18.2	—	GL76.1, GL76.2
`GCT-UNIT` UNIT	Signed 15.2	—	GL76.1
`GCT-ACTIVITY` ACTIVITY	Alpha 15	—	GL76.1
`GCT-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	—	GL76.1
`GCT-MIX-OBJ-ID` MIX_OBJ_ID	Numeric 12	—	GL76.1, GL76.2

Indexes (4)

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
`GCTSET1`	`COMPANY`, `FISCAL-YEAR`, `ACCT-PERIOD`, `CONTROL-GROUP`, `LINE-NBR`	Primary		GL276, GL76.1, GL76.2
`GCTSET2`	`GOX-OBJ-ID`	KeyChange, Subset	Where GOX-OBJ-ID != Zeroes	GL76.1
`GCTSET3`	`COMPANY`, `ACCT-UNIT`, `ACCOUNT`, `SUB-ACCOUNT`, `FISCAL-YEAR`, `ACCT-PERIOD`, `CONTROL-GROUP`, `LINE-NBR`	KeyChange		—
`GCTSET4`	`MIX-OBJ-ID`	KeyChange, Subset	Where MIX-OBJ-ID != Zeroes	—

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	GLSYSTEM	Required		`GCT-COMPANY` → `GLS-COMPANY (GLSSET1)`
Glcomcntrl	GLCOMCNTRL	Required		`GCT-COMPANY` → `GCL-COMPANY`, `GCT-FISCAL-YEAR` → `GCL-FISCAL-YEAR`, `GCT-ACCT-PERIOD` → `GCL-ACCT-PERIOD`, `GCT-CONTROL-GROUP` → `GCL-CONTROL-GROUP`

GLCOMTRANS – No description in the Lawson data dictionary

About GLCOMTRANS

Fields (17)

Indexes (4)

Relations

One to one (2) — lookups and parents

Programs

Updated by (2)

Referenced by (1)