 |
Lawson Insight Technical Documentation |
|
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 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 EE135 EE35.1
EE35.2 EE520 GL199 IC28.1 IFGT.1 MA180
MA41.2 MA43.2 MA43.9 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.3 MA67.1 MA67.2
MA70.1 MAI1.1 PO100 PO101 PO122 PO131
PO20.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 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 POI3.1 POIE.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 RQ10.1 RQ10.2 TA147 UK120
WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MIX-ACTIVITY-GRP Alpha 15 AC120 AC530
Activity Group Key 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 EE135
EE35.1 EE35.2
EE520 GL199
...
MIX-ACTIVITY Alpha 15 AC530 AC541
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
EE135 EE35.1
EE35.2 EE520
GL199 IC28.1
...
MIX-ACCT-CATEGORY Alpha 5 AC530 AC541
Account Category Key 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
EE135 EE35.1
EE35.2 EE520
GL199 IC28.1
...
MIX-FISCAL-YEAR Numeric 4 AC298 AC530
Fiscal Year This 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 EE135
EE35.1 EE35.2
EE520 GL199
...
MIX-PERIOD Numeric 2 AC298 AC530
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 EE135
EE35.1 EE35.2
EE520 GL199
...
MIX-SYSTEM Alpha 2 AC530 AC541
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
EE135 EE35.1
EE35.2 EE520
GL199 IC28.1
...
MIX-COMPANY Numeric 4 AC530 AC541
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
EE135 EE35.1
EE35.2 EE520
GL199 IC28.1
...
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
EE135 EE35.1
EE35.2 EE520
GL199 IC28.1
...
MIX-ATN-OBJ-ID Numeric 12 AC530 AC541
Object Identifier Key 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
EE135 EE35.1
EE35.2 EE520
GL199 IC28.1
...
MIX-ACCT-UNIT Alpha 15 AC530 AC541
Accounting Unit This 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
EE135 EE35.1
EE35.2 EE520
GL199 IC28.1
...
MIX-ACCOUNT Numeric 6 AC530 AC541
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
EE135 EE35.1
EE35.2 EE520
GL199 IC28.1
...
MIX-SUB-ACCOUNT Numeric 4 AC530 AC541
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
EE135 EE35.1
EE35.2 EE520
GL199 IC28.1
...
MIX-TRAN-AMOUNT Signed 15.2 AC530 AC541
Transaction Amount This 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
EE135 EE35.1
EE35.2 EE520
GL199 IC28.1
...
MIX-UNIT Signed 15.2 AC530 AC541
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
EE135 EE35.1
EE35.2 EE520
GL199 IC28.1
...
MIX-BURDEN-AMT Signed 15.2 AC530 AC541
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
EE135 EE35.1
EE35.2 EE520
GL199 IC28.1
...
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.
MIX-ACCT-CAT-TYPE Derived
Acct Cat Type
MIX-INVOICE Alpha 22 AC530 AC541
Invoice Number Used 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
EE135 EE35.1
EE35.2 EE520
GL199 IC28.1
...
MIX-ITEM Alpha 32 AC530 AC541
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
EE135 EE35.1
EE35.2 EE520
GL199 IC28.1
...
MIX-RESOURCE-CODE Alpha 10 AC530 AC541
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
EE135 EE35.1
EE35.2 EE520
GL199 IC28.1
...
MIX-RESOURCE-TYPE Alpha 1 AC530 AC541
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
EE135 EE35.1
EE35.2 EE520
GL199 IC28.1
...
MIX-RESOURCE-DESC Alpha 30 (Lower Case) AC530 AC541
Resource Desc 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
EE135 EE35.1
EE35.2 EE520
GL199 IC28.1
...
MIX-GLT-OBJ-ID Numeric 12 AC530 AC541
Subsystem GL This is a subsystem GL interface AC542 AP125
Interface ID identification number. It is used for AP126 AP131
Drill Around purposes. 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
EE135 EE35.1
EE35.2 EE520
GL199 IC28.1
...
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 AC490
CURRENCY-CODE AC530 AC541
ATN-OBJ-ID AC542 AC881
AC98.1 AC98.2
ACDL.1 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
...
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 -> 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
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
|