Lawson Insight Technical Documentation |
|
ACCOMMITX
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
AC298 AC98.1 AC98.2 ACDL.1 SNAC.1 AC246
POIG.1
UPDATED BY
AC108 AC120 AC145 AC190 AC191 AC300
AC310 AC346 AC45.1 AC46.1 AC580 AC581
AC583 AC881 ACDR.1 AP125 AP126 AP131
AP170 AP190 AP193 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP520
API1.1 API2.1 AR115 AR124 AR190 AR20.1
AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1
AR32.1 AR34.1 AR42.1 AR42.2 AR42.7 AR43.1
AR560 AR570 AR575 AR580 ARLL.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 BN150
BN66.1 CB10.1 CB15.1 CB150 CB180 CB191
CB20.1 CB30.1 CB45.1 CB46.1 CB500 CB543
CB544 CB55.1 CB554 CB80.1 CB82.1 CXCP.1
EE135 EE35.1 EE35.2 EE520 ET530 ETI2.1
GL170 GL199 GL70.1 GL70.2 GL70.3 GL70.5
GL70.6 GL75.1 IFGT.1 LP130 MA180 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.7 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA66.3 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1
PA182 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PO100 PO101 PO122 PO131 PO135
PO150 PO190 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO27.2 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO32.4 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 POCP.1 POD0.1 POI3.1 POID.1
POIF.1 POII.1 POIJ.1 PR128 PR130 PR131
PR132 PR134 PR136 PR137 PR140 PR189
PR195 PR197 PR198 PR29.1 PR32.1 PR32.2
PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR35.9 PR36.1
PR37.1 PR38.1 PR45.1 PR529 PR530 PR560
PR80.1 PR82.1 PR85.1 PR89.1 UK102 UK330
UK560 RQ10.1 RQ10.2 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ500 RQD0.1 RQIF.1 TA147 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MIX-ACTIVITY-GRP Alpha 15 AC120 AC346
Element: Activity GroupKey field. This is the activity group AC46.1 AP125
for the commitment information. AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BN150
...
MIX-ACTIVITY Alpha 15 AC346 AC46.1
Element: Activity Key field. This is the activity for the AP125 AP126
commitment information. AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-ACCT-CATEGORY Alpha 5 AC346 AC46.1
Element: Acct Category Key field. This is the account category AP125 AP126
for the commitment information. AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-FISCAL-YEAR Numeric 4 AC108 AC120
Element: Year Contains the fiscal year for the data AC145 AC190
stored on this record. AC191 AC298
AC346 AC45.1
AC46.1 AC580
AC581 AC583
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
...
MIX-PERIOD Numeric 2 AC108 AC120
Element: Period Key field. This is the period for the AC145 AC190
commitment information. AC191 AC298
AC346 AC45.1
AC46.1 AC580
AC581 AC583
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
...
MIX-SYSTEM Alpha 2 AC346 AC46.1
Element: System A two-character code representing an AP125 AP126
application used within the Lawson AP131 AP170
system. (i.e.: GL = General Ledger, AP = AP190 AP193
Accounts Payable, etc.) AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-COMPANY Numeric 4 AC346 AC46.1
Element: Company Key field. This is the company for the AP125 AP126
commitment information. AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-CURRENCY-CODE Alpha 5 AC346 AC46.1
Transaction Key field. This field defines the AP125 AP126
Currency Code currency code for the commitment. AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-ATN-OBJ-ID Numeric 12 AC346 AC46.1
Element: Object IdentifKey field. This is the object AP125 AP126
identifier for the committed AP131 AP170
transaction. AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-ACCT-UNIT Alpha 15 AC346 AC46.1
Element: Acct Unit This is the accounting unit for the AP125 AP126
commitment. AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-ACCOUNT Numeric 6 AC346 AC46.1
Element: Account This is the account for the commitment. AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-SUB-ACCOUNT Numeric 4 AC346 AC46.1
Element: Sub Acct This is the subaccount for the AP125 AP126
commitment. AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-TRAN-AMOUNT Signed 18.2 AC346 AC45.1
Element: Transaction AmThis is the amount in transaction AC46.1 AP125
currency for the commitment. AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BN150
...
MIX-UNIT Signed 15.2 AC346 AC45.1
Element: Unit This field indicates the number of AC46.1 AP125
units for the commitment. AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BN150
...
MIX-BURDEN-AMT Signed 18.2 AC346 AC45.1
Element: Intl Amt AC46.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BN150
...
MIX-PR-FRINGE-AMT Derived
Element: Pr Fringe Amt This 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 Derived
Element: Pr Commit Amt This field contains the sum of the Tran
Amount and the PR Fringe Amt fields.
MIX-ACCT-CAT-TYPE Derived
Element: Acct Cat Type
MIX-INVOICE Alpha 22 AC346 AC46.1
Element: Invoice Used to identify the invoice. AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-ITEM Alpha 32 AC346 AC46.1
Element: Item This field contains the item AP125 AP126
identifier. AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-RESOURCE-CODE Alpha 10 AC346 AC46.1
Element: Resource Code The code identifying the resource AP125 AP126
assigned to the activity or activity AP131 AP170
group. AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-RESOURCE-TYPE Alpha 1 AC346 AC46.1
Element: Resource Type The type of resource. Valid values AP125 AP126
include: AP131 AP170
P - AC Person AP190 AP193
Q - Equipment AP20.1 AP20.2
E - Employee AP20.3 AP20.4
V - Vendor AP20.5 AP20.7
A - Asset AP21.1 AP23.1
E = Employee AP25.1 AP25.2
V = Vendor AP26.1 AP27.1
P = Person AP30.2 AP30.4
Q = Equipment AP520 API1.1
A = Asset API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-RESOURCE-DESC Alpha 30 (Lower Case) AC346 AC46.1
Element: Description This field displays the description. AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-GLT-OBJ-ID Numeric 12 AC346 AC46.1
Element: Obj Id This is the object identifier. It is AP125 AP126
used to relate commitments or posted AP131 AP170
transactions back to the originating AP190 AP193
subsystems. Each subsystem record that AP20.1 AP20.2
is updated as a commitment or posted AP20.3 AP20.4
transaction is assigned an object AP20.5 AP20.7
identifier. The object identifier is AP21.1 AP23.1
maintained in the subsystem files and in AP25.1 AP25.2
the Activity Commitments Detail and AP26.1 AP27.1
Activity Transaction files. The object AP30.2 AP30.4
identifier is a unique key used to drill AP520 API1.1
back from Activity Management to the API2.1 AR115
subsystems. AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-RESOURCE-COMP Numeric 4 AC346 AC46.1
Element: Resource Comp Required if resource is present in AP125 AP126
commitment transaction; capture HR AP131 AP170
company if resource is employee, AP AP190 AP193
company if resource is vendor and AM AP20.1 AP20.2
company if resource is asset. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-TRANS-DATE Numeric 8 (yyyymmdd) AC346 AC46.1
Element: Trans Date The date of the transaction. AP125 AP126
AP131 AP170
For payroll commitments created during AP190 AP193
salary encumbrance, this is the pay AP20.1 AP20.2
period end date or the activity period AP20.3 AP20.4
end date on split transactions (when pay AP20.5 AP20.7
period spans an activity period end AP21.1 AP23.1
date). AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-END-DATE Numeric 8 (yyyymmdd) AC346 AC46.1
Element: End Date Manual commitment end (or expiration) AP125 AP126
date. AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-USER-ID Alpha 10 (Lower Case) AC346 AC46.1
Element: User AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-SOURCE-CODE Alpha 2 AC346 AC46.1
Element: Source Code Identifies commitment transactions AP125 AP126
created from salary encumbrance AP131 AP170
processing (GM110) as labor (LD) or AP190 AP193
fringe (FR). AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-GMA-OBJ-ID Numeric 12 AC346 AC46.1
Element: Obj Id This is the object identifier. It is AP125 AP126
used to relate commitments or posted AP131 AP170
transactions back to the originating AP190 AP193
subsystems. Each subsystem record that AP20.1 AP20.2
is updated as a commitment or posted AP20.3 AP20.4
transaction is assigned an object AP20.5 AP20.7
identifier. The object identifier is AP21.1 AP23.1
maintained in the subsystem files and in AP25.1 AP25.2
the Activity Commitments Detail and AP26.1 AP27.1
Activity Transaction files. The object AP30.2 AP30.4
identifier is a unique key used to drill AP520 API1.1
back from Activity Management to the API2.1 AR115
subsystems. AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
MIX-GM-SALARY-PCT Signed 13.6 AC346 AC46.1
Element: Gm Salary Pct AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
...
ACCOMMITX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MIXSET1 ACTIVITY-GRP KeyChange AC108 AC120
ACTIVITY AC145 AC190
ACCT-CATEGORY AC191 AC298
FISCAL-YEAR AC300 AC310
PERIOD AC346 AC45.1
SYSTEM AC46.1 AC580
COMPANY AC581 AC583
CURRENCY-CODE AC881 AC98.1
ATN-OBJ-ID AC98.2 ACDL.1
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
...
MIXSET2 ATN-OBJ-ID AC108 AC120
AC145 AC190
AC191 AC246
AC346 AC45.1
AC46.1 AC580
AC581 AC583
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
...
MIXSET3 RESOURCE-COMP KeyChange PR198
RESOURCE-TYPE
RESOURCE-CODE
SYSTEM
TRANS-DATE
ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
ATN-OBJ-ID
MIXSET4 ACTIVITY KeyChange
RESOURCE-TYPE
RESOURCE-COMP
RESOURCE-CODE
SYSTEM
INVOICE
TRANS-DATE
ACTIVITY-GRP
ACCT-CATEGORY
ATN-OBJ-ID
MIXSET5 ACTIVITY KeyChange AC246 AC346
ACTIVITY-GRP AC46.1 AC98.1
ACCT-CATEGORY AC98.2
FISCAL-YEAR
PERIOD
SYSTEM
COMPANY
CURRENCY-CODE
ATN-OBJ-ID
MIXSET6 GLT-OBJ-ID KeyChange GL199
ATN-OBJ-ID
ACCOMMITX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
MIX-ACCT-CATEGORY -> -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
Apcompany APCOMPANY Not Required
MIX-COMPANY -> CPY-COMPANY
Apvenmast APVENMAST Not Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
MIX-RESOURCE-CODE -> VEN-VENDOR
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
Gltrans GLTRANS Required
MIX-GLT-OBJ-ID -> GLT-OBJ-ID
Gmlabdistx GMLABDISTX Not Required
MIX-GMA-OBJ-ID -> GMA-OBJ-ID
Iccompany ICCOMPANY Not Required
MIX-COMPANY -> ICC-COMPANY
Itemmast ITEMMAST Not Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
MIX-ITEM -> ITE-ITEM
Jobcode JOBCODE Not Required
MIX-COMPANY -> JBC-COMPANY
MIX-INVOICE -> JBC-JOB-CODE
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
Paencumber PAENCUMBER Required
MIX-ATN-OBJ-ID -> PEN-ATN-OBJ-ID
Systemcode SYSTEMCODE Required
MIX-SYSTEM -> SYS-SYSTEM
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
Apapdhist APAPDHIST
MIX-ATN-OBJ-ID -> AH2-ATN-OBJ-ID
AH2-COMPANY
AH2-VENDOR
AH2-INVOICE
AH2-SUFFIX
AH2-CANCEL-SEQ
AH2-DIST-SEQ-NBR
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
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-NUMBER
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-NUMBER
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-NUMBER
MMD-DOC-NBR-NUM
MMD-LINE-NBR
MMD-COMPONENT-SEQ
MMD-LINE-SEQ
Povagrmthd POVAGRMTHD
Valid When MIX-SYSTEM = "PO"
MIX-ATN-OBJ-ID -> PVH-ATN-OBJ-ID
PVH-PROCURE-GROUP
PVH-VEN-AGRMT-REF
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-NUMBER
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
|