ACCOMMITX FILE Activity Commitments Detail 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. REFERENCED BY AC121 AC123 AC127 AC130 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACDL.1 AC176 UPDATED BY AC120 AC530 AP125 AP126 AP170 AP193 AP225 AP226 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4 AP32.2 AP520 AP981 AR115 AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR560 AR570 AR575 AR580 BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1 BL940 BN150 CB10.1 CB180 CB191 CB20.1 CB30.1 CB80.1 CB980 EE135 EE35.1 EE35.2 EE520 GL199 DR100 IC130 IC141 IC142 IC83.1 IFGT.1 IN20.1 MA40.1 MA41.4 MA41.6 MA43.3 MA43.4 MA520 MA530 MA540 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE810 OE830 OE920 OE950 PO100 PO135 PO180 PO20.1 PO21.1 PO21.2 PO21.3 PO21.5 PO21.6 PO22.1 PO22.2 PO22.3 PO25.1 PO25.2 PO25.4 PO26.1 PO28.6 PO30.1 PO31.1 PO32.1 PO33.1 PO34.1 PO35.1 PO530 PO821 PO990 PR128 PR131 PR132 PR134 PR136 PR137 PR140 PR150 PR195 PR199 PR32.1 PR32.2 PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR36.1 PR37.1 PR38.1 PR45.1 PR530 PR80.1 PR82.1 PR85.1 PRSA.1 UK102 UK330 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ20.1 RQ20.3 RQ20.4 RQ35.1 RQ500 RQ990 UK120 WH130 WH132 WH190 WH20.2 WH20.7 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830 WO132 WO140 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY MIX-ACTIVITY-GRP Alpha 15 AC120 AC530 Activity Group Key field. This is the activity group AP125 AP126 for the commitment information. AP170 AP193 AP225 AP226 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4 AP32.2 AP520 AP981 AR115 AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR560 AR570 AR575 AR580 BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1 BL940 BN150 CB10.1 CB180 CB191 CB20.1 CB30.1 CB80.1 CB980 DR100 EE135 EE35.1 EE35.2 ... MIX-ACTIVITY Alpha 15 AC530 AP125 Activity Key field. This is the activity for the AP126 AP170 commitment information. AP193 AP225 AP226 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4 AP32.2 AP520 AP981 AR115 AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR560 AR570 AR575 AR580 BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1 BL940 BN150 CB10.1 CB180 CB191 CB20.1 CB30.1 CB80.1 CB980 DR100 EE135 EE35.1 EE35.2 EE520 ... MIX-ACCT-CATEGORY Alpha 5 AC530 AP125 Account Category Key field. This is the account category AP126 AP170 for the commitment information. AP193 AP225 AP226 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4 AP32.2 AP520 AP981 AR115 AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR560 AR570 AR575 AR580 BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1 BL940 BN150 CB10.1 CB180 CB191 CB20.1 CB30.1 CB80.1 CB980 DR100 EE135 EE35.1 EE35.2 EE520 ... MIX-FISCAL-YEAR Numeric 4 AC530 AP125 Fiscal Year This is the current fiscal year. This AP126 AP170 field is updated by GL199 (Period AP193 AP225 Closing). AP226 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4 AP32.2 AP520 AP981 AR115 AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR560 AR570 AR575 AR580 BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1 BL940 BN150 CB10.1 CB180 CB191 CB20.1 CB30.1 CB80.1 CB980 DR100 EE135 EE35.1 EE35.2 EE520 ... MIX-PERIOD Numeric 2 AC530 AP125 Period Key field. This is the period for the AP126 AP170 commitment information. AP193 AP225 AP226 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4 AP32.2 AP520 AP981 AR115 AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR560 AR570 AR575 AR580 BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1 BL940 BN150 CB10.1 CB180 CB191 CB20.1 CB30.1 CB80.1 CB980 DR100 EE135 EE35.1 EE35.2 EE520 ... MIX-SYSTEM Alpha 2 AC530 AP125 System Code A two-character code representing an AP126 AP170 application used within the Lawson AP193 AP225 system. (i.e.: GL = General Ledger, AP = AP226 AP25.1 Accounts Payable, etc.) AP25.2 AP26.1 AP30.2 AP30.4 AP32.2 AP520 AP981 AR115 AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR560 AR570 AR575 AR580 BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1 BL940 BN150 CB10.1 CB180 CB191 CB20.1 CB30.1 CB80.1 CB980 DR100 EE135 EE35.1 EE35.2 EE520 ... MIX-COMPANY Numeric 4 AC530 AP125 Company Key field. This is the company for the AP126 AP170 commitment information. AP193 AP225 AP226 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4 AP32.2 AP520 AP981 AR115 AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR560 AR570 AR575 AR580 BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1 BL940 BN150 CB10.1 CB180 CB191 CB20.1 CB30.1 CB80.1 CB980 DR100 EE135 EE35.1 EE35.2 EE520 ... MIX-CURRENCY-CODE Alpha 5 AC530 AP125 Transaction Key field. This field defines the AP126 AP170 Currency Code currency code for the commitment. AP193 AP225 AP226 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4 AP32.2 AP520 AP981 AR115 AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR560 AR570 AR575 AR580 BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1 BL940 BN150 CB10.1 CB180 CB191 CB20.1 CB30.1 CB80.1 CB980 DR100 EE135 EE35.1 EE35.2 EE520 ... MIX-ATN-OBJ-ID Numeric 12 AC530 AP125 Object Identifier Key field. This is the object AP126 AP170 identifier for the committed AP193 AP225 transaction. AP226 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4 AP32.2 AP520 AP981 AR115 AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR560 AR570 AR575 AR580 BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1 BL940 BN150 CB10.1 CB180 CB191 CB20.1 CB30.1 CB80.1 CB980 DR100 EE135 EE35.1 EE35.2 EE520 ... MIX-ACCT-UNIT Alpha 15 AC530 AP125 Accounting Unit This is the accounting unit for the AP126 AP170 commitment. AP193 AP225 AP226 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4 AP32.2 AP520 AP981 AR115 AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR560 AR570 AR575 AR580 BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1 BL940 BN150 CB10.1 CB180 CB191 CB20.1 CB30.1 CB80.1 CB980 DR100 EE135 EE35.1 EE35.2 EE520 ... MIX-ACCOUNT Numeric 6 AC530 AP125 Account This is the account for the commitment. AP126 AP170 AP193 AP225 AP226 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4 AP32.2 AP520 AP981 AR115 AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR560 AR570 AR575 AR580 BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1 BL940 BN150 CB10.1 CB180 CB191 CB20.1 CB30.1 CB80.1 CB980 DR100 EE135 EE35.1 EE35.2 EE520 ... MIX-SUB-ACCOUNT Numeric 4 AC530 AP125 Subaccount This is the subaccount for the AP126 AP170 commitment. AP193 AP225 AP226 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4 AP32.2 AP520 AP981 AR115 AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR560 AR570 AR575 AR580 BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1 BL940 BN150 CB10.1 CB180 CB191 CB20.1 CB30.1 CB80.1 CB980 DR100 EE135 EE35.1 EE35.2 EE520 ... MIX-TRAN-AMOUNT Signed 15.2 AC530 AP125 Transaction Amount This is the amount in transaction AP126 AP170 currency for the commitment. AP193 AP225 AP226 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4 AP32.2 AP520 AP981 AR115 AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR560 AR570 AR575 AR580 BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1 BL940 BN150 CB10.1 CB180 CB191 CB20.1 CB30.1 CB80.1 CB980 DR100 EE135 EE35.1 EE35.2 EE520 ... MIX-UNIT Signed 15.2 AC530 AP125 Unit This field indicates the number of AP126 AP170 units for the commitment. AP193 AP225 AP226 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4 AP32.2 AP520 AP981 AR115 AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR560 AR570 AR575 AR580 BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1 BL940 BN150 CB10.1 CB180 CB191 CB20.1 CB30.1 CB80.1 CB980 DR100 EE135 EE35.1 EE35.2 EE520 ... MIX-PR-FRINGE-AMT Derived Pr Fringe Amt This field contains the Lawson Payroll fringe benefit amount for the activity. MIX-PR-COMMIT-AMT Derived Pr Commit Amt This field contains Lawson Payroll commitments for the activity -- activity transactions released in the Payroll system but not yet posted to the Activity Management system. ACCOMMITX FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN MIXSET1 ACTIVITY-GRP AC120 AC121 ACTIVITY AC123 AC127 ACCT-CATEGORY AC130 AC20.1 FISCAL-YEAR AC20.2 AC20.3 PERIOD AC20.4 AC22.1 SYSTEM AC30.2 AC30.3 COMPANY AC32.1 ACDL.1 CURRENCY-CODE ATN-OBJ-ID MIXSET2 ATN-OBJ-ID KeyChange, Duplicates AC530 AP125 AP126 AP170 AP193 AP225 AP226 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4 AP32.2 AP520 AP981 AR115 AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 ... MIXSET3 ACTIVITY-GRP ACTIVITY ACCT-CATEGORY FISCAL-YEAR PERIOD COMPANY ACCT-UNIT ATN-OBJ-ID MIXSET4 COMPANY AC176 SYSTEM ACTIVITY-GRP ACTIVITY ACCT-CATEGORY FISCAL-YEAR PERIOD CURRENCY-CODE ATN-OBJ-ID ACCOMMITX FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Acacctcat ACACCTCAT Required MIX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY Acacctcatx ACACCTCATX Not Required MIX-ACTIVITY-GRP -> AXX-ACTIVITY-GRP MIX-ACTIVITY -> AXX-ACTIVITY MIX-ACCT-CATEGORY -> AXX-ACCT-CATEGORY Acactgrp ACACTGRP Required MIX-ACTIVITY-GRP -> AGP-ACTIVITY-GRP Acactivity ACACTIVITY Required MIX-ACTIVITY -> ACV-ACTIVITY Accommit ACCOMMIT Required 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 Coline COLINE Not Required MIX-ATN-OBJ-ID -> COL-ATN-OBJ-ID Coline Cost COLINE Not Required MIX-ATN-OBJ-ID -> COL-ATN-OBJ-ID-C Comisc COMISC Not Required MIX-ATN-OBJ-ID -> CMC-ATN-OBJ-ID Comisc Cost COMISC Not Required MIX-ATN-OBJ-ID -> CMC-ATN-OBJ-ID-C Oeinvcline OEINVCLINE Not Required MIX-ATN-OBJ-ID -> OIL-ATN-OBJ-ID Oeinvcline Cst OEINVCLINE Not Required MIX-ATN-OBJ-ID -> OIL-ATN-OBJ-ID-C Oeinvcmisc OEINVCMISC Not Required MIX-ATN-OBJ-ID -> OIM-ATN-OBJ-ID Oeinvcmisc Cst OEINVCMISC Not Required MIX-ATN-OBJ-ID -> OIM-ATN-OBJ-ID-C ACCOMMITX FILE RELATIONS ONE TO MANY RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Amtrans AMTRANS MIX-ATN-OBJ-ID -> AMT-ATN-OBJ-ID AMT-ASSET AMT-SEQ-NUMBER AMT-COMPANY Apdistrib APDISTRIB MIX-ATN-OBJ-ID -> APD-ATN-OBJ-ID APD-COMPANY APD-VENDOR APD-INVOICE APD-SUFFIX APD-CANCEL-SEQ APD-DIST-SEQ-NBR Ardistrib ARDISTRIB MIX-ATN-OBJ-ID -> AMD-ATN-OBJ-ID AMD-GL-COMPANY Cbdistrib CBDISTRIB MIX-ATN-OBJ-ID -> CBD-ACT-OBJ-ID CBD-CASH-CODE CBD-BANK-INST-CODE CBD-TRANS-IDENT CBD-DIST-TYPE CBD-SEQ-NBR Eedistrib EEDISTRIB MIX-ATN-OBJ-ID -> EED-ACT-OBJ-ID EED-COMPANY EED-VENDOR EED-EXPENSE-NBR EED-SEQ-NBR Icmmdist MMDIST Valid When MIX-SYSTEM = "IC" MIX-ATN-OBJ-ID -> MMD-ATN-OBJ-ID MMD-COMPANY MMD-SYSTEM-CD MMD-LOCATION MMD-DOC-TYPE MMD-DOC-NBR MMD-DOC-NBR-NUM MMD-LINE-NBR MMD-COMPONENT-SEQ MMD-LINE-SEQ Mmdist MMDIST MIX-ATN-OBJ-ID -> MMD-ATN-OBJ-ID MMD-COMPANY MMD-SYSTEM-CD MMD-LOCATION MMD-DOC-TYPE MMD-DOC-NBR MMD-DOC-NBR-NUM MMD-LINE-NBR MMD-COMPONENT-SEQ MMD-LINE-SEQ Pommdist MMDIST Valid When MIX-SYSTEM = "PO" MIX-ATN-OBJ-ID -> MMD-ATN-OBJ-ID MMD-COMPANY MMD-SYSTEM-CD MMD-LOCATION MMD-DOC-TYPE MMD-DOC-NBR MMD-DOC-NBR-NUM MMD-LINE-NBR MMD-COMPONENT-SEQ MMD-LINE-SEQ Rqmmdist MMDIST Valid When MIX-SYSTEM = "RQ" MIX-ATN-OBJ-ID -> MMD-ATN-OBJ-ID MMD-COMPANY MMD-SYSTEM-CD MMD-LOCATION MMD-DOC-TYPE MMD-DOC-NBR MMD-DOC-NBR-NUM MMD-LINE-NBR MMD-COMPONENT-SEQ MMD-LINE-SEQ Timerecord TIMERECORD MIX-COMPANY -> TRD-COMPANY MIX-ATN-OBJ-ID -> TRD-ATN-OBJ-ID TRD-TIME-SEQ |