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
AC121 AC123 AC130 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC298 AC32.1 AC37.1 AC490
AC98.1 AC98.2 ACDL.1 POIG.1 AC176
UPDATED BY
AC120 AC300 AC310 AC530 AC541 AC542
AC881 AP125 AP126 AP131 AP170 AP193
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.4 AP32.2 AP520 API1.1 API2.1 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 BN150 BN66.1 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 MA41.2
MA41.7 MA43.1 MA43.2 MA43.3 MA43.9 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 PO100 PO101 PO122 PO131 PO135
PO150 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.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 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 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
PR36.1 PR37.1 PR38.1 PR45.1 PR529 PR530
PR560 PR80.1 PR82.1 PR85.1 PR89.1 PRSA.1
UK102 UK330 UK560 RQ10.1 RQ10.2 RQ10.3
RQ11.1 RQ12.1 RQ13.1 RQ140 RQ300 RQ35.1
RQ40.1 RQ41.1 RQ42.1 RQ44.1 RQ44.2 RQ500
RQD0.1 RQIE.1 RQIF.1 TA147 UK120 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 AC530
Element: Activity GroupKey field. This is the activity group AC541 AC542
for the commitment information. AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP32.2 AP520
API1.1 API2.1
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
BN150 BN66.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 CXCP.1
DR100 EE135
EE35.1 EE35.2
...
MIX-ACTIVITY Alpha 15 AC530 AC541
Element: Activity Key field. This is the activity for the AC542 AP125
commitment information. AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 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 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
MIX-ACCT-CATEGORY Alpha 5 AC530 AC541
Element: Account CategoKey field. This is the account category AC542 AP125
for the commitment information. AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 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 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
MIX-FISCAL-YEAR Numeric 4 AC298 AC530
Element: Last Closed YeThis is the current fiscal year. This AC541 AC542
field is updated by Period Closing AP125 AP126
(GL199). AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP32.2 AP520
API1.1 API2.1
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
BN150 BN66.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 CXCP.1
DR100 EE135
EE35.1 EE35.2
...
MIX-PERIOD Numeric 2 AC298 AC530
Element: Period Key field. This is the period for the AC541 AC542
commitment information. AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP32.2 AP520
API1.1 API2.1
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
BN150 BN66.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 CXCP.1
DR100 EE135
EE35.1 EE35.2
...
MIX-SYSTEM Alpha 2 AC530 AC541
Element: System Code A two-character code representing an AC542 AP125
application used within the Lawson AP126 AP131
system. (i.e.: GL = General Ledger, AP = AP170 AP193
Accounts Payable, etc.) AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 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 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
MIX-COMPANY Numeric 4 AC530 AC541
Element: Company Key field. This is the company for the AC542 AP125
commitment information. AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 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 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
MIX-CURRENCY-CODE Alpha 5 AC530 AC541
Transaction Key field. This field defines the AC542 AP125
Currency Code currency code for the commitment. AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 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 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
MIX-ATN-OBJ-ID Numeric 12 AC530 AC541
Element: Object IdentifKey field. This is the object AC542 AP125
identifier for the committed AP126 AP131
transaction. AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 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 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
MIX-ACCT-UNIT Alpha 15 AC530 AC541
Element: Accounting UniThis is the accounting unit for the AC542 AP125
commitment. AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 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 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
MIX-ACCOUNT Numeric 6 AC530 AC541
Element: Account This is the account for the commitment. AC542 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 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 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
MIX-SUB-ACCOUNT Numeric 4 AC530 AC541
Element: Subaccount This is the subaccount for the AC542 AP125
commitment. AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 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 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
MIX-TRAN-AMOUNT Signed 15.2 AC530 AC541
Element: Transaction AmThis is the amount in transaction AC542 AP125
currency for the commitment. AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 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 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
MIX-UNIT Signed 15.2 AC530 AC541
Element: Unit This field indicates the number of AC542 AP125
units for the commitment. AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 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 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
MIX-BURDEN-AMT Signed 15.2 AC530 AC541
Element: Burden Amt AC542 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 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 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
MIX-PR-FRINGE-AMT Derived
Element: Pr Fringe Amt This field contains the Lawson Payroll
fringe benefit amount for the activity.
MIX-PR-COMMIT-AMT Derived
Element: 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.
MIX-ACCT-CAT-TYPE Derived
Element: Acct Cat Type
MIX-INVOICE Alpha 22 AC530 AC541
Element: Invoice NumberUsed to identify the invoice. AC542 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 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 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
MIX-ITEM Alpha 32 AC530 AC541
Element: Item Number This field contains the item AC542 AP125
identifier. AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 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 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
MIX-RESOURCE-CODE Alpha 10 AC530 AC541
Element: Resource Code AC542 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 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 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
MIX-RESOURCE-TYPE Alpha 1 AC530 AC541
Element: Resource Type AC542 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 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 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
MIX-RESOURCE-DESC Alpha 30 (Lower Case) AC530 AC541
Element: Description AC542 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 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 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
MIX-GLT-OBJ-ID Numeric 12 AC530 AC541
Object AC542 AP125
Identification AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 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 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
ACCOMMITX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MIXSET1 ACTIVITY-GRP AC120 AC121
ACTIVITY AC123 AC130
ACCT-CATEGORY AC20.1 AC20.2
FISCAL-YEAR AC20.3 AC20.4
PERIOD AC20.5 AC298
SYSTEM AC300 AC310
COMPANY AC32.1 AC37.1
CURRENCY-CODE AC490 AC530
ATN-OBJ-ID AC541 AC542
AC881 AC98.1
AC98.2 ACDL.1
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
...
MIXSET2 ATN-OBJ-ID KeyChange AC530 AC541
AC542 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
...
MIXSET3 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
COMPANY
ACCT-UNIT
ATN-OBJ-ID
MIXSET4 COMPANY KeyChange AC176
SYSTEM
ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
CURRENCY-CODE
ATN-OBJ-ID
MIXSET5 ACTIVITY-GRP AC98.1 AC98.2
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR*
PERIOD
SYSTEM
COMPANY
CURRENCY-CODE
ATN-OBJ-ID
MIXSET6 GLT-OBJ-ID 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
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
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
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
|