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.

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
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
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
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
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 12AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GOX-ACTIVITY
ACTIVITY
Alpha 15AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GOX-ACCT-CATEGORY
ACCT_CATEGORY
Alpha 5AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)

Indexes (3)

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

IndexKeysFlagsConditionUsed in
GOXSET1COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, FISCAL-YEAR, PERIOD, SYSTEM, CURRENCY-CODE, GLT-OBJ-IDPrimaryFB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1, FB95.2 +22 more (list truncated in source)
GOXSET2GLT-OBJ-IDAP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +22 more (list truncated in source)
GOXSET3RESOURCE-COMP, RESOURCE-TYPE, RESOURCE-CODE, SYSTEM, TRANS-DATE, GLT-OBJ-IDPR198

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AccountGLMASTERRequiredGOX-COMPANYGLM-COMPANY, GOX-ACCT-UNITGLM-ACCT-UNIT, GOX-ACCOUNTGLM-ACCOUNT, GOX-SUB-ACCOUNTGLM-SUB-ACCOUNT
GlamountsGLAMOUNTSRequiredGOX-COMPANYGAM-COMPANY, GOX-FISCAL-YEARGAM-FISCAL-YEAR, GOX-ACCT-UNITGAM-ACCT-UNIT, GOX-ACCOUNTGAM-ACCOUNT, GOX-SUB-ACCOUNTGAM-SUB-ACCOUNT
GlcommitGLCOMMITRequiredGOX-COMPANYGOT-COMPANY, GOX-ACCT-UNITGOT-ACCT-UNIT, GOX-ACCOUNTGOT-ACCOUNT, GOX-SUB-ACCOUNTGOT-SUB-ACCOUNT, GOX-FISCAL-YEARGOT-FISCAL-YEAR, GOX-SYSTEMGOT-SYSTEM
PaencumberPAENCUMBERRequiredGOX-GLT-OBJ-IDPEN-GLT-OBJ-ID
PovadistPOVADISTNot RequiredGOX-GLT-OBJ-IDPVD-GLT-OBJ-ID
RjencumbRJENCUMBRequiredGOX-GLT-OBJ-IDRJE-GLT-OBJ-ID

One to many (13) — child tables

RelationTableRulesConditionField map
ActransACTRANSGOX-GLT-OBJ-IDATN-GLT-OBJ-ID, ATN-OBJ-ID
ApapdhistAPAPDHISTGOX-GLT-OBJ-IDAH2-GLT-OBJ-ID, AH2-API-OBJ-ID, AH2-DIST-SEQ-NBR
ApdistribAPDISTRIBGOX-GLT-OBJ-IDAPD-GLT-OBJ-ID, APD-API-OBJ-ID, APD-DIST-SEQ-NBR
ApdrftdistAPDRFTDISTGOX-COMPANYDDT-DIST-COMPANY, GOX-ACCT-UNITDDT-DST-ACCT-UNIT, GOX-ACCOUNTDDT-DST-ACCOUNT, GOX-SUB-ACCOUNTDDT-DST-SUB-ACCT, DDT-POST-DATE, DDT-GLT-OBJ-ID, DDT-BANK-INST-CODE, DDT-TRANS-IDENT, DDT-SEQ-NBR
CbdistribCBDISTRIBGOX-COMPANYCBD-DIST-COMPANY, GOX-ACCT-UNITCBD-DIS-ACCT-UNIT, GOX-ACCOUNTCBD-DIS-ACCOUNT, GOX-SUB-ACCOUNTCBD-DIS-SUB-ACCT, GOX-GLT-OBJ-IDCBD-GLT-OBJ-ID, CBD-CASH-CODE, CBD-TRANS-NBR, CBD-BANK-INST-CODE, CBD-DIST-TYPE, CBD-SEQ-NBR, CBD-TRANS-IDENT
EedistribEEDISTRIBGOX-GLT-OBJ-IDEED-GLT-OBJ-ID, EED-COMPANY, EED-VENDOR, EED-EXPENSE-NBR, EED-SEQ-NBR
FbdetailFBDETAILGOX-COMPANYFBD-COMPANY, GOX-ACCT-UNITFBD-ACCT-UNIT, GOX-ACCOUNTFBD-ACCOUNT, GOX-SUB-ACCOUNTFBD-SUB-ACCOUNT, FBD-BUDGET-NBR, FBD-FISCAL-YEAR
GltransGLTRANSGOX-COMPANYGLT-COMPANY, GOX-FISCAL-YEARGLT-FISCAL-YEAR, GOX-PERIODGLT-ACCT-PERIOD, GLT-CONTROL-GROUP, GLT-SYSTEM, GLT-JE-TYPE, GLT-JE-SEQUENCE, GLT-LINE-NBR
PommdistMMDISTValid When GOX-SYSTEM = "PO"GOX-GLT-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 GOX-SYSTEM = "PO"GOX-GLT-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 GOX-SYSTEM = "PO"GOX-GLT-OBJ-IDPVH-GLT-OBJ-ID, PVH-PROCURE-GROUP, PVH-VEN-AGRMT-REF
PrdistribPRDISTRIBGOX-COMPANYPRD-DIST-COMPANY, GOX-GLT-OBJ-IDPRD-GLT-OBJ-ID, GOX-ACCT-UNITPRD-DST-ACCT-UNIT, GOX-ACCOUNTPRD-DST-ACCOUNT, GOX-SUB-ACCOUNTPRD-DST-SUB-ACCT, PRD-OBJ-ID
RqmmdistMMDISTValid When GOX-SYSTEM = "RQ"GOX-GLT-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 (323)

Referenced by (58)