ACCOMMITX – Activity Commitments Detail

System
Activity Management (AC)
Prefix
MIX
Primary key
ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, FISCAL-YEAR, PERIOD, SYSTEM, COMPANY, CURRENCY-CODE, ATN-OBJ-ID
Fields
31
Updated by
336 programs
Referenced by
9 programs

ACCOMMITX is the Activity Commitments Detail table in Lawson Activity Management (prefix MIX). It is indexed by ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, FISCAL-YEAR, PERIOD, SYSTEM, COMPANY, CURRENCY-CODE, ATN-OBJ-ID (MIXSET1); alternate indexes: MIXSET2, MIXSET3, MIXSET4, MIXSET5 and MIXSET6. It is related 1:1 to ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACCOMMIT, APCOMPANY, COLINE, COMISC and 9 more and 1:M to AMTRANS, APAPDHIST, APDISTRIB, CBDISTRIB, EEDISTRIB, MMDIST, POVACOMMIT, POVAGRMTHD and 1 more. It is updated by AC108, AC120, AC145, AC190, AC191, AC196, AC246, AC300 and 328 more and referenced by AC147, AC298, AC98.1, AC98.2, ACDL.1, AP175, POIG.1, POIK.1 and 1 more. The table has 31 fields, 6 indexes and 33 documented relations.

About ACCOMMITX

This file, the Activity Commitments file, and the Activity Transaction file contain commitment information. Commitments are activity transactions released in any originating subsystem but not yet posted to the Activity Management system. This file and the Activity Commitments file contain commitments not yet posted to the general ledger. The Activity Transaction file contains commitments posted to the general ledger but not yet posted to Activity Management. Commitment information is available in the Commitments field of each Activity Group Analysis and Activity Analysis form. This file keeps commitment detail. In addition to the key fields of activity group, activity, account category, fiscal year, period, system, company, currency code, and transaction object ID, this file includes accounting unit, account, subaccount, transaction amount, and transaction units.

Fields (31)

Column = COBOL field name without the MIX- 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
#MIX-ACTIVITY-GRP PK
ACTIVITY_GRP		Alpha 15Key field. This is the activity group for the commitment information.AC120, AC346, AC46.1, AP125, AP126, AP131, AP170, AP190 +52 more (list truncated in source)
#MIX-ACTIVITY PK
ACTIVITY		Alpha 15Key field. This is the activity for the commitment information.AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5Key field. This is the account category for the commitment information.AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4Contains the fiscal year for the data stored on this record.AC108, AC120, AC145, AC190, AC191, AC196, AC298, AC311 +52 more (list truncated in source)
#MIX-PERIOD PK
PERIOD		Numeric 2Key field. This is the period for the commitment information.AC108, AC120, AC145, AC190, AC191, AC196, AC298, AC311 +52 more (list truncated in source)
#MIX-SYSTEM PK
SYSTEM		Alpha 2A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.)AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-COMPANY PK
COMPANY		Numeric 4Key field. This is the company for the commitment information.AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-CURRENCY-CODE PK
CURRENCY_CODE		Alpha 5Key field. This field defines the currency code for the commitment.AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-ATN-OBJ-ID PK
ATN_OBJ_ID		Numeric 12Key field. This is the object identifier for the committed transaction.AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-ACCT-UNIT
ACCT_UNIT		Alpha 15This is the accounting unit for the commitment.AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-ACCOUNT
ACCOUNT		Numeric 6This is the account for the commitment.AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-SUB-ACCOUNT
SUB_ACCOUNT		Numeric 4This is the subaccount for the commitment.AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-TRAN-AMOUNT
TRAN_AMOUNT		Signed 18.2This is the amount in transaction currency for the commitment.AC346, AC45.1, AC46.1, AP125, AP126, AP131, AP170, AP190 +52 more (list truncated in source)
#MIX-UNIT
UNIT		Signed 15.2This field indicates the number of units for the commitment.AC346, AC45.1, AC46.1, AP125, AP126, AP131, AP170, AP190 +52 more (list truncated in source)
#MIX-BURDEN-AMT
BURDEN_AMT		Signed 18.2—AC346, AC45.1, AC46.1, AP125, AP126, AP131, AP170, AP190 +52 more (list truncated in source)
#MIX-PR-FRINGE-AMT
PR_FRINGE_AMT		DerivedThis field contains an optional, additional cost amount for this commitment. It is the Tran Amount multiplied by the commitment percent that can be defined on System Codes (GL01.4). The system code on the commitment determines which commit percent is used. This can be for any system that creates commitments, not just PR.—
#MIX-PR-COMMIT-AMT
PR_COMMIT_AMT		DerivedThis field contains the sum of the Tran Amount and the PR Fringe Amt fields.—
#MIX-ACCT-CAT-TYPE
ACCT_CAT_TYPE		Derived——
#MIX-INVOICE SET4
INVOICE		Alpha 22Used to identify the invoice.AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-ITEM
ITEM		Alpha 32This field contains the item identifier.AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-RESOURCE-CODE SET3 SET4
RESOURCE_CODE		Alpha 10The code identifying the resource assigned to the activity or activity group.AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-RESOURCE-TYPE SET3 SET4
RESOURCE_TYPE		Alpha 1The type of resource. Valid values include: P - AC Person Q - Equipment E - Employee V - Vendor A - Asset
  • E Employee
  • V Vendor
  • P Person
  • Q Equipment
  • A Asset
AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-RESOURCE-DESC
RESOURCE_DESC		Alpha 30 (Lower Case)This field displays the description.AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-GLT-OBJ-ID SET6
GLT_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-RESOURCE-COMP SET3 SET4
RESOURCE_COMP		Numeric 4Required if resource is present in commitment transaction; capture HR company if resource is employee, AP company if resource is vendor and AM company if resource is asset.AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-TRANS-DATE SET3 SET4
TRANS_DATE		Numeric 8 (yyyymmdd)The date of the transaction. For payroll commitments created during salary encumbrance, this is the pay period end date or the activity period end date on split transactions (when pay period spans an activity period end date).AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-END-DATE
END_DATE		Numeric 8 (yyyymmdd)Manual commitment end (or expiration) date.AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-USER-ID
USER_ID		Alpha 10 (Lower Case)—AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-SOURCE-CODE
SOURCE_CODE		Alpha 2Identifies commitment transactions created from salary encumbrance processing (GM110) as labor (LD) or fringe (FR).AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-GMA-OBJ-ID
GMA_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)
#MIX-GM-SALARY-PCT
GM_SALARY_PCT		Signed 13.6—AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)

Indexes (6)

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
MIXSET1
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. ACCT-CATEGORY
  4. FISCAL-YEAR
  5. PERIOD
  6. SYSTEM
  7. COMPANY
  8. CURRENCY-CODE
  9. ATN-OBJ-ID
Primary, KeyChangeAC108, AC120, AC145, AC147, AC190, AC191, AC196, AC298 +22 more (list truncated in source)
MIXSET2
  1. ATN-OBJ-ID
AC108, AC120, AC145, AC190, AC191, AC196, AC246, AC311 +22 more (list truncated in source)
MIXSET3
  1. RESOURCE-COMP
  2. RESOURCE-TYPE
  3. RESOURCE-CODE
  4. SYSTEM
  5. TRANS-DATE
  6. ACTIVITY-GRP
  7. ACTIVITY
  8. ACCT-CATEGORY
  9. ATN-OBJ-ID
KeyChangePR198
MIXSET4
  1. ACTIVITY
  2. RESOURCE-TYPE
  3. RESOURCE-COMP
  4. RESOURCE-CODE
  5. SYSTEM
  6. INVOICE
  7. TRANS-DATE
  8. ACTIVITY-GRP
  9. ACCT-CATEGORY
  10. ATN-OBJ-ID
KeyChange—
MIXSET5
  1. ACTIVITY
  2. ACTIVITY-GRP
  3. ACCT-CATEGORY
  4. FISCAL-YEAR
  5. PERIOD
  6. SYSTEM
  7. COMPANY
  8. CURRENCY-CODE
  9. ATN-OBJ-ID
KeyChangeAC246, AC346, AC46.1, AC98.1, AC98.2
MIXSET6
  1. GLT-OBJ-ID
  2. ATN-OBJ-ID
KeyChangeGL199

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACCTCATACACCTCATXACACTGRPACACTIVITYACCOMMITAPCOMPANYCOLINECOMISCGLTRANSGMLABDISTXICCOMPANYITEMMASTOEINVCLINEOEINVCMISC+3 more belowAMTRANSAPAPDHISTAPDISTRIBCBDISTRIBEEDISTRIBMMDISTPOVACOMMITPOVAGRMTHDTIMERECORDACCOMMITX

One to one (21) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequired
MIX-ACCT-CATEGORY→AAX-ACCT-CATEGORY
AcacctcatxACACCTCATXNot Required
MIX-ACTIVITY-GRP→AXX-ACTIVITY-GRP
MIX-ACTIVITY→AXX-ACTIVITY
MIX-ACCT-CATEGORY→AXX-ACCT-CATEGORY
AcactgrpACACTGRPRequired
MIX-ACTIVITY-GRP→AGP-ACTIVITY-GRP
AcactivityACACTIVITYRequired
MIX-ACTIVITY→ACV-ACTIVITY
AccommitACCOMMITRequired
MIX-ACTIVITY-GRP→MIT-ACTIVITY-GRP
MIX-ACTIVITY→MIT-ACTIVITY
MIX-ACCT-CATEGORY→MIT-ACCT-CATEGORY
MIX-FISCAL-YEAR→MIT-FISCAL-YEAR
MIX-PERIOD→MIT-PERIOD
MIX-SYSTEM→MIT-SYSTEM
MIX-COMPANY→MIT-COMPANY
MIX-CURRENCY-CODE→MIT-CURRENCY-CODE
ApcompanyAPCOMPANYNot Required
MIX-COMPANY→CPY-COMPANY
ColineCOLINENot Required
MIX-ATN-OBJ-ID→COL-ATN-OBJ-ID
Coline CostCOLINENot Required
MIX-ATN-OBJ-ID→COL-ATN-OBJ-ID-C
ComiscCOMISCNot Required
MIX-ATN-OBJ-ID→CMC-ATN-OBJ-ID
Comisc CostCOMISCNot Required
MIX-ATN-OBJ-ID→CMC-ATN-OBJ-ID-C
GltransGLTRANSRequired
MIX-GLT-OBJ-ID→GLT-OBJ-ID
GmlabdistxGMLABDISTXNot Required
MIX-GMA-OBJ-ID→GMA-OBJ-ID
IccompanyICCOMPANYNot Required
MIX-COMPANY→ICC-COMPANY
ItemmastITEMMASTNot Required
ICC-ITEM-GROUP→ITE-ITEM-GROUP
MIX-ITEM→ITE-ITEM
OeinvclineOEINVCLINENot Required
MIX-ATN-OBJ-ID→OIL-ATN-OBJ-ID
Oeinvcline CstOEINVCLINENot Required
MIX-ATN-OBJ-ID→OIL-ATN-OBJ-ID-C
OeinvcmiscOEINVCMISCNot Required
MIX-ATN-OBJ-ID→OIM-ATN-OBJ-ID
Oeinvcmisc CstOEINVCMISCNot Required
MIX-ATN-OBJ-ID→OIM-ATN-OBJ-ID-C
PaencumberPAENCUMBERRequired
MIX-ATN-OBJ-ID→PEN-ATN-OBJ-ID
PovadistPOVADISTNot RequiredValid When MIX-SYSTEM = "PO"
MIX-ATN-OBJ-ID→PVD-ATN-OBJ-ID
SystemcodeSYSTEMCODERequired
MIX-SYSTEM→SYS-SYSTEM

One to many (12) — child tables

RelationTableRulesConditionField map
AmtransAMTRANS
MIX-ATN-OBJ-ID→AMT-ATN-OBJ-ID
—→AMT-ASSET
—→AMT-SEQ-NUMBER
—→AMT-COMPANY
ApapdhistAPAPDHIST
MIX-ATN-OBJ-ID→AH2-ATN-OBJ-ID
—→AH2-COMPANY
—→AH2-VENDOR
—→AH2-INVOICE
—→AH2-SUFFIX
—→AH2-CANCEL-SEQ
—→AH2-DIST-SEQ-NBR
ApdistribAPDISTRIB
MIX-ATN-OBJ-ID→APD-ATN-OBJ-ID
—→APD-COMPANY
—→APD-VENDOR
—→APD-INVOICE
—→APD-SUFFIX
—→APD-CANCEL-SEQ
—→APD-DIST-SEQ-NBR
CbdistribCBDISTRIB
MIX-ATN-OBJ-ID→CBD-ACT-OBJ-ID
—→CBD-CASH-CODE
—→CBD-BANK-INST-CODE
—→CBD-TRANS-IDENT
—→CBD-DIST-TYPE
—→CBD-SEQ-NBR
EedistribEEDISTRIB
MIX-ATN-OBJ-ID→EED-ACT-OBJ-ID
—→EED-COMPANY
—→EED-VENDOR
—→EED-EXPENSE-NBR
—→EED-SEQ-NBR
IcmmdistMMDISTValid When MIX-SYSTEM = "IC"
MIX-ATN-OBJ-ID→MMD-ATN-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
MmdistMMDIST
MIX-ATN-OBJ-ID→MMD-ATN-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
PommdistMMDISTValid When MIX-SYSTEM = "PO"
MIX-ATN-OBJ-ID→MMD-ATN-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 MIX-SYSTEM = "PO"
MIX-ATN-OBJ-ID→PVC-ATN-OBJ-ID
—→PVC-PROCURE-GROUP
—→PVC-VEN-AGRMT-REF
—→PVC-LINE-NBR
—→PVC-SYSTEM
—→PVC-LINE-SEQ
—→PVC-COMMIT-DATE
PovagrmthdPOVAGRMTHDValid When MIX-SYSTEM = "PO"
MIX-ATN-OBJ-ID→PVH-ATN-OBJ-ID
—→PVH-PROCURE-GROUP
—→PVH-VEN-AGRMT-REF
RqmmdistMMDISTValid When MIX-SYSTEM = "RQ"
MIX-ATN-OBJ-ID→MMD-ATN-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
TimerecordTIMERECORD
MIX-COMPANY→TRD-COMPANY
MIX-ATN-OBJ-ID→TRD-ATN-OBJ-ID
—→TRD-TIME-SEQ

Programs

Updated by (336)

Referenced by (9)