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.

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.2AC346, 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
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
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
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
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
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
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.6AC346, AC46.1, AP125, AP126, AP131, AP170, AP190, AP193 +52 more (list truncated in source)

Indexes (6)

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

IndexKeysFlagsConditionUsed in
MIXSET1ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, FISCAL-YEAR, PERIOD, SYSTEM, COMPANY, CURRENCY-CODE, ATN-OBJ-IDPrimary, KeyChangeAC108, AC120, AC145, AC147, AC190, AC191, AC196, AC298 +22 more (list truncated in source)
MIXSET2ATN-OBJ-IDAC108, AC120, AC145, AC190, AC191, AC196, AC246, AC311 +22 more (list truncated in source)
MIXSET3RESOURCE-COMP, RESOURCE-TYPE, RESOURCE-CODE, SYSTEM, TRANS-DATE, ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, ATN-OBJ-IDKeyChangePR198
MIXSET4ACTIVITY, RESOURCE-TYPE, RESOURCE-COMP, RESOURCE-CODE, SYSTEM, INVOICE, TRANS-DATE, ACTIVITY-GRP, ACCT-CATEGORY, ATN-OBJ-IDKeyChange
MIXSET5ACTIVITY, ACTIVITY-GRP, ACCT-CATEGORY, FISCAL-YEAR, PERIOD, SYSTEM, COMPANY, CURRENCY-CODE, ATN-OBJ-IDKeyChangeAC246, AC346, AC46.1, AC98.1, AC98.2
MIXSET6GLT-OBJ-ID, ATN-OBJ-IDKeyChangeGL199

Relations

One to one (21) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequiredMIX-ACCT-CATEGORYAAX-ACCT-CATEGORY
AcacctcatxACACCTCATXNot RequiredMIX-ACTIVITY-GRPAXX-ACTIVITY-GRP, MIX-ACTIVITYAXX-ACTIVITY, MIX-ACCT-CATEGORYAXX-ACCT-CATEGORY
AcactgrpACACTGRPRequiredMIX-ACTIVITY-GRPAGP-ACTIVITY-GRP
AcactivityACACTIVITYRequiredMIX-ACTIVITYACV-ACTIVITY
AccommitACCOMMITRequiredMIX-ACTIVITY-GRPMIT-ACTIVITY-GRP, MIX-ACTIVITYMIT-ACTIVITY, MIX-ACCT-CATEGORYMIT-ACCT-CATEGORY, MIX-FISCAL-YEARMIT-FISCAL-YEAR, MIX-PERIODMIT-PERIOD, MIX-SYSTEMMIT-SYSTEM, MIX-COMPANYMIT-COMPANY, MIX-CURRENCY-CODEMIT-CURRENCY-CODE
ApcompanyAPCOMPANYNot RequiredMIX-COMPANYCPY-COMPANY
ColineCOLINENot RequiredMIX-ATN-OBJ-IDCOL-ATN-OBJ-ID
Coline CostCOLINENot RequiredMIX-ATN-OBJ-IDCOL-ATN-OBJ-ID-C
ComiscCOMISCNot RequiredMIX-ATN-OBJ-IDCMC-ATN-OBJ-ID
Comisc CostCOMISCNot RequiredMIX-ATN-OBJ-IDCMC-ATN-OBJ-ID-C
GltransGLTRANSRequiredMIX-GLT-OBJ-IDGLT-OBJ-ID
GmlabdistxGMLABDISTXNot RequiredMIX-GMA-OBJ-IDGMA-OBJ-ID
IccompanyICCOMPANYNot RequiredMIX-COMPANYICC-COMPANY
ItemmastITEMMASTNot RequiredICC-ITEM-GROUPITE-ITEM-GROUP, MIX-ITEMITE-ITEM
OeinvclineOEINVCLINENot RequiredMIX-ATN-OBJ-IDOIL-ATN-OBJ-ID
Oeinvcline CstOEINVCLINENot RequiredMIX-ATN-OBJ-IDOIL-ATN-OBJ-ID-C
OeinvcmiscOEINVCMISCNot RequiredMIX-ATN-OBJ-IDOIM-ATN-OBJ-ID
Oeinvcmisc CstOEINVCMISCNot RequiredMIX-ATN-OBJ-IDOIM-ATN-OBJ-ID-C
PaencumberPAENCUMBERRequiredMIX-ATN-OBJ-IDPEN-ATN-OBJ-ID
PovadistPOVADISTNot RequiredValid When MIX-SYSTEM = "PO"MIX-ATN-OBJ-IDPVD-ATN-OBJ-ID
SystemcodeSYSTEMCODERequiredMIX-SYSTEMSYS-SYSTEM

One to many (12) — child tables

RelationTableRulesConditionField map
AmtransAMTRANSMIX-ATN-OBJ-IDAMT-ATN-OBJ-ID, AMT-ASSET, AMT-SEQ-NUMBER, AMT-COMPANY
ApapdhistAPAPDHISTMIX-ATN-OBJ-IDAH2-ATN-OBJ-ID, AH2-COMPANY, AH2-VENDOR, AH2-INVOICE, AH2-SUFFIX, AH2-CANCEL-SEQ, AH2-DIST-SEQ-NBR
ApdistribAPDISTRIBMIX-ATN-OBJ-IDAPD-ATN-OBJ-ID, APD-COMPANY, APD-VENDOR, APD-INVOICE, APD-SUFFIX, APD-CANCEL-SEQ, APD-DIST-SEQ-NBR
CbdistribCBDISTRIBMIX-ATN-OBJ-IDCBD-ACT-OBJ-ID, CBD-CASH-CODE, CBD-BANK-INST-CODE, CBD-TRANS-IDENT, CBD-DIST-TYPE, CBD-SEQ-NBR
EedistribEEDISTRIBMIX-ATN-OBJ-IDEED-ACT-OBJ-ID, EED-COMPANY, EED-VENDOR, EED-EXPENSE-NBR, EED-SEQ-NBR
IcmmdistMMDISTValid When MIX-SYSTEM = "IC"MIX-ATN-OBJ-IDMMD-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
MmdistMMDISTMIX-ATN-OBJ-IDMMD-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-IDMMD-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-IDPVC-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-IDPVH-ATN-OBJ-ID, PVH-PROCURE-GROUP, PVH-VEN-AGRMT-REF
RqmmdistMMDISTValid When MIX-SYSTEM = "RQ"MIX-ATN-OBJ-IDMMD-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
TimerecordTIMERECORDMIX-COMPANYTRD-COMPANY, MIX-ATN-OBJ-IDTRD-ATN-OBJ-ID, TRD-TIME-SEQ

Programs

Updated by (336)

Referenced by (9)