Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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     AC30.2    AC30.3    AC32.1
AC490     AC98.1    AC98.2    ACDL.1    AC176

UPDATED BY

AC120     AC300     AC310     AC530     AC541     AC542
AC741     AC742     GR741     GR742     AP170     AP193
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     CB10.1    CB180     CB191
CB20.1    CB30.1    CB80.1    EE135     EE35.1    EE35.2
EE520     GL199     IFGT.1    POIF.1    PR128     PR131
PR132     PR134     PR136     PR137     PR195     PR197
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     PR82.1
PR85.1    PRSA.1    UK102     UK330     UK120

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.             AC741   AP170
                                                                 AP193   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
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL199   GR741
                                                                 IFGT.1  POIF.1
                                                                 PR128   PR131
                                                                 PR132   PR134
                                                                 PR136   PR137
                                                                 PR195   PR197
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 ...

MIX-ACTIVITY         Alpha 15                                    AC530   AC541
Activity             Key field. This is the activity for the     AC542   AC741
                     commitment information.                     AP170   AP193
                                                                 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   CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB80.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 GR741   IFGT.1
                                                                 POIF.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR195
                                                                 PR197   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

MIX-ACCT-CATEGORY    Alpha 5                                     AC530   AC541
Account Category     Key field. This is the account category     AC542   AC741
                     for the commitment information.             AP170   AP193
                                                                 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   CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB80.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 GR741   IFGT.1
                                                                 POIF.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR195
                                                                 PR197   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

MIX-FISCAL-YEAR      Numeric 4                                   AC298   AC530
Fiscal Year          This is the current fiscal year.  This      AC541   AC542
                     field is updated by Period Closing          AC741   AP170
                     (GL199).                                    AP193   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
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL199   GR741
                                                                 IFGT.1  POIF.1
                                                                 PR128   PR131
                                                                 PR132   PR134
                                                                 PR136   PR137
                                                                 PR195   PR197
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 ...

MIX-PERIOD           Numeric 2                                   AC298   AC530
Period               Key field. This is the period for the       AC541   AC542
                     commitment information.                     AC741   AP170
                                                                 AP193   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
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL199   GR741
                                                                 IFGT.1  POIF.1
                                                                 PR128   PR131
                                                                 PR132   PR134
                                                                 PR136   PR137
                                                                 PR195   PR197
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 ...

MIX-SYSTEM           Alpha 2                                     AC530   AC541
System Code          A two-character code representing an        AC542   AC741
                     application used within the Lawson          AP170   AP193
                     system. (i.e.: GL = General Ledger, AP =    AP30.2  AP30.4
                     Accounts Payable, etc.)                     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   CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB80.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 GR741   IFGT.1
                                                                 POIF.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR195
                                                                 PR197   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

MIX-COMPANY          Numeric 4                                   AC530   AC541
Company              Key field. This is the company for the      AC542   AC741
                     commitment information.                     AP170   AP193
                                                                 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   CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB80.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 GR741   IFGT.1
                                                                 POIF.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR195
                                                                 PR197   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

MIX-CURRENCY-CODE    Alpha 5                                     AC530   AC541
Transaction          Key field. This field defines the           AC542   AC741
Currency Code        currency code for the commitment.           AP170   AP193
                                                                 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   CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB80.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 GR741   IFGT.1
                                                                 POIF.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR195
                                                                 PR197   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

MIX-ATN-OBJ-ID       Numeric 12                                  AC530   AC541
Object Identifier    Key field. This is the object               AC542   AC741
                     identifier for the committed                AP170   AP193
                     transaction.                                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   CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB80.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 GR741   IFGT.1
                                                                 POIF.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR195
                                                                 PR197   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

MIX-ACCT-UNIT        Alpha 15                                    AC530   AC541
Accounting Unit      This is the accounting unit for the         AC542   AC741
                     commitment.                                 AP170   AP193
                                                                 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   CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB80.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 GR741   IFGT.1
                                                                 POIF.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR195
                                                                 PR197   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

MIX-ACCOUNT          Numeric 6                                   AC530   AC541
Account              This is the account for the commitment.     AC542   AC741
                                                                 AP170   AP193
                                                                 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   CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB80.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 GR741   IFGT.1
                                                                 POIF.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR195
                                                                 PR197   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

MIX-SUB-ACCOUNT      Numeric 4                                   AC530   AC541
Subaccount           This is the subaccount for the              AC542   AC741
                     commitment.                                 AP170   AP193
                                                                 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   CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB80.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 GR741   IFGT.1
                                                                 POIF.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR195
                                                                 PR197   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

MIX-TRAN-AMOUNT      Signed 15.2                                 AC530   AC541
Transaction Amount   This is the amount in transaction           AC542   AC741
                     currency for the commitment.                AP170   AP193
                                                                 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   CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB80.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 GR741   IFGT.1
                                                                 POIF.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR195
                                                                 PR197   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

MIX-UNIT             Signed 15.2                                 AC530   AC541
Unit                 This field indicates the number of          AC542   AC741
                     units for the commitment.                   AP170   AP193
                                                                 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   CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB80.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 GR741   IFGT.1
                                                                 POIF.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR195
                                                                 PR197   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

MIX-BURDEN-AMT       Signed 15.2                                 AC530   AC541
Burden Amt                                                       AC542   AC741
                                                                 AP170   AP193
                                                                 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   CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB80.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 GR741   IFGT.1
                                                                 POIF.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR195
                                                                 PR197   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

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   AC741
                                                                 AP170   AP193
                                                                 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   CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB80.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 GR741   IFGT.1
                                                                 POIF.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR195
                                                                 PR197   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

MIX-ITEM             Alpha 32                                    AC530   AC541
Item Number          This field contains the item                AC542   AC741
                     identifier.                                 AP170   AP193
                                                                 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   CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB80.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 GR741   IFGT.1
                                                                 POIF.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR195
                                                                 PR197   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

MIX-RESOURCE-CODE    Alpha 10                                    AC530   AC541
Resource Code                                                    AC542   AC741
                                                                 AP170   AP193
                                                                 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   CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB80.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 GR741   IFGT.1
                                                                 POIF.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR195
                                                                 PR197   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

MIX-RESOURCE-TYPE    Alpha 1                                     AC530   AC541
Resource Type                                                    AC542   AC741
                                                                 AP170   AP193
                                                                 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   CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB80.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 GR741   IFGT.1
                                                                 POIF.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR195
                                                                 PR197   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

MIX-RESOURCE-DESC    Alpha 30  (Lower Case)                      AC530   AC541
Resource Desc                                                    AC542   AC741
                                                                 AP170   AP193
                                                                 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   CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB80.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 GR741   IFGT.1
                                                                 POIF.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR195
                                                                 PR197   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

                         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                                                 AC30.2  AC30.3
          COMPANY                                                AC300   AC310
          CURRENCY-CODE                                          AC32.1  AC490
          ATN-OBJ-ID                                             AC98.1  AC98.2
                                                                 ACDL.1

MIXSET2   ATN-OBJ-ID    KeyChange                                AC530   AC541
                                                                 AC542   AC741
                                                                 AC742   GR741
                                                                 GR742   AP170
                                                                 AP193   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
                                                                 ...

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

                         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

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

                         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