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.

Field / columnTypeDescription & valuesUpdated by
GHX-UNIQUE-I-D PK
UNIQUE_I_D
Bad Type 36
GHX-COMPANY
COMPANY
Numeric 4AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-ACCT-UNIT
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
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
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
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
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
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 30AP125, 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.2AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-CURRENCY-CODE
CURRENCY_CODE
Alpha 5AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-BASERATE
BASERATE
Signed 14.7AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-TRAN-AMOUNT
TRAN_AMOUNT
Signed 18.2AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-TRAN-ND
TRAN_ND
Numeric 1AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-INVOICE
INVOICE
Alpha 22AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-ITEM
ITEM
Alpha 32AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-RESOURCE-COMP
RESOURCE_COMP
Numeric 4AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-RESOURCE-CODE
RESOURCE_CODE
Alpha 10AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-RESOURCE-TYPE
RESOURCE_TYPE
Alpha 1AP125, 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 2AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-PROGRAM
PROGRAM
Alpha 5AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-SYS-OBJ-TYPE
SYS_OBJ_TYPE
Alpha 1AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-SYS-OBJ-ID
SYS_OBJ_ID
Numeric 12AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-DOC-ID
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
DOC_ID_DTL
Alpha 15
GHX-PARENT-DOC-ID PK
PARENT_DOC_ID
Alpha 55AP125, 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 12AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-DIST-SEQ-NBR
DIST_SEQ_NBR
Numeric 6AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-FROM-COMPANY
FROM_COMPANY
Numeric 4AP125, 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 4AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-PO-CODE
PO_CODE
Alpha 4AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-LINE-NBR
LINE_NBR
Numeric 6AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-REQ-NUMBER
REQ_NUMBER
Numeric 7AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-FBY-OBJ-ID
FBY_OBJ_ID
Numeric 12AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-CREATED-YEAR
CREATED_YEAR
Numeric 4AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-CREATED-PERIOD
CREATED_PERIOD
Numeric 2AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-ACTIVITY
ACTIVITY
Alpha 15AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GHX-ACCT-CATEGORY
ACCT_CATEGORY
Alpha 5AP125, 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 8AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)

Indexes (7)

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

IndexKeysFlagsConditionUsed in
GHXSET1PARENT-DOC-ID, PAR-DOC-ID-DTL, UNIQUE-I-DPrimary, KeyChangeGL93.4
GHXSET2DOC-ID, DOC-ID-DTL, UNIQUE-I-DGL93.4
GHXSET3COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, YEAR, PERIOD, SYSTEM, UNIQUE-I-DKeyChangeFB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1, FB95.2 +22 more (list truncated in source)
GHXSET4COMPANY, YEAR, PERIOD, SYSTEM, DOC-ID, UNIQUE-I-DGL300, GL322, GL93.3
GHXSET5SYS-OBJ-TYPE, SYS-OBJ-ID, UNIQUE-I-DAP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +22 more (list truncated in source)
GHXSET6ACTIVITY, ACCT-CATEGORY, YEAR, PERIOD, SYSTEM, UNIQUE-I-DSubsetWhere ACTIVITY != SpacesGL299, GL93.2
GHXUIDUNIQUE-I-DGL120

Relations

One to one (10) — lookups and parents

RelationTableRulesConditionField map
AccountGLMASTERRequiredGHX-COMPANYGLM-COMPANY, GHX-ACCT-UNITGLM-ACCT-UNIT, GHX-ACCOUNTGLM-ACCOUNT, GHX-SUB-ACCOUNTGLM-SUB-ACCOUNT
ApdistribAPDISTRIBRequiredGHX-API-OBJ-IDAPD-API-OBJ-ID, GHX-DIST-SEQ-NBRAPD-DIST-SEQ-NBR
GlamountsGLAMOUNTSRequiredGHX-COMPANYGAM-COMPANY, GHX-YEARGAM-FISCAL-YEAR, GHX-ACCT-UNITGAM-ACCT-UNIT, GHX-ACCOUNTGAM-ACCOUNT, GHX-SUB-ACCOUNTGAM-SUB-ACCOUNT
GlcommitxGLCOMMITXRequiredGHX-SYS-OBJ-IDGOX-GLT-OBJ-ID
GltransGLTRANSRequiredGHX-SYS-OBJ-IDGLT-OBJ-ID
PaencumberPAENCUMBERRequiredGHX-SYS-OBJ-IDPEN-GLT-OBJ-ID
PolinePOLINERequiredGHX-FROM-COMPANYPLI-COMPANY, GHX-PO-NUMBERPLI-PO-NUMBER, GHX-PO-RELEASEPLI-PO-RELEASE, GHX-PO-CODEPLI-PO-CODE, GHX-LINE-NBRPLI-LINE-NBR
PovadistPOVADISTNot RequiredGHX-SYS-OBJ-IDPVD-GLT-OBJ-ID
ReqlineREQLINERequiredGHX-FROM-COMPANYRLN-COMPANY, GHX-REQ-NUMBERRLN-REQ-NUMBER, GHX-LINE-NBRRLN-LINE-NBR
RjencumbRJENCUMBRequiredGHX-SYS-OBJ-IDRJE-GLT-OBJ-ID

One to many (11) — child tables

RelationTableRulesConditionField map
ActransACTRANSGHX-SYS-OBJ-IDATN-GLT-OBJ-ID, ATN-OBJ-ID
ApapdhistAPAPDHISTGHX-SYS-OBJ-IDAH2-GLT-OBJ-ID, AH2-API-OBJ-ID, AH2-DIST-SEQ-NBR
ApdrftdistAPDRFTDISTGHX-COMPANYDDT-DIST-COMPANY, GHX-ACCT-UNITDDT-DST-ACCT-UNIT, GHX-ACCOUNTDDT-DST-ACCOUNT, GHX-SUB-ACCOUNTDDT-DST-SUB-ACCT, DDT-POST-DATE, DDT-GLT-OBJ-ID, DDT-BANK-INST-CODE, DDT-TRANS-IDENT, DDT-SEQ-NBR
CbdistribCBDISTRIBGHX-COMPANYCBD-DIST-COMPANY, GHX-ACCT-UNITCBD-DIS-ACCT-UNIT, GHX-ACCOUNTCBD-DIS-ACCOUNT, GHX-SUB-ACCOUNTCBD-DIS-SUB-ACCT, GHX-SYS-OBJ-IDCBD-GLT-OBJ-ID, CBD-CASH-CODE, CBD-TRANS-NBR, CBD-BANK-INST-CODE, CBD-DIST-TYPE, CBD-SEQ-NBR, CBD-TRANS-IDENT
EedistribEEDISTRIBGHX-SYS-OBJ-IDEED-GLT-OBJ-ID, EED-COMPANY, EED-VENDOR, EED-EXPENSE-NBR, EED-SEQ-NBR
FbdetailFBDETAILGHX-COMPANYFBD-COMPANY, GHX-ACCT-UNITFBD-ACCT-UNIT, GHX-ACCOUNTFBD-ACCOUNT, GHX-SUB-ACCOUNTFBD-SUB-ACCOUNT, FBD-BUDGET-NBR, FBD-FISCAL-YEAR
PommdistMMDISTValid When GHX-SYSTEM = "PO"GHX-SYS-OBJ-IDMMD-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-IDPVC-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-IDPVH-GLT-OBJ-ID, PVH-PROCURE-GROUP, PVH-VEN-AGRMT-REF
PrdistribPRDISTRIBGHX-COMPANYPRD-DIST-COMPANY, GHX-SYS-OBJ-IDPRD-GLT-OBJ-ID, GHX-ACCT-UNITPRD-DST-ACCT-UNIT, GHX-ACCOUNTPRD-DST-ACCOUNT, GHX-SUB-ACCOUNTPRD-DST-SUB-ACCT, PRD-OBJ-ID
RqmmdistMMDISTValid When GHX-SYSTEM = "RQ"GHX-SYS-OBJ-IDMMD-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)