GLHISCOMBL – No description in the Lawson data dictionary

System
General Ledger (GL)
Prefix
GHB
Primary key
COMPANY, YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, SYSTEM, ACTIVITY, ACCT-CATEGORY
Fields
12
Updated by
320 programs
Referenced by
3 programs

GLHISCOMBL is a Lawson General Ledger table (prefix GHB); no description in the lawson data dictionary. It is indexed by COMPANY, YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, SYSTEM, ACTIVITY, ACCT-CATEGORY (GHBSET1); alternate indexes: GHBSET2, GHBSET3, GHBSET4 and GHBSET5. It is related 1:1 to ACACTIVITY, GLNAMES, GLSYSTEM and GLMASTER. It is updated by AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 and 312 more and referenced by GL299, GL93.1 and GL93.2. The table has 12 fields, 5 indexes and 4 documented relations.

About GLHISCOMBL

No description in the Lawson data dictionary.

Fields (12)

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

Field / columnTypeDescription & valuesUpdated by
GHB-COMPANY PK
COMPANY		Numeric 4—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHB-ACCT-UNIT PK
ACCT_UNIT		Alpha 15—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHB-ACCOUNT PK
ACCOUNT		Numeric 6—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHB-SUB-ACCOUNT PK
SUB_ACCOUNT		Numeric 4—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHB-YEAR PK
YEAR		Numeric 4—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHB-ACTIVITY PK
ACTIVITY		Alpha 15—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHB-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHB-VAR-LEVELS
VAR_LEVELS		Alpha 30—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHB-SYSTEM PK
SYSTEM		Alpha 2—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHB-FUND-GROUP
FUND_GROUP		Alpha 15—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHB-BEG-BAL
BEG_BAL		Signed 18.2—GL199, GL322
GHB-AMOUNT
AMOUNT		Signed 18.2 Occurs 13 Times ×13—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)

Indexes (5)

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

IndexKeysFlagsConditionUsed in
GHBSET1COMPANY, YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, SYSTEM, ACTIVITY, ACCT-CATEGORYPrimaryAP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +22 more (list truncated in source)
GHBSET2COMPANY, YEAR, ACCOUNT, SUB-ACCOUNT, ACCT-UNIT, SYSTEM, ACTIVITY, ACCT-CATEGORYGL199
GHBSET3COMPANY, YEAR, VAR-LEVELS, ACCOUNT, SUB-ACCOUNT, ACCT-UNIT, SYSTEM, ACTIVITY, ACCT-CATEGORY—
GHBSET4ACTIVITY, ACCT-CATEGORY, YEAR, COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, SYSTEMKeyChange, SubsetWhere ACTIVITY != SpacesGL93.2
GHBSET5ACTIVITY, YEAR, ACCT-CATEGORY, COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, SYSTEMSubsetWhere ACTIVITY != SpacesGL299

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
AcactivityACACTIVITYRequiredGHB-ACTIVITY → ACV-ACTIVITY
Acct UnitGLNAMESRequiredGHB-COMPANY → GLN-COMPANY, GHB-ACCT-UNIT → GLN-ACCT-UNIT
CompanyGLSYSTEMRequiredGHB-COMPANY → GLS-COMPANY
GlmasterGLMASTERRequiredGHB-COMPANY → GLM-COMPANY, GHB-ACCT-UNIT → GLM-ACCT-UNIT, GHB-ACCOUNT → GLM-ACCOUNT, GHB-SUB-ACCOUNT → GLM-SUB-ACCOUNT

Programs

Updated by (320)

Referenced by (3)