GLHISTCOM – No description in the Lawson data dictionary

System
General Ledger (GL)
Prefix
GHT
Primary key
COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, YEAR, SYSTEM, UNIQUE-I-D
Fields
15
Updated by
1 program
Referenced by
1 program

GLHISTCOM is a Lawson General Ledger table (prefix GHT); no description in the lawson data dictionary. It is indexed by COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, YEAR, SYSTEM, UNIQUE-I-D (GHTSET1); alternate indexes: GHTSET2, GHTSET3, GHTSET4 and GHTUID. It is related 1:1 to GLCOMMIT and GLMASTER and 1:M to FBDETAIL. It is updated by GL192 and referenced by GLRV.1. The table has 15 fields, 5 indexes and 3 documented relations.

About GLHISTCOM

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the GHT- 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
#GHT-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
#GHT-COMPANY PK
COMPANY		Numeric 4—GL192
#GHT-ACCT-UNIT PK
ACCT_UNIT		Alpha 15—GL192
#GHT-ACCOUNT PK
ACCOUNT		Numeric 6—GL192
#GHT-SUB-ACCOUNT PK
SUB_ACCOUNT		Numeric 4—GL192
#GHT-YEAR PK
YEAR		Numeric 4—GL192
#GHT-VAR-LEVELS SET2
VAR_LEVELS		Alpha 30—GL192
#GHT-SYSTEM PK
SYSTEM		Alpha 2—GL192
#GHT-DB-AMOUNT
DB_AMOUNT		Signed 18.2 Occurs 13 Times ×13—GL192
#GHT-CR-AMOUNT
CR_AMOUNT		Signed 18.2 Occurs 13 Times ×13—GL192
#GHT-DB-UNITS
DB_UNITS		Signed 15.2 Occurs 13 Times ×13—GL192
#GHT-CR-UNITS
CR_UNITS		Signed 15.2 Occurs 13 Times ×13—GL192
#GHT-MAINT-DATE
MAINT_DATE		Numeric 8 (yyyymmdd)—GL192
#GHT-MAINT-TIME
MAINT_TIME		Numeric 6 (hhmmss)—GL192
#GHT-FUND-GROUP SET4
FUND_GROUP		Alpha 15—GL192

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
GHTSET1
  1. COMPANY
  2. ACCT-UNIT
  3. ACCOUNT
  4. SUB-ACCOUNT
  5. YEAR
  6. SYSTEM
  7. UNIQUE-I-D
Primary, KeyChangeGL192
GHTSET2
  1. COMPANY
  2. VAR-LEVELS
  3. ACCOUNT
  4. SUB-ACCOUNT
  5. ACCT-UNIT
  6. YEAR
  7. SYSTEM
  8. UNIQUE-I-D
KeyChangeGLRV.1
GHTSET3
  1. COMPANY
  2. ACCOUNT
  3. SUB-ACCOUNT
  4. ACCT-UNIT
  5. YEAR
  6. SYSTEM
  7. UNIQUE-I-D
KeyChangeGL192
GHTSET4
  1. COMPANY
  2. FUND-GROUP
  3. YEAR
  4. SYSTEM
  5. ACCT-UNIT
  6. ACCOUNT
  7. SUB-ACCOUNT
  8. UNIQUE-I-D
KeyChange, SubsetWhere FUND-GROUP != Spaces—
GHTUID
  1. UNIQUE-I-D
—

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
GlcommitGLCOMMITNot Required
GHT-COMPANY→GOT-COMPANY (GOTSET1)
GHT-ACCT-UNIT→GOT-ACCT-UNIT
GHT-ACCOUNT→GOT-ACCOUNT
GHT-SUB-ACCOUNT→GOT-SUB-ACCOUNT
GHT-YEAR→GOT-FISCAL-YEAR
GHT-SYSTEM→GOT-SYSTEM
GlmasterGLMASTERRequired
GHT-COMPANY→GLM-COMPANY
GHT-ACCT-UNIT→GLM-ACCT-UNIT
GHT-ACCOUNT→GLM-ACCOUNT
GHT-SUB-ACCOUNT→GLM-SUB-ACCOUNT

One to many (1) — child tables

RelationTableRulesConditionField map
FbdetailFBDETAIL
GHT-COMPANY→FBD-COMPANY
GHT-ACCT-UNIT→FBD-ACCT-UNIT
GHT-ACCOUNT→FBD-ACCOUNT
GHT-SUB-ACCOUNT→FBD-SUB-ACCOUNT
—→FBD-BUDGET-NBR
—→FBD-FISCAL-YEAR

Programs

Updated by (1)

Referenced by (1)