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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET3
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 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
GHBSET1
  1. COMPANY
  2. YEAR
  3. ACCT-UNIT
  4. ACCOUNT
  5. SUB-ACCOUNT
  6. SYSTEM
  7. ACTIVITY
  8. ACCT-CATEGORY
PrimaryAP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +22 more (list truncated in source)
GHBSET2
  1. COMPANY
  2. YEAR
  3. ACCOUNT
  4. SUB-ACCOUNT
  5. ACCT-UNIT
  6. SYSTEM
  7. ACTIVITY
  8. ACCT-CATEGORY
GL199
GHBSET3
  1. COMPANY
  2. YEAR
  3. VAR-LEVELS
  4. ACCOUNT
  5. SUB-ACCOUNT
  6. ACCT-UNIT
  7. SYSTEM
  8. ACTIVITY
  9. ACCT-CATEGORY
—
GHBSET4
  1. ACTIVITY
  2. ACCT-CATEGORY
  3. YEAR
  4. COMPANY
  5. ACCT-UNIT
  6. ACCOUNT
  7. SUB-ACCOUNT
  8. SYSTEM
KeyChange, SubsetWhere ACTIVITY != SpacesGL93.2
GHBSET5
  1. ACTIVITY
  2. YEAR
  3. ACCT-CATEGORY
  4. COMPANY
  5. ACCT-UNIT
  6. ACCOUNT
  7. SUB-ACCOUNT
  8. SYSTEM
SubsetWhere ACTIVITY != SpacesGL299

Relations

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

One to one (4) — lookups and parents

RelationTableRulesConditionField map
AcactivityACACTIVITYRequired
GHB-ACTIVITY→ACV-ACTIVITY
Acct UnitGLNAMESRequired
GHB-COMPANY→GLN-COMPANY
GHB-ACCT-UNIT→GLN-ACCT-UNIT
CompanyGLSYSTEMRequired
GHB-COMPANY→GLS-COMPANY
GlmasterGLMASTERRequired
GHB-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)