GLCBOD – No description in the Lawson data dictionary

System
General Ledger (GL)
Prefix
YCM
Primary key
COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE
Fields
13
Updated by
1 program
Referenced by
13 programs

GLCBOD is a Lawson General Ledger table (prefix YCM); no description in the lawson data dictionary. It is indexed by COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE (YCMSET1); alternate indexes: YCMSET2. It is related 1:1 to GLCONTROL. It is updated by GLBO.1 and referenced by GL146, GL170, GL197, GL40.1, GL40.2, GL40.3, GL40.7, GL40.8 and 5 more. The table has 13 fields, 2 indexes and 1 documented relation.

About GLCBOD

No description in the Lawson data dictionary.

Fields (13)

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

Field / columnTypeDescription & valuesUpdated by
YCM-COMPANY PK
COMPANY
Numeric 4GLBO.1
YCM-FISCAL-YEAR PK
FISCAL_YEAR
Numeric 4GLBO.1
YCM-ACCT-PERIOD PK
ACCT_PERIOD
Numeric 2GLBO.1
YCM-SYSTEM PK
SYSTEM
Alpha 2GLBO.1
YCM-JE-TYPE PK
JE_TYPE
Alpha 1GLBO.1
YCM-CONTROL-GROUP PK
CONTROL_GROUP
Numeric 8GLBO.1
YCM-JE-SEQUENCE PK
JE_SEQUENCE
Numeric 2GLBO.1
YCM-BOD-ACCT-ENT
BOD_ACCT_ENT
Alpha 22 (Lower Case)GLBO.1
YCM-BOD-LOCATION
BOD_LOCATION
Alpha 22 (Lower Case)GLBO.1
YCM-BOD-DOC-ID
BOD_DOC_ID
Alpha 100 (Lower Case)GLBO.1
YCM-BOD-SOR
BOD_SOR
Alpha 1GLBO.1
YCM-BOD-REVISION
BOD_REVISION
Alpha 22 (Lower Case)GLBO.1
YCM-BOD-VAR-ID
BOD_VAR_ID
Alpha 22 (Lower Case)GLBO.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
YCMSET1COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCEPrimaryGL146, GL170, GL197, GL40.1, GL40.2, GL40.3, GL40.7, GL40.8 +6 more
YCMSET2BOD-DOC-ID, BOD-ACCT-ENT, BOD-LOCATION, BOD-REVISIONGLBO.1, GLBO.2

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
GlcontrolGLCONTROLRequiredYCM-COMPANYGLC-COMPANY, YCM-FISCAL-YEARGLC-FISCAL-YEAR, YCM-ACCT-PERIODGLC-ACCT-PERIOD, YCM-SYSTEMGLC-SYSTEM, YCM-JE-TYPEGLC-JE-TYPE, YCM-CONTROL-GROUPGLC-CONTROL-GROUP, YCM-JE-SEQUENCEGLC-JE-SEQUENCE

Programs

Updated by (1)

Referenced by (13)