Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MMDIST


                              MMDIST FILE

                         Account Distributions

This record holds an account number and possibly an activity code intended for
a general ledger distribution of a non-inventory item, or a Inventory Item
("I" type) that has been expensed (issued). The  record is for an item on
either a  requisition, a  purchase order or a standard purchase  order. For a
non-inventory item and an Inventory Item (Issue), there may be multiple
distribution accounts (more than one MMDIST).

This record may also exist as a result of building general ledger transactions
for inventory items. These come out of the subledger posting programs for
inventory control and purchase order. They are used by drill arounds out of
the general ledger programs when tracing back the origin of a general ledger
transaction.

REFERENCED BY

PO220     PO223     PO253     PO254     PO54.1    PO54.2
PO54.3    PO54.4    POIE.1    MM280     MM80.1    MM80.2
RQ230     PO278     AM17.1    MA236     POIG.1    POIM.1
RQ111     RQID.1    RQIJ.1

UPDATED BY

AM19.1    AM19.2    AP115     AP125     AP126     AP131
AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.7
AP21.1    AP220     AP23.1    AP25.1    AP25.2    AP26.1
AP27.1    AP30.2    AP30.4    AP300     AP305     API1.1
API2.1    BL120     BL122     BL130     BL20.1    BL20.3
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL820
BL92.1    IC130     MA180     MA310     MA41.1    MA41.2
MA41.4    MA41.7    MA43.1    MA43.2    MA43.3    MA43.4
MA43.6    MA43.7    MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA63.1    MA65.1    MA66.2    MA66.3
MA67.2    MA67.3    MA68.2    MA68.3    MA68.5    MA70.1
MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2    PD130
PD20.1    PD20.2    PD20.3    PO100     PO101     PO122
PO131     PO135     PO136     PO190     PO20.1    PO21.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO23.1
PO24.1    PO25.1    PO25.5    PO25.6    PO25.7    PO26.1
PO27.2    PO29.1    PO30.1    PO30.2    PO30.3    PO300
PO31.1    PO31.2    PO32.1    PO32.2    PO32.4    PO33.1
PO34.1    PO35.1    PO36.1    PO36.2    PO38.1    PO39.1
PO39.2    PO44.1    PO50.1    PO52.1    PO520     PO536
POD0.1    POI3.1    POID.1    POIF.1    POII.1    POIJ.1
RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ12.1    RQ13.1
RQ13.2    RQ35.1    RQ500     RQD0.1    RQIF.1    WH130
WH132     WH190     WH20.2    WH20.7    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     RQ300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MMD-COMPANY            Numeric 4                                 AM19.1  AM19.2
Element: Company       The company number.                       AP115   AP125
                                                                 AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-SYSTEM-CD          Alpha 2                                   AM19.1  AM19.2
Element: System Cd     This field indicates on what system the   AP115   AP125
                       transaction originated.                   AP126   AP131
                       IC = INVENTORY-CONTROL                    AP20.1  AP20.2
                       PO = PURCHASE-ORDER                       AP20.3  AP20.4
                       RQ = REQUISITIONS                         AP20.5  AP20.7
                       AP = Accounts Payable                     AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-LOCATION           Alpha 5                                   AM19.1  AM19.2
Element: Location      This field contains a valid stock         AP115   AP125
                       location within the company inventory.    AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-DOC-TYPE           Alpha 2                                   AM19.1  AM19.2
Element: Doc Type      This field contains the type of           AP115   AP125
                       transaction.                              AP126   AP131
                       AJ = Adjustment                           AP20.1  AP20.2
                       AR = Receiving Archive                    AP20.3  AP20.4
                       CA = Cost Adjustment                      AP20.5  AP20.7
                       CR = Customer Return                      AP21.1  AP220
                       DT = Direct Transfer                      AP23.1  AP25.1
                       IN = Invoice Details                      AP25.2  AP26.1
                       IS = Issue                                AP27.1  AP30.2
                       IT = Transfer Issue                       AP30.4  AP305
                       PA = Price Agreement                      API1.1  API2.1
                       PI = Physical Inventory Adjustment        BL120   BL122
                       PO = PO Receiving                         BL130   BL20.1
                       PT = Purchase Order Template-New PO       BL20.3  BL21.2
                       RA = Receiving Adjustment                 BL21.5  BL29.1
                       RC = Receipt                              BL29.2  BL520
                       RJ = Inspection Reject                    BL820   BL92.1
                       RR = Requisition Return                   IC130   MA180
                       RT = Receiving Transfer                   MA310   MA41.1
                       VA = Vendor Return Adjustment             MA41.2  MA41.4
                       VR = Vendor Return                        MA41.7  MA43.1
                       IF = Interface                            MA43.2  MA43.3
                       RQ = Requisition                          MA43.4  MA43.6
                       AC = Accepted Inspection                  MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-DOC-NUMBER         Alpha 14  (Right Justified)               AM19.1  AM19.2
Element: Doc Number                                              AP115   AP125
                                                                 AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-DOC-NBR-NUM        Numeric 10                                AM19.1  AM19.2
Element: Doc Nbr Num   This field contains the number for the    AP115   AP125
                       document tied to the distribution if a    AP126   AP131
                       numeric document.                         AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-PO-CODE            Alpha 4                                   AM19.1  AM19.2
Element: Po Code       This is the purchase order code.          AP115   AP125
                                                                 AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-LINE-NBR           Numeric 6                                 AM19.1  AM19.2
Element: Line Nbr      This field contains the line number.      AP115   AP125
                                                                 AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-COMPONENT-SEQ      Numeric 3                                 AM19.1  AM19.2
Element: Seq           This field contains the record sequence   AP115   AP125
                       number.                                   AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-LINE-SEQ           Numeric 3                                 AM19.1  AM19.2
Element: Seq           Sequence number within a line number.     AP115   AP125
                                                                 AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-AOC-CODE           Alpha 2                                   AM19.1  AM19.2
Element: Aoc Code      This field contains the identifier for    AP115   AP125
                       the add-on cost associated with this      AP126   AP131
                       line item.                                AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-REQ-LOCATION       Alpha 5                                   AM19.1  AM19.2
Element: Req Location  The location requisitioning items.        AP115   AP125
                       This location can be an inventory or      AP126   AP131
                       noninventory location.                    AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-ACCT-UNIT          Alpha 15                                  AM19.1  AM19.2
Element: Acct Unit     The accounting unit is a shorthand        AP115   AP125
                       notation representing the variable level  AP126   AP131
                       number. When used in the General Ledger   AP20.1  AP20.2
                       account master file, the accounting unit  AP20.3  AP20.4
                       must be defined in the General Ledger     AP20.5  AP20.7
                       names file as a posting accounting unit.  AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-ACCOUNT            Numeric 6                                 AM19.1  AM19.2
Element: Account       This field along with the accounting      AP115   AP125
                       unit and subaccount make up the location  AP126   AP131
                       (account) where amounts and other         AP20.1  AP20.2
                       account information is stored.            AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-SUB-ACCT           Numeric 4                                 AM19.1  AM19.2
Element: Sub Acct      This field contains the subaccount from   AP115   AP125
                       your general ledger chart of accounts     AP126   AP131
                       that was charged with the amount carried  AP20.1  AP20.2
                       on this record.                           AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-DIST-COMPANY       Numeric 4                                 AM19.1  AM19.2
Element: Company       The company number used for posting the   AP115   AP125
                       transaction. A valid intercompany         AP126   AP131
                       relationship must be defined in General   AP20.1  AP20.2
                       Ledger.                                   AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-ACTIVITY           Alpha 15                                  AM19.1  AM19.2
Element: Activity      Activities are the processes or           AP115   AP125
                       procedures that produce work. Cost        AP126   AP131
                       objects (products, services, customers,   AP20.1  AP20.2
                       and so on) are the reasons for            AP20.3  AP20.4
                       performing the activity. Activities and   AP20.5  AP20.7
                       cost object activities are used           AP21.1  AP220
                       synonymously in Project Accounting.       AP23.1  AP25.1
                       Direct costs are posted to activities,    AP25.2  AP26.1
                       and indirect costs are allocated to       AP27.1  AP30.2
                       activities based on activity drivers.     AP30.4  AP305
                                                                 API1.1  API2.1
                       Activities are grouped or organized by    BL120   BL122
                       activity levels. There are two types of   BL130   BL20.1
                       activities: "posting allowed" and         BL20.3  BL21.2
                       "summary only." Use posting level         BL21.5  BL29.1
                       activities to budget and maintain all     BL29.2  BL520
                       posted transactions. Summary activities   BL820   BL92.1
                       or macro activities combine information   IC130   MA180
                       and balances from lower level activities  MA310   MA41.1
                       for reporting and inquiries.              MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-ACCT-CATEGORY      Alpha 5                                   AM19.1  AM19.2
Element: Acct Category Account categories are groupings of       AP115   AP125
                       costs, revenues, or a combination of      AP126   AP131
                       both used for reporting and inquiries     AP20.1  AP20.2
                       for activities in Project Accounting.     AP20.3  AP20.4
                       All transactions are posted to an         AP20.5  AP20.7
                       account category within an activity. You  AP21.1  AP220
                       can assign a specific general ledger      AP23.1  AP25.1
                       account or range of accounts (company,    AP25.2  AP26.1
                       accounting unit, account, and             AP27.1  AP30.2
                       subaccount) that make up the              AP30.4  AP305
                       transactions posted to an account         API1.1  API2.1
                       category using Account Assignment         BL120   BL122
                       (AC07.1).                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                       Period-to-date, year-to-date, and         BL21.5  BL29.1
                       life-to-date balances are maintained by   BL29.2  BL520
                       account category for activities. Account  BL820   BL92.1
                       categories must be assigned to            IC130   MA180
                       activities before you do any budgeting    MA310   MA41.1
                       or transaction processing.                MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-BILL-CATEGORY      Alpha 32                                  AM19.1  AM19.2
Element: Bill Category                                           AP115   AP125
                                                                 AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-ASSET-TEMPLATE     Alpha 10                                  AM19.1  AM19.2
Element: Asset TemplateA user-defined asset template             AP115   AP125
                       identifies general asset creation         AP126   AP131
                       parameters that you can use to quickly    AP20.1  AP20.2
                       add assets with minimal keying. Using a   AP20.3  AP20.4
                       template lets you default many data       AP20.5  AP20.7
                       items associated with a new asset.        AP21.1  AP220
                                                                 AP23.1  AP25.1
                       You can use an asset template to          AP25.2  AP26.1
                       process quick asset additions in Quick    AP27.1  AP30.2
                       Addition (AM20.1) and to create assets    AP30.4  AP305
                       and asset books from Accounts Payable     API1.1  API2.1
                       and Project Accounting interface          BL120   BL122
                       information. Asset templates are          BL130   BL20.1
                       required if you define new assets as a    BL20.3  BL21.2
                       result of transactions interfaced from    BL21.5  BL29.1
                       Purchase Order or Accounts Payable.       BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-ASSET              Numeric 10                                AM19.1  AM19.2
Element: Asset         The asset number contains up to ten       AP115   AP125
                       numeric characters that uniquely          AP126   AP131
                       identify an asset. Assets are             AP20.1  AP20.2
                       automatically numbered system-wide.       AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-DIST-PERCENT       Signed 6.3                                AM19.1  AM19.2
Element: Total Percent This field indicates the percent of the   AP115   AP125
                       extended value of the line that is        AP126   AP131
                       associated with this account, if the      AP20.1  AP20.2
                       breakdown is by percent.  100 % is        AP20.3  AP20.4
                       stored as 100.000.                        AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-DIST-QTY           Signed 13.4                               AM19.1  AM19.2
Element: Quantity      This field contains the desired           AP115   AP125
                       quantity.                                 AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-DIST-AMOUNT        Signed 18.2                               AM19.1  AM19.2
Element: Intl Amt      This is the total amount posted to the    AP115   AP125
                       general ledger for this account. This     AP126   AP131
                       field is used for drillback information   AP20.1  AP20.2
                       to transactions from Inventory Control    AP20.3  AP20.4
                       and inventory and received not invoiced   AP20.5  AP20.7
                       items from Purchase Order.                AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-POSTING-TYPE       Alpha 2                                   AM19.1  AM19.2
Element: Posting Type  For distribution records posted from      AP115   AP125
                       Inventory Control, this field indicates   AP126   AP131
                       if the postings were to the inventory     AP20.1  AP20.2
                       account or offset accounts.               AP20.3  AP20.4
                       I1 = Inventory                            AP20.5  AP20.7
                       O1 = Offset                               AP21.1  AP220
                       E1 = RNI Expense Account                  AP23.1  AP25.1
                       RN = Received Not Invoiced                AP25.2  AP26.1
                       MN = Matched Not Received                 AP27.1  AP30.2
                       A = Add On Cost                           AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-STATUS             Numeric 1                                 AM19.1  AM19.2
Element: Status        This field displays the status of the     AP115   AP125
                       transaction.                              AP126   AP131
                       0 = Unposted                              AP20.1  AP20.2
                       1 = Posted                                AP20.3  AP20.4
                       2 = Not to be Posted                      AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-POSTED-DATE        Numeric 8  (yyyymmdd)                     AM19.1  AM19.2
Element: Posted Date   Date posted to the General Ledger         AP115   AP125
                       system.                                   AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-POSTED-TIME        Numeric 6  (hhmmss)                       AM19.1  AM19.2
Element: Sys Time      Time posted to the General Ledger         AP115   AP125
                       system.                                   AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-GLT-OBJ-ID         Numeric 12                                AM19.1  AM19.2
Element: Obj Id        This is a subsystem General Ledger        AP115   AP125
                       interface identification number. It is    AP126   AP131
                       used for Drill Around purposes.           AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                       In addition, if a GL Commmitment is       AP20.5  AP20.7
                       written to the GLCOMMITX file from RQ or  AP21.1  AP220
                       PO, then the GLT-OBJ-ID assigned by the   AP23.1  AP25.1
                       GL system is placed in the MMDIST record  AP25.2  AP26.1
                       and the GLCOMMITX record. The GLT-OBJ-ID  AP27.1  AP30.2
                       on the MMDIST record is used later via    AP30.4  AP305
                       PO and AP as a key to remove a            API1.1  API2.1
                       corresponding GLCOMMITX record.           BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-ATN-OBJ-ID         Numeric 12                                AM19.1  AM19.2
Element: Obj Id        This field is used to link general        AP115   AP125
                       ledger distributions in the Purchase      AP126   AP131
                       Order system to activities in the         AP20.1  AP20.2
                       Activity  Management system. The field    AP20.3  AP20.4
                       allows drill backs to the distribution    AP20.5  AP20.7
                       records from the activities.              AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-API-OBJ-ID         Numeric 12                                AM19.1  AM19.2
Element: Obj Id        This is the object identifier. It is      AP115   AP125
                       used to relate commitments or posted      AP126   AP131
                       transactions back to the originating      AP20.1  AP20.2
                       subsystems. Each subsystem record that    AP20.3  AP20.4
                       is updated as a commitment or posted      AP20.5  AP20.7
                       transaction is assigned an object         AP21.1  AP220
                       identifier. The object identifier is      AP23.1  AP25.1
                       maintained in the subsystem files and in  AP25.2  AP26.1
                       the Activity Commitments Detail and       AP27.1  AP30.2
                       Activity Transaction files. The object    AP30.4  AP305
                       identifier is a unique key used to drill  API1.1  API2.1
                       back from Activity Management to the      BL120   BL122
                       subsystems.                               BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-PULL-FOR-FR-FL     Alpha 1                                   AM19.1  AM19.2
Element: Pull For Fr FlIf Y-Yes the user has specified to        AP115   AP125
                       process transactions to a retail          AP126   AP131
                       financial reporting extract file.         AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

MMD-RNI-OBJ-ID         Numeric 12                                AM19.1  AM19.2
Element: Obj Id        This is the object identifier. It is      AP115   AP125
                       used to relate commitments or posted      AP126   AP131
                       transactions back to the originating      AP20.1  AP20.2
                       subsystems. Each subsystem record that    AP20.3  AP20.4
                       is updated as a commitment or posted      AP20.5  AP20.7
                       transaction is assigned an object         AP21.1  AP220
                       identifier. The object identifier is      AP23.1  AP25.1
                       maintained in the subsystem files and in  AP25.2  AP26.1
                       the Activity Commitments Detail and       AP27.1  AP30.2
                       Activity Transaction files. The object    AP30.4  AP305
                       identifier is a unique key used to drill  API1.1  API2.1
                       back from Activity Management to the      BL120   BL122
                       subsystems.                               BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC130   MA180
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 ...

                         MMDIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MMDSET1   COMPANY                                                AM19.1  AM19.2
          SYSTEM-CD                                              AP115   AP125
          LOCATION                                               AP126   AP131
          DOC-TYPE                                               AP20.1  AP20.2
          DOC-NUMBER                                             AP20.3  AP20.4
          DOC-NBR-NUM                                            AP20.5  AP20.7
          PO-CODE                                                AP21.1  AP220
          LINE-NBR                                               AP23.1  AP25.1
          COMPONENT-SEQ                                          AP25.2  AP26.1
          AOC-CODE                                               AP27.1  AP30.2
          LINE-SEQ                                               AP30.4  AP305
          REQ-LOCATION                                           API1.1  API2.1
          API-OBJ-ID                                             BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 ...

MMDSET10  COMPANY       Subset
          SYSTEM-CD     Where (PULL-FOR-FR-FL = "Y" )
          LOCATION
          DOC-TYPE
          DOC-NUMBER
          DOC-NBR-NUM
          PO-CODE
          LINE-NBR
          COMPONENT-SEQ
          AOC-CODE
          LINE-SEQ
          REQ-LOCATION
          API-OBJ-ID

MMDSET11  COMPANY       KeyChange                                AP125   AP126
          SYSTEM-CD                                              AP131   AP20.1
          LOCATION                                               AP20.2  AP20.3
          DOC-TYPE                                               AP20.4  AP20.5
          DOC-NUMBER                                             AP20.7  AP21.1
          DOC-NBR-NUM                                            AP23.1  AP25.1
          PO-CODE                                                AP25.2  AP26.1
          LINE-NBR                                               AP27.1  AP30.4
          COMPONENT-SEQ                                          API1.1  BL120
          AOC-CODE                                               BL122   BL130
          LINE-SEQ                                               BL20.1  BL20.3
          API-OBJ-ID                                             BL21.2  BL21.5
          REQ-LOCATION                                           BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  MA180
                                                                 ...

MMDSET12  RNI-OBJ-ID    KeyChange, Subset                        PO278   MM280
          COMPANY       Where RNI-OBJ-ID != Zeroes               MM80.1  MM80.2
          SYSTEM-CD
          LOCATION
          DOC-TYPE
          DOC-NUMBER
          DOC-NBR-NUM
          LINE-NBR
          COMPONENT-SEQ
          LINE-SEQ

MMDSET2   ATN-OBJ-ID    KeyChange, Subset
          COMPANY       Where ATN-OBJ-ID != Zeroes
          SYSTEM-CD
          LOCATION
          DOC-TYPE
          DOC-NUMBER
          DOC-NBR-NUM
          LINE-NBR
          COMPONENT-SEQ
          LINE-SEQ

MMDSET3   GLT-OBJ-ID    KeyChange, Subset                        MM280   MM80.1
          COMPANY       Where GLT-OBJ-ID != Zeroes               MM80.2
          SYSTEM-CD
          LOCATION
          DOC-TYPE
          DOC-NUMBER
          DOC-NBR-NUM
          LINE-NBR
          COMPONENT-SEQ
          LINE-SEQ

MMDSET4   COMPANY       Subset                                   AM17.1  AM19.1
          DOC-NUMBER    Where SYSTEM-CD = "PO"                   AM19.2  AP115
          DOC-NBR-NUM   And   DOC-TYPE  = "PT"                   AP125   AP126
          PO-CODE       And   LINE-SEQ  < 997                    AP131   AP20.1
          LINE-NBR                                               AP20.2  AP20.3
          AOC-CODE                                               AP20.4  AP20.5
          LINE-SEQ                                               AP20.7  AP21.1
                                                                 AP220   AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP305   API1.1
                                                                 API2.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 ...

MMDSET5   COMPANY       Subset                                   AM17.1  AM19.1
          API-OBJ-ID    Where SYSTEM-CD = "AP"                   AM19.2  AP115
          LINE-NBR                                               AP125   AP126
          AOC-CODE                                               AP131   AP20.1
          LINE-SEQ                                               AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP220   AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP300   AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

MMDSET6   COMPANY       KeyChange, Subset                        BL120   BL122
          SYSTEM-CD     Where DOC-TYPE = "IF"                    BL130   BL20.1
          DOC-NUMBER                                             BL20.3  BL21.2
          DOC-NBR-NUM                                            BL21.5  BL29.1
          REQ-LOCATION                                           BL29.2  BL520
          LINE-NBR                                               BL820   BL92.1
          LINE-SEQ                                               PO100   PO23.1
                                                                 WH20.2  WH20.7

MMDSET7   COMPANY       Subset                                   AM19.1  AM19.2
          SYSTEM-CD     Where  STATUS    =  Zeroes               AP115   AP125
          DOC-TYPE      And  ((SYSTEM-CD =  "PO" )               AP126   AP131
          DOC-NUMBER    And   (DOC-TYPE  != "VA" )               AP20.1  AP20.2
          DOC-NBR-NUM   And   (DOC-TYPE  != "VR" ))              AP20.3  AP20.4
          LINE-NBR      Or   ((SYSTEM-CD =  "RQ" )               AP20.5  AP20.7
          LINE-SEQ      And   (DOC-TYPE  =  "IS" )               AP21.1  AP220
                        Or    (DOC-TYPE  =  "RR" ))              AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 ...

MMDSET8   COMPANY       Subset                                   AP125   AP126
          DOC-NBR-NUM   Where SYSTEM-CD = "RQ"                   AP131   AP20.1
          LINE-NBR      And   DOC-TYPE  = "RQ"                   AP20.2  AP20.3
          LINE-SEQ                                               AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  MA180
                                                                 ...

MMDSET9   COMPANY       Subset                                   BL92.1  MA531
          SYSTEM-CD     Where (SYSTEM-CD = "PO"                  PO30.1  PO30.2
          DOC-TYPE      And    DOC-TYPE  = "PT"                  PO30.3  PO300
          DOC-NUMBER    And    LINE-SEQ  < 997 )                 PO33.1  PO34.1
          DOC-NBR-NUM   Or    (SYSTEM-CD = "RQ"                  PO39.2  PO52.1
          PO-CODE       And    DOC-TYPE  = "RQ" )                POIF.1  POIG.1
          LINE-NBR                                               POIM.1  WH130
          AOC-CODE                                               WH132   WH190
          LINE-SEQ                                               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
                                                                 ...

                         MMDIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glmaster       GLMASTER     Required

                            MMD-COMPANY          -> GLM-COMPANY
                            MMD-ACCT-UNIT        -> GLM-ACCT-UNIT
                            MMD-ACCOUNT          -> GLM-ACCOUNT
                            MMD-SUB-ACCT         -> GLM-SUB-ACCOUNT

Ictrans        ICTRANS      Required
                            When MMD-SYSTEM-CD = "IC"

                            MMD-COMPANY          -> ICT-COMPANY
                            MMD-LOCATION         -> ICT-LOCATION
                            MMD-DOC-TYPE         -> ICT-DOC-TYPE
                            MMD-SYSTEM-CD        -> ICT-SYSTEM-CD
                            MMD-DOC-NUMBER       -> ICT-DOCUMENT
                            MMD-DOC-NBR-NUM      -> ICT-SHIPMENT-NBR
                            MMD-LINE-NBR         -> ICT-LINE-NBR
                            MMD-COMPONENT-SEQ    -> ICT-COMPONENT-SEQ

Poaocdtl       POAOCDTL     Required
                            When MMD-SYSTEM-CD = "PO"
                            And  MMD-DOC-TYPE  = "PT"

                            MMD-COMPANY          -> PAO-COMPANY
                            Spaces               -> PAO-PROCURE-GROUP
                            Spaces               -> PAO-VEN-AGRMT-REF
                            MMD-DOC-NUMBER       -> PAO-PO-NUMBER
                            MMD-DOC-NBR-NUM      -> PAO-PO-RELEASE
                            MMD-PO-CODE          -> PAO-PO-CODE
                            MMD-LINE-NBR         -> PAO-LINE-NBR
                            MMD-AOC-CODE         -> PAO-AOC-CODE

Poline         POLINE       Required
                            When MMD-SYSTEM-CD = "PO"
                            And  MMD-DOC-TYPE  = "PT"

                            MMD-COMPANY          -> PLI-COMPANY
                            MMD-DOC-NUMBER       -> PLI-PO-NUMBER
                            MMD-DOC-NBR-NUM      -> PLI-PO-RELEASE
                            MMD-PO-CODE          -> PLI-PO-CODE
                            MMD-LINE-NBR         -> PLI-LINE-NBR

Porecline      PORECLINE    Required
                            When (MMD-DOC-TYPE = "PO" )

                            MMD-COMPANY          -> PRL-COMPANY
                            MMD-DOC-NUMBER       -> PRL-REC-NUMBER-A
                            MMD-LINE-NBR         -> PRL-LINE-NBR

Poreturnhd     PORETURNHD   Required
                            When MMD-DOC-TYPE = "VR"

                            MMD-COMPANY          -> PTH-COMPANY
                            MMD-DOC-NBR-NUM      -> PTH-RETURN-NUMBER

Poreturnln     PORETURNLN   Required
                            When MMD-DOC-TYPE = "VR"

                            MMD-COMPANY          -> PTL-COMPANY
                            MMD-DOC-NBR-NUM      -> PTL-RETURN-NUMBER
                            MMD-LINE-NBR         -> PTL-RET-LINE-NBR

Purchorder     PURCHORDER   Required
                            When MMD-SYSTEM-CD = "PO"
                            And  MMD-DOC-TYPE  = "PT"

                            MMD-COMPANY          -> PCR-COMPANY
                            MMD-PO-CODE          -> PCR-PO-CODE
                            MMD-DOC-NUMBER       -> PCR-PO-NUMBER
                            MMD-DOC-NBR-NUM      -> PCR-PO-RELEASE

Reqline        REQLINE      Required

                            MMD-COMPANY          -> RLN-COMPANY
                            MMD-DOC-NBR-NUM      -> RLN-REQ-NUMBER
                            MMD-LINE-NBR         -> RLN-LINE-NBR

Reqline2       REQLINE      Required

                            MMD-COMPANY          -> RLN-COMPANY
                            MMD-DOC-NUMBER       -> RLN-REQ-NUMBER-A
                            MMD-LINE-NBR         -> RLN-LINE-NBR

Reqline3       REQLINE      Required
                            When MMD-COMPANY != MMD-DIST-COMPANY

                            MMD-DIST-COMPANY     -> RLN-COMPANY
                            MMD-DOC-NUMBER       -> RLN-REQ-NUMBER-A
                            MMD-LINE-NBR         -> RLN-LINE-NBR

Reqline9       REQLINE      Required

                            MMD-COMPANY          -> RLN-FROM-COMPANY
                            MMD-DOC-NUMBER       -> RLN-REQ-NUMBER-A
                            MMD-LINE-NBR         -> RLN-LINE-NBR

                         MMDIST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sltrans        SLTRANS

                            MMD-GLT-OBJ-ID       -> SLT-GLT-OBJ-ID
                                                    SLT-OBJ-ID