GLHISCOMX – No description in the Lawson data dictionary

System
General Ledger (GL)
Prefix
GHX
Primary key
PARENT-DOC-ID, PAR-DOC-ID-DTL, UNIQUE-I-D
Fields
46
Updated by
322 programs
Referenced by
61 programs

GLHISCOMX is a Lawson General Ledger table (prefix GHX); no description in the lawson data dictionary. It is indexed by PARENT-DOC-ID, PAR-DOC-ID-DTL, UNIQUE-I-D (GHXSET1); alternate indexes: GHXSET2, GHXSET3, GHXSET4, GHXSET5, GHXSET6 and GHXUID. It is related 1:1 to GLMASTER, APDISTRIB, GLAMOUNTS, GLCOMMITX, GLTRANS, PAENCUMBER, POLINE, POVADIST and 2 more and 1:M to ACTRANS, APAPDHIST, APDRFTDIST, CBDISTRIB, EEDISTRIB, FBDETAIL, MMDIST, POVACOMMIT and 2 more. It is updated by AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 and 314 more and referenced by FB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1, FB95.2 and 53 more. The table has 46 fields, 7 indexes and 21 documented relations.

About GLHISCOMX

No description in the Lawson data dictionary.

Fields (46)

Column = COBOL field name without the GHX- 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
#GHX-UNIQUE-I-D PK
UNIQUE_I_D
Bad Type 36——
#GHX-COMPANY SET3 SET4
COMPANY
Numeric 4—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-ACCT-UNIT SET3
ACCT_UNIT
Alpha 15The accounting unit is a shorthad notation representing the variable level number. The accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-ACCOUNT SET3
ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location where amounts and other account information is stored.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-SUB-ACCOUNT SET3
SUB_ACCOUNT
Numeric 4This field along with the accounting unit and account make up the location where amounts and other account information is stored.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-YEAR SET3 SET4 SET6
YEAR
Numeric 4This is the year for the record.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-PERIOD SET3 SET4 SET6
PERIOD
Numeric 2this is the period for the record.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-SYSTEM SET3 SET4 SET6
SYSTEM
Alpha 2A two-character code representing the system in which the commitment is held.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-VAR-LEVELS
VAR_LEVELS
Alpha 30—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-AMOUNT
AMOUNT
Signed 18.2The amount is in the company currencyAP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-UNIT
UNIT
Signed 15.2—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-CURRENCY-CODE
CURRENCY_CODE
Alpha 5—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-BASERATE
BASERATE
Signed 14.7—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-TRAN-AMOUNT
TRAN_AMOUNT
Signed 18.2—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-TRAN-ND
TRAN_ND
Numeric 1—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-INVOICE
INVOICE
Alpha 22—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-ITEM
ITEM
Alpha 32—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-RESOURCE-COMP
RESOURCE_COMP
Numeric 4—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-RESOURCE-CODE
RESOURCE_CODE
Alpha 10—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-RESOURCE-TYPE
RESOURCE_TYPE
Alpha 1—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-RESOURCE-DESC
RESOURCE_DESC
Alpha 30 (Lower Case)—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-ACTION
ACTION
Alpha 1—
  • A Add
  • D Delete or reverse
AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-TRANS-DATE
TRANS_DATE
Numeric 8 (yyyymmdd)—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-SOURCE-CODE
SOURCE_CODE
Alpha 2—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-PROGRAM
PROGRAM
Alpha 5—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-SYS-OBJ-TYPE SET5
SYS_OBJ_TYPE
Alpha 1—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-SYS-OBJ-ID SET5
SYS_OBJ_ID
Numeric 12—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-DOC-ID SET2 SET4
DOC_ID
Alpha 55This is the document ID.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-DOC-ID-DTL SET2
DOC_ID_DTL
Alpha 15——
#GHX-PARENT-DOC-ID PK
PARENT_DOC_ID
Alpha 55—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-PAR-DOC-ID-DTL PK
PAR_DOC_ID_DTL
Alpha 15——
#GHX-API-OBJ-ID
API_OBJ_ID
Numeric 12—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-DIST-SEQ-NBR
DIST_SEQ_NBR
Numeric 6—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-FROM-COMPANY
FROM_COMPANY
Numeric 4—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-PO-NUMBER
PO_NUMBER
Alpha 14 (Right Justified)—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-PO-RELEASE
PO_RELEASE
Numeric 4—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-PO-CODE
PO_CODE
Alpha 4—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-LINE-NBR
LINE_NBR
Numeric 6—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-REQ-NUMBER
REQ_NUMBER
Numeric 7—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-FBY-OBJ-ID
FBY_OBJ_ID
Numeric 12—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-CREATED-YEAR
CREATED_YEAR
Numeric 4—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-CREATED-PERIOD
CREATED_PERIOD
Numeric 2—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-ACTIVITY SET6
ACTIVITY
Alpha 15—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-ACCT-CATEGORY SET6
ACCT_CATEGORY
Alpha 5—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-MAINT-DATE
MAINT_DATE
Numeric 8 (yyyymmdd)—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GHX-MAINT-TIME
MAINT_TIME
Numeric 8—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)

Indexes (7)

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
GHXSET1
  1. PARENT-DOC-ID
  2. PAR-DOC-ID-DTL
  3. UNIQUE-I-D
Primary, KeyChangeGL93.4
GHXSET2
  1. DOC-ID
  2. DOC-ID-DTL
  3. UNIQUE-I-D
GL93.4
GHXSET3
  1. COMPANY
  2. ACCT-UNIT
  3. ACCOUNT
  4. SUB-ACCOUNT
  5. YEAR
  6. PERIOD
  7. SYSTEM
  8. UNIQUE-I-D
KeyChangeFB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1, FB95.2 +22 more (list truncated in source)
GHXSET4
  1. COMPANY
  2. YEAR
  3. PERIOD
  4. SYSTEM
  5. DOC-ID
  6. UNIQUE-I-D
GL300, GL322, GL93.3
GHXSET5
  1. SYS-OBJ-TYPE
  2. SYS-OBJ-ID
  3. UNIQUE-I-D
AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +22 more (list truncated in source)
GHXSET6
  1. ACTIVITY
  2. ACCT-CATEGORY
  3. YEAR
  4. PERIOD
  5. SYSTEM
  6. UNIQUE-I-D
SubsetWhere ACTIVITY != SpacesGL299, GL93.2
GHXUID
  1. UNIQUE-I-D
GL120

Relations

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

One to one (10) — lookups and parents

RelationTableRulesConditionField map
AccountGLMASTERRequired
GHX-COMPANY→GLM-COMPANY
GHX-ACCT-UNIT→GLM-ACCT-UNIT
GHX-ACCOUNT→GLM-ACCOUNT
GHX-SUB-ACCOUNT→GLM-SUB-ACCOUNT
ApdistribAPDISTRIBRequired
GHX-API-OBJ-ID→APD-API-OBJ-ID
GHX-DIST-SEQ-NBR→APD-DIST-SEQ-NBR
GlamountsGLAMOUNTSRequired
GHX-COMPANY→GAM-COMPANY
GHX-YEAR→GAM-FISCAL-YEAR
GHX-ACCT-UNIT→GAM-ACCT-UNIT
GHX-ACCOUNT→GAM-ACCOUNT
GHX-SUB-ACCOUNT→GAM-SUB-ACCOUNT
GlcommitxGLCOMMITXRequired
GHX-SYS-OBJ-ID→GOX-GLT-OBJ-ID
GltransGLTRANSRequired
GHX-SYS-OBJ-ID→GLT-OBJ-ID
PaencumberPAENCUMBERRequired
GHX-SYS-OBJ-ID→PEN-GLT-OBJ-ID
PolinePOLINERequired
GHX-FROM-COMPANY→PLI-COMPANY
GHX-PO-NUMBER→PLI-PO-NUMBER
GHX-PO-RELEASE→PLI-PO-RELEASE
GHX-PO-CODE→PLI-PO-CODE
GHX-LINE-NBR→PLI-LINE-NBR
PovadistPOVADISTNot Required
GHX-SYS-OBJ-ID→PVD-GLT-OBJ-ID
ReqlineREQLINERequired
GHX-FROM-COMPANY→RLN-COMPANY
GHX-REQ-NUMBER→RLN-REQ-NUMBER
GHX-LINE-NBR→RLN-LINE-NBR
RjencumbRJENCUMBRequired
GHX-SYS-OBJ-ID→RJE-GLT-OBJ-ID

One to many (11) — child tables

RelationTableRulesConditionField map
ActransACTRANS
GHX-SYS-OBJ-ID→ATN-GLT-OBJ-ID
—→ATN-OBJ-ID
ApapdhistAPAPDHIST
GHX-SYS-OBJ-ID→AH2-GLT-OBJ-ID
—→AH2-API-OBJ-ID
—→AH2-DIST-SEQ-NBR
ApdrftdistAPDRFTDIST
GHX-COMPANY→DDT-DIST-COMPANY
GHX-ACCT-UNIT→DDT-DST-ACCT-UNIT
GHX-ACCOUNT→DDT-DST-ACCOUNT
GHX-SUB-ACCOUNT→DDT-DST-SUB-ACCT
—→DDT-POST-DATE
—→DDT-GLT-OBJ-ID
—→DDT-BANK-INST-CODE
—→DDT-TRANS-IDENT
—→DDT-SEQ-NBR
CbdistribCBDISTRIB
GHX-COMPANY→CBD-DIST-COMPANY
GHX-ACCT-UNIT→CBD-DIS-ACCT-UNIT
GHX-ACCOUNT→CBD-DIS-ACCOUNT
GHX-SUB-ACCOUNT→CBD-DIS-SUB-ACCT
GHX-SYS-OBJ-ID→CBD-GLT-OBJ-ID
—→CBD-CASH-CODE
—→CBD-TRANS-NBR
—→CBD-BANK-INST-CODE
—→CBD-DIST-TYPE
—→CBD-SEQ-NBR
—→CBD-TRANS-IDENT
EedistribEEDISTRIB
GHX-SYS-OBJ-ID→EED-GLT-OBJ-ID
—→EED-COMPANY
—→EED-VENDOR
—→EED-EXPENSE-NBR
—→EED-SEQ-NBR
FbdetailFBDETAIL
GHX-COMPANY→FBD-COMPANY
GHX-ACCT-UNIT→FBD-ACCT-UNIT
GHX-ACCOUNT→FBD-ACCOUNT
GHX-SUB-ACCOUNT→FBD-SUB-ACCOUNT
—→FBD-BUDGET-NBR
—→FBD-FISCAL-YEAR
PommdistMMDISTValid When GHX-SYSTEM = "PO"
GHX-SYS-OBJ-ID→MMD-GLT-OBJ-ID
—→MMD-COMPANY
—→MMD-SYSTEM-CD
—→MMD-LOCATION
—→MMD-DOC-TYPE
—→MMD-DOC-NUMBER
—→MMD-DOC-NBR-NUM
—→MMD-LINE-NBR
—→MMD-COMPONENT-SEQ
—→MMD-LINE-SEQ
PovacommitPOVACOMMITValid When GHX-SYSTEM = "PO"
GHX-SYS-OBJ-ID→PVC-GLT-OBJ-ID
—→PVC-PROCURE-GROUP
—→PVC-VEN-AGRMT-REF
—→PVC-LINE-NBR
—→PVC-SYSTEM
—→PVC-LINE-SEQ
—→PVC-COMMIT-DATE
PovagrmthdPOVAGRMTHDValid When GHX-SYSTEM = "PO"
GHX-SYS-OBJ-ID→PVH-GLT-OBJ-ID
—→PVH-PROCURE-GROUP
—→PVH-VEN-AGRMT-REF
PrdistribPRDISTRIB
GHX-COMPANY→PRD-DIST-COMPANY
GHX-SYS-OBJ-ID→PRD-GLT-OBJ-ID
GHX-ACCT-UNIT→PRD-DST-ACCT-UNIT
GHX-ACCOUNT→PRD-DST-ACCOUNT
GHX-SUB-ACCOUNT→PRD-DST-SUB-ACCT
—→PRD-OBJ-ID
RqmmdistMMDISTValid When GHX-SYSTEM = "RQ"
GHX-SYS-OBJ-ID→MMD-GLT-OBJ-ID
—→MMD-COMPANY
—→MMD-SYSTEM-CD
—→MMD-LOCATION
—→MMD-DOC-TYPE
—→MMD-DOC-NUMBER
—→MMD-DOC-NBR-NUM
—→MMD-LINE-NBR
—→MMD-COMPONENT-SEQ
—→MMD-LINE-SEQ

Programs

Updated by (322)

Referenced by (61)