GLCOMMITX – GL commitment Detail

System
General Ledger (GL)
Prefix
GOX
Primary key
COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, FISCAL-YEAR, PERIOD, SYSTEM, CURRENCY-CODE, GLT-OBJ-ID
Fields
28
Updated by
323 programs
Referenced by
58 programs

GLCOMMITX is the GL commitment Detail table in Lawson General Ledger (prefix GOX). It is indexed by COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, FISCAL-YEAR, PERIOD, SYSTEM, CURRENCY-CODE, GLT-OBJ-ID (GOXSET1); alternate indexes: GOXSET2 and GOXSET3. It is related 1:1 to GLMASTER, GLAMOUNTS, GLCOMMIT, PAENCUMBER, POVADIST and RJENCUMB and 1:M to ACTRANS, APAPDHIST, APDISTRIB, APDRFTDIST, CBDISTRIB, EEDISTRIB, FBDETAIL, GLTRANS and 4 more. It is updated by AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 and 315 more and referenced by FB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1, FB95.2 and 50 more. The table has 28 fields, 3 indexes and 19 documented relations.

About GLCOMMITX

The General Ledger Commitx file contains the detail encumbrance and commitment records created by sub systems.

Fields (28)

Column = COBOL field name without the GOX- 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
#GOX-COMPANY PK
COMPANY
Numeric 4The company number represents an established company and is maintained on GL10.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-ACCT-UNIT PK
ACCT_UNIT
Alpha 15The accounting unit is a shorthand 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)
#GOX-ACCOUNT PK
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)
#GOX-SUB-ACCOUNT PK
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)
#GOX-FISCAL-YEAR PK
FISCAL_YEAR
Numeric 4This is the fiscal year for the record.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-PERIOD PK
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)
#GOX-SYSTEM PK
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)
#GOX-GLT-OBJ-ID PK
GLT_OBJ_ID
Numeric 12This is the object ID sequence number.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-VAR-LEVELS
VAR_LEVELS
Alpha 30A level that represents the location of an accounting unit in an organization's level structure.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-AMOUNT
AMOUNT
Signed 18.2The base amount for the record.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-UNIT
UNIT
Signed 15.2The units for the record.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-CURRENCY-CODE PK
CURRENCY_CODE
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-BASERATE
BASERATE
Signed 14.7The exchange rate at the time the record was created.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-TRAN-AMOUNT
TRAN_AMOUNT
Signed 18.2This is the amount in transaction currency.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-TRAN-ND
TRAN_ND
Numeric 1The number of decimals assigned to a particular account as determined by the account currency.GL197, GL500
#GOX-INVOICE
INVOICE
Alpha 22Used to identify the invoice number.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-ITEM
ITEM
Alpha 32This field contains the item identifier.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-RESOURCE-COMP SET3
RESOURCE_COMP
Numeric 4Required if resource type is employee; capture HR company.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-RESOURCE-CODE SET3
RESOURCE_CODE
Alpha 10This field contains the subsystem resource number.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-RESOURCE-TYPE SET3
RESOURCE_TYPE
Alpha 1This field contains the resource type.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-RESOURCE-DESC
RESOURCE_DESC
Alpha 30 (Lower Case)This field contains the resource description. (Required if resource is entered).AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-CREATED-YEAR
CREATED_YEAR
Numeric 4This is the fiscal year the record was created in.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-CREATED-PERIOD
CREATED_PERIOD
Numeric 2This is the period that the record was created in.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-TRANS-DATE SET3
TRANS_DATE
Numeric 8 (yyyymmdd)Commitment transaction date. For payroll commitments created during salary encumbrance, this is the pay period end date.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-SOURCE-CODE
SOURCE_CODE
Alpha 2A two character code assigned to a transaction to identify where the transaction was created.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-FBY-OBJ-ID
FBY_OBJ_ID
Numeric 12—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-ACTIVITY
ACTIVITY
Alpha 15—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
#GOX-ACCT-CATEGORY
ACCT_CATEGORY
Alpha 5—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)

Indexes (3)

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
GOXSET1
  1. COMPANY
  2. ACCT-UNIT
  3. ACCOUNT
  4. SUB-ACCOUNT
  5. FISCAL-YEAR
  6. PERIOD
  7. SYSTEM
  8. CURRENCY-CODE
  9. GLT-OBJ-ID
PrimaryFB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1, FB95.2 +22 more (list truncated in source)
GOXSET2
  1. GLT-OBJ-ID
AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +22 more (list truncated in source)
GOXSET3
  1. RESOURCE-COMP
  2. RESOURCE-TYPE
  3. RESOURCE-CODE
  4. SYSTEM
  5. TRANS-DATE
  6. GLT-OBJ-ID
PR198

Relations

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

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AccountGLMASTERRequired
GOX-COMPANY→GLM-COMPANY
GOX-ACCT-UNIT→GLM-ACCT-UNIT
GOX-ACCOUNT→GLM-ACCOUNT
GOX-SUB-ACCOUNT→GLM-SUB-ACCOUNT
GlamountsGLAMOUNTSRequired
GOX-COMPANY→GAM-COMPANY
GOX-FISCAL-YEAR→GAM-FISCAL-YEAR
GOX-ACCT-UNIT→GAM-ACCT-UNIT
GOX-ACCOUNT→GAM-ACCOUNT
GOX-SUB-ACCOUNT→GAM-SUB-ACCOUNT
GlcommitGLCOMMITRequired
GOX-COMPANY→GOT-COMPANY
GOX-ACCT-UNIT→GOT-ACCT-UNIT
GOX-ACCOUNT→GOT-ACCOUNT
GOX-SUB-ACCOUNT→GOT-SUB-ACCOUNT
GOX-FISCAL-YEAR→GOT-FISCAL-YEAR
GOX-SYSTEM→GOT-SYSTEM
PaencumberPAENCUMBERRequired
GOX-GLT-OBJ-ID→PEN-GLT-OBJ-ID
PovadistPOVADISTNot Required
GOX-GLT-OBJ-ID→PVD-GLT-OBJ-ID
RjencumbRJENCUMBRequired
GOX-GLT-OBJ-ID→RJE-GLT-OBJ-ID

One to many (13) — child tables

RelationTableRulesConditionField map
ActransACTRANS
GOX-GLT-OBJ-ID→ATN-GLT-OBJ-ID
—→ATN-OBJ-ID
ApapdhistAPAPDHIST
GOX-GLT-OBJ-ID→AH2-GLT-OBJ-ID
—→AH2-API-OBJ-ID
—→AH2-DIST-SEQ-NBR
ApdistribAPDISTRIB
GOX-GLT-OBJ-ID→APD-GLT-OBJ-ID
—→APD-API-OBJ-ID
—→APD-DIST-SEQ-NBR
ApdrftdistAPDRFTDIST
GOX-COMPANY→DDT-DIST-COMPANY
GOX-ACCT-UNIT→DDT-DST-ACCT-UNIT
GOX-ACCOUNT→DDT-DST-ACCOUNT
GOX-SUB-ACCOUNT→DDT-DST-SUB-ACCT
—→DDT-POST-DATE
—→DDT-GLT-OBJ-ID
—→DDT-BANK-INST-CODE
—→DDT-TRANS-IDENT
—→DDT-SEQ-NBR
CbdistribCBDISTRIB
GOX-COMPANY→CBD-DIST-COMPANY
GOX-ACCT-UNIT→CBD-DIS-ACCT-UNIT
GOX-ACCOUNT→CBD-DIS-ACCOUNT
GOX-SUB-ACCOUNT→CBD-DIS-SUB-ACCT
GOX-GLT-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
GOX-GLT-OBJ-ID→EED-GLT-OBJ-ID
—→EED-COMPANY
—→EED-VENDOR
—→EED-EXPENSE-NBR
—→EED-SEQ-NBR
FbdetailFBDETAIL
GOX-COMPANY→FBD-COMPANY
GOX-ACCT-UNIT→FBD-ACCT-UNIT
GOX-ACCOUNT→FBD-ACCOUNT
GOX-SUB-ACCOUNT→FBD-SUB-ACCOUNT
—→FBD-BUDGET-NBR
—→FBD-FISCAL-YEAR
GltransGLTRANS
GOX-COMPANY→GLT-COMPANY
GOX-FISCAL-YEAR→GLT-FISCAL-YEAR
GOX-PERIOD→GLT-ACCT-PERIOD
—→GLT-CONTROL-GROUP
—→GLT-SYSTEM
—→GLT-JE-TYPE
—→GLT-JE-SEQUENCE
—→GLT-LINE-NBR
PommdistMMDISTValid When GOX-SYSTEM = "PO"
GOX-GLT-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 GOX-SYSTEM = "PO"
GOX-GLT-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 GOX-SYSTEM = "PO"
GOX-GLT-OBJ-ID→PVH-GLT-OBJ-ID
—→PVH-PROCURE-GROUP
—→PVH-VEN-AGRMT-REF
PrdistribPRDISTRIB
GOX-COMPANY→PRD-DIST-COMPANY
GOX-GLT-OBJ-ID→PRD-GLT-OBJ-ID
GOX-ACCT-UNIT→PRD-DST-ACCT-UNIT
GOX-ACCOUNT→PRD-DST-ACCOUNT
GOX-SUB-ACCOUNT→PRD-DST-SUB-ACCT
—→PRD-OBJ-ID
RqmmdistMMDISTValid When GOX-SYSTEM = "RQ"
GOX-GLT-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 (323)

Referenced by (58)