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 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 AP193 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 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 CB10.1 CB180 CB191 CB20.1
CB30.1 CB500 CB80.1 CXCP.1 EE135 EE35.1
EE35.2 EE520 GL199 DR100 IC140 IC28.1
IC531 IC83.1 IFGT.1 MA180 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA66.3
MA67.1 MA67.2 MA70.1 MA75.1 MA80.1 MAI1.1
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 OE111 OE113 OE114 OE116 OE129
OE13.2 OE13.3 OE13.5 OE13.6 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE530 OE81.1 OE810 OE830
OE90.1 OE90.2 PA182 PO100 PO101 PO122
PO131 PO150 PO20.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO25.1 PO25.6 PO25.7
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO33.1 PO34.1 PO35.1 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 POCP.1 POI3.1 POID.1 POIE.1 POIF.1
POII.1 POIJ.1 PR128 PR130 PR131 PR132
PR134 PR136 PR137 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 PR82.1 PR85.1 PRSA.1 UK102
UK330 RQ10.1 RQ10.2 RQ12.1 RQ13.1 RQ13.2
RQ140 RQ300 RQ35.1 RQ40.1 RQ41.1 RQ42.1
RQ44.1 RQ44.2 RQ500 RQIF.1 TA147 TP135
WH130 WH132 WH190 WH20.2 WH20.7 WH222
WH25.1 WH25.2 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
WO132 WO140
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 AP193
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 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
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 CXCP.1
DR100 EE135
...
MIX-ACTIVITY Alpha 15 AC346 AC46.1
Element: Activity Key field. This is the activity for the AP125 AP126
commitment information. AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
...
MIX-ACCT-CATEGORY Alpha 5 AC346 AC46.1
Element: Account CategoKey field. This is the account category AP125 AP126
for the commitment information. AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
...
MIX-FISCAL-YEAR Numeric 4 AC108 AC120
Element: Last Closed YeThis is the current fiscal year. This AC145 AC190
field is updated by Period Closing AC191 AC298
(GL199). AC346 AC45.1
AC46.1 AC580
AC581 AC583
ACDR.1 AP125
AP126 AP131
AP170 AP193
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 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-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 AP193
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 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-SYSTEM Alpha 2 AC346 AC46.1
Element: System Code A two-character code representing an AP125 AP126
application used within the Lawson AP131 AP170
system. (i.e.: GL = General Ledger, AP = AP193 AP25.1
Accounts Payable, etc.) 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
...
MIX-COMPANY Numeric 4 AC346 AC46.1
Element: Company Key field. This is the company for the AP125 AP126
commitment information. AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.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
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.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. AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
...
MIX-ACCT-UNIT Alpha 15 AC346 AC46.1
Element: Accounting UniThis is the accounting unit for the AP125 AP126
commitment. AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
...
MIX-ACCOUNT Numeric 6 AC346 AC46.1
Element: Account This is the account for the commitment. AP125 AP126
AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
...
MIX-SUB-ACCOUNT Numeric 4 AC346 AC46.1
Element: Subaccount This is the subaccount for the AP125 AP126
commitment. AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.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 AP193
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 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
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 CXCP.1
DR100 EE135
...
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 AP193
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 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
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 CXCP.1
DR100 EE135
...
MIX-BURDEN-AMT Signed 18.2 AC346 AC45.1
Element: Intl Amt AC46.1 AP125
AP126 AP131
AP170 AP193
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 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
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 CXCP.1
DR100 EE135
...
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 NumberUsed to identify the invoice. AP125 AP126
AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
...
MIX-ITEM Alpha 32 AC346 AC46.1
Element: Item Number This field contains the item AP125 AP126
identifier. AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.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. AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.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 AP193 AP25.1
Q - Equipment AP25.2 AP26.1
E - Employee AP27.1 AP30.2
V - Vendor AP30.4 AP520
A - Asset API1.1 API2.1
E = Employee AR115 AR124
V = Vendor AR190 AR20.1
P = Person AR21.1 AR21.2
Q = Equipment AR21.3 AR24.1
A = Asset AR29.2 AR30.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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
...
MIX-RESOURCE-DESC Alpha 30 (Lower Case) AC346 AC46.1
Element: Description AP125 AP126
AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
...
MIX-GLT-OBJ-ID Numeric 12 AC346 AC46.1
Object This is a subsystem GL interface AP125 AP126
Identification identification number. It is used for AP131 AP170
Drill Around purposes. AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.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 AP193 AP25.1
company if resource is vendor and AM AP25.2 AP26.1
company if resource is asset. 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
...
MIX-TRANS-DATE Numeric 8 (yyyymmdd) AC346 AC46.1
Element: Transaction DaThe date of the transaction. AP125 AP126
AP131 AP170
For payroll commitments created during AP193 AP25.1
salary encumbrance, this is the pay AP25.2 AP26.1
period end date or the activity period AP27.1 AP30.2
end date on split transactions (when pay AP30.4 AP520
period spans an activity period end API1.1 API2.1
date). AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
...
MIX-END-DATE Numeric 8 (yyyymmdd) AC346 AC46.1
Element: Ending Date Manual commitment end (or expiration) AP125 AP126
date. AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
...
MIX-USER-ID Alpha 10 (Lower Case) AC346 AC46.1
Element: User Contains the user ID of the person who AP125 AP126
last changed this record. AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.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 AP193 AP25.1
fringe (FR). 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
...
MIX-GMA-OBJ-ID Numeric 12 AC346 AC46.1
Object AP125 AP126
Identification AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
...
MIX-GM-SALARY-PCT Signed 13.6 AC346 AC46.1
Element: Gm Salary Pct AP125 AP126
AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.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 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
...
MIXSET2 ATN-OBJ-ID AC108 AC120
AC145 AC190
AC191 AC246
AC346 AC45.1
AC46.1 AC580
AC581 AC583
ACDR.1 AP125
AP126 AP131
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
...
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
|