Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MAINVDTL


                             MAINVDTL FILE

                        Matching Invoice Detail

The Matching Invoice Detail file contains line item, miscellaneous add on
cost, and line item add on cost approval information by invoice and purchase
order.

REFERENCED BY

AP295     MA126     MA167     MA236     MA310     MA540
MA69.1    MA69.2    MA69.3    MA69.4    MA69.5    MA69.6
MA90.1    MA90.2    MA90.3    MA90.5    PO136     PO278
POA3.1    MM280     MM80.1    MM80.2    MA278     PO135
PO139     PO64.1    PO295     POD0.1    MA168     PO58.2


UPDATED BY

AM19.1    AM19.2    AP115     AP125     AP126     AP131
AP180     AP181     AP190     AP195     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    AP28.1
AP28.2    AP30.2    AP30.4    AP300     AP305     AP45.1
API1.1    API2.1    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    BL520
BL820     BL92.1    MA180     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.4
MA60.5    MA61.1    MA63.1    MA64.6    MA65.1    MA66.2
MA66.3    MA67.2    MA67.3    MA68.2    MA68.3    MA68.4
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     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    PO27.2    PO29.1
PO30.1    PO30.2    PO30.3    PO300     PO31.1    PO31.2
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     POI3.1    POID.1    POII.1
POIJ.1    RQ10.1    RQ10.2    WH20.2    WH20.7    AP198


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MAD-COMPANY            Numeric 4                                 AM19.1  AM19.2
Element: Company       Identifies the AP company if the          AP115   AP125
                       resource type = V.  Identifies the HR     AP126   AP131
                       company if the resource type = E.  It is  AP180   AP181
                       blank for type A, P or Q resources.       AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-VENDOR             Alpha 9  (Right Justified)                AM19.1  AM19.2
Element: Vendor        The vendor's identification code.         AP115   AP125
                                                                 AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-INVOICE            Alpha 22                                  AM19.1  AM19.2
Element: Invoice       Used to identify the invoice.             AP115   AP125
                                                                 AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-SUFFIX             Numeric 3                                 AM19.1  AM19.2
Element: Suffix        This is the suffix for the invoice.       AP115   AP125
                                                                 AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-PO-NUMBER          Alpha 14  (Right Justified)               AM19.1  AM19.2
Element: Po Number     This field contains the number            AP115   AP125
                       representing the purchase order.          AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-PO-RELEASE         Numeric 4                                 AM19.1  AM19.2
Element: Po Release    Used to identify a purchase order         AP115   AP125
                       release (created from a Blanket or        AP126   AP131
                       Standing order).                          AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-PO-CODE            Alpha 4                                   AM19.1  AM19.2
Element: Purchase OrderPurchase order number code. Used to       AP115   AP125
                       keep purchase orders unique. Can also be  AP126   AP131
                       used for reporting purposes.              AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-LINE-NBR           Numeric 6                                 AM19.1  AM19.2
Element: Line Nbr      This field contains the line number.      AP115   AP125
                                                                 AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   MA236
                                                                 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
                                                                 ...

MAD-SEQ-NBR            Numeric 4                                 AM19.1  AM19.2
Element: Seq Nbr       An automatically assigned sequence        AP115   AP125
                       number.                                   AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-ITEM-TYPE          Alpha 1                                   AM19.1  AM19.2
Element: Item Type     This field identifies the line item       AP115   AP125
                       type.                                     AP126   AP131
                                                                 AP180   AP181
                       I = Inventoried                           AP190   AP20.1
                       N = Non-stock                             AP20.2  AP20.3
                       S = Service                               AP20.4  AP20.5
                       X = Special                               AP20.7  AP21.1
                                                                 AP220   AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-ITEM               Alpha 32                                  AM19.1  AM19.2
Element: Item          This field contains the item              AP115   AP125
                       identifier.                               AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-VEN-ITEM           Alpha 32                                  AM19.1  AM19.2
Element: Item          This field contains the item              AP115   AP125
                       identifier.                               AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-ITEM-DESC          Alpha 30  (Lower Case)                    AM19.1  AM19.2
Element: Description   This field displays the description.      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
                                                                 MA180   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
                                                                 ...

MAD-MATCHED-QTY        Signed 13.4                               AM19.1  AM19.2
Element: Matched QuantiThe quantity of items that have been      AP115   AP125
                       matched.                                  AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-MATCH-UNIT-CST     Signed 18.5                               AM19.1  AM19.2
Element: Intl Cost     THis unit cost is updated at match        AP115   AP125
                                                                 AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-VPRI-UOM           Alpha 4                                   AM19.1  AM19.2
Element: Uom           This field contains the valid stock       AP115   AP125
                       unit of measure for this item.            AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-VPRI-UOM-MULT      Signed 13.7                               AM19.1  AM19.2
Element: Uom Mult      This field contains the multiplier for    AP115   AP125
                       converting this unit of measure to the    AP126   AP131
                       stock unit of measure.                    AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-ENTERED-QTY        Signed 13.4                               AM19.1  AM19.2
Element: Quantity      THis is the VBUY quantity                 AP115   AP125
                                                                 AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-ENT-UNIT-CST       Signed 18.5                               AM19.1  AM19.2
Element: Intl Cost     The entered unit cost in vendor price     AP115   AP125
                       unit of measure terms.  This value may    AP126   AP131
                       be entered on line or calculated from     AP180   AP181
                       entry of cost in buy unit of measure      AP190   AP20.1
                       terms.                                    AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP220   AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-TAX-CODE           Alpha 10                                  AM19.1  AM19.2
Element: Tax Code      This field contains a code representing   AP115   AP125
                       specific tax information.  This must be   AP126   AP131
                       valid Tax Code.                           AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-TAX-TYPE           Alpha 1                                   AM19.1  AM19.2
Element: Tax Type      The type of tax.                          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
                                                                 MA180   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
                                                                 ...

MAD-TAX-AMOUNT         Signed 18.2                               AM19.1  AM19.2
Element: Intl Amt      The tax amount for the invoice.           AP115   AP125
                                                                 AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-VBUY-MATCH-QTY     Signed 13.4                               AM19.1  AM19.2
Element: Matched QuantiThe quantity of items that have been      AP115   AP125
                       matched in VBUY measure terms.            AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-VBUY-UOM           Alpha 4                                   AM19.1  AM19.2
Element: Uom           This field contains the valid stock       AP115   AP125
                       unit of measure for this item.            AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-VBUY-UOM-MULT      Signed 13.7                               AM19.1  AM19.2
Element: Uom Mult      This field contains the multiplier for    AP115   AP125
                       converting this unit of measure to the    AP126   AP131
                       stock unit of measure.                    AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-NO-TAX-FLAG        Alpha 1                                   AM19.1  AM19.2
Element: Taxable InvoicIndicates if the invoice is taxable.      AP115   AP125
                       N = No                                    AP126   AP131
                       Y = Yes                                   AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-MATCH-CLASS        Alpha 10                                  AM19.1  AM19.2
Element: Match Class   Match class. A user-defined matching      AP115   AP125
                       key structure consisting of matching      AP126   AP131
                       elements.                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-MATCH-DTL-KEY      Alpha 85                                  AM19.1  AM19.2
Element: Match Detail KMatch detail key. Combines all Matching   AP115   AP125
                       Elements into a single element.           AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-RTL-UNIT-COST      Signed 18.5                               AM19.1  AM19.2
Element: Retail Unit CoThe retail unit cost of the item.         AP115   AP125
                                                                 AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-LOCATION           Alpha 5                                   AM19.1  AM19.2
Element: Location      This field contains a valid stocking      AP115   AP125
                       location within the company inventory.    AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-MATCH-OBJ-ID       Numeric 12                                AM19.1  AM19.2
Element: Matching ObjecA system generated matching object        AP115   AP125
                       identifier.                               AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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.4
                                                                 MA60.5  MA61.1
                                                                 ...

MAD-ENT-UOM            Alpha 4                                   AM19.1  AM19.2
Entered Unit of        Entered unit of measure.                  AP115   AP125
Measure                                                          AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-ENT-UOM-MULT       Signed 13.7                               AM19.1  AM19.2
Element: Uom Mult      This field contains the multiplier for    AP115   AP125
                       converting this unit of measure to the    AP126   AP131
                       stock unit of measure.                    AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-TRAN-ND            Numeric 1                                 AM19.1  AM19.2
Element: Acct Nd       The number of decimals assigned to a      AP115   AP125
                       particular account as determined by the   AP126   AP131
                       account currency.                         AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-REC-SOURCE         Alpha 2                                   AM19.1  AM19.2
Element: Record Source Indicates where the detail record was     AP115   AP125
                       created.                                  AP126   AP131
                                                                 AP180   AP181
                       Valid values are:                         AP190   AP20.1
                                                                 AP20.2  AP20.3
                       IN = Invoice                              AP20.4  AP20.5
                       "  " = PO Entry                           AP20.7  AP21.1
                       LM = Line Match (MA43)                    AP220   AP23.1
                       IM = internal match details               AP25.1  AP25.2
                       IS = Created by AOC spread from PO        AP26.1  AP27.1
                       "  " = PO Entry                           AP28.1  AP28.2
                       MA = Created within match                 AP30.2  AP30.4
                       MS = Generated by AOC spread              AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-TOT-DIST-AMT       Signed 18.2                               AM19.1  AM19.2
Total Distribution     The total amount of the distribution.     AP115   AP125
Amount                                                           AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-TOT-BASE-AMT       Signed 18.2                               AM19.1  AM19.2
Element: Total Base Amount                                       AP115   AP125
                                                                 AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-STATUS             Numeric 1                                 AM19.1  AM19.2
Element: Status        The transaction status.                   AP115   AP125
                                                                 AP126   AP131
                       Valid values are:                         AP180   AP181
                                                                 AP190   AP20.1
                       0 = Unmatched                             AP20.2  AP20.3
                       1 = Matched                               AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP220   AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-API-OBJ-ID         Numeric 12                                AM19.1  AM19.2
Element: API Object ID A subsystem object interface              AP115   AP125
                       identification number.                    AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-MA-REC-NBR         Numeric 10                                AM19.1  AM19.2
Element: Receipt NumberThe receipt number an invoice detail was  AP115   AP125
                       matched to in a detail match.             AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-MA-LINE-NBR        Numeric 6                                 AM19.1  AM19.2
Element: Receipt Line NReceipt line number.                      AP115   AP125
                                                                 AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-MATCH-SEQ-NBR      Numeric 4                                 AM19.1  AM19.2
Matching Sequence      Matching sequence number. Used to keep    AP115   AP125
Number                 records unique.                           AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-MTCH-EXC-PROC      Numeric 1                                 AM19.1  AM19.2
Element: Mtch Exc Proc 0 = No excess quantity                    AP115   AP125
                       1 = Chargeback                            AP126   AP131
                       2 = Write off                             AP180   AP181
                       3 = Matched no rec                        AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-INVOICE-TYPE       Alpha 1                                   AM19.1  AM19.2
Element: Invoice Type  THis field will be filled in from the     AP115   AP125
                       Invoice based on PO number.  This is a    AP126   AP131
                       carrier for the field.  The PORECEIVE     AP180   AP181
                       file will have to be updated with this    AP190   AP20.1
                       field.                                    AP20.2  AP20.3
                       C = Credit Memo                           AP20.4  AP20.5
                       " " = Regular                             AP20.7  AP21.1
                                                                 AP220   AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-DISTRIB-DATE       Numeric 8  (yyyymmdd)                     AM19.1  AM19.2
Element: Date          This field displays the system date       AP115   AP125
                       when this was created.                    AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   AP195
                                                                 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  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  MA180
                                                                 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
                                                                 ...

MAD-UPDATE-DATE        Numeric 8  (yyyymmdd)                     AM19.1  AM19.2
Element: Update Date   This field contains the date the record   AP115   AP125
                       was updated.                              AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-UPDATE-TIME        Numeric 6                                 AM19.1  AM19.2
Element: Update Time   This field contains the system time       AP115   AP125
                       when the record was updated.              AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-TAX-USAGE-CD       Alpha 10                                  AM19.1  AM19.2
Element: Tax Usage Cd  The tax usage coe for the vendor.  This   AP115   AP125
                       filed is required if the AP Company       AP126   AP131
                       inidcates that VAT reporting required.    AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-LAST-MSG-SEQ       Numeric 6                                 AM19.1  AM19.2
Element: Seq Number    A unique number assigned to each          AP115   AP125
                       transaction to be interfaced into the     AP126   AP131
                       Lawson system.                            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
                                                                 MA180   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
                                                                 MA64.6  MA65.1
                                                                 MA66.2  MA66.3
                                                                 MA67.2  MA67.3
                                                                 ...

MAD-ICN-CODE           Alpha 8                                   AM19.1  AM19.2
Element: Icn Code                                                AP115   AP125
                                                                 AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-SUPLMNTARY-QTY     Signed 13.4                               AM19.1  AM19.2
Element: Quantity      This field contains the desired           AP115   AP125
                       quantity.                                 AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-SUPLMNTARY-UOM     Alpha 4                                   AM19.1  AM19.2
Element: Uom           This field contains the valid stock       AP115   AP125
                       unit of measure for this item.            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
                                                                 MA180   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
                                                                 ...

MAD-WEIGHT             Signed 9.3                                AM19.1  AM19.2
Element: Weight        This field contains the unit weight of    AP115   AP125
                       the item based on the stocking UOM.       AP126   AP131
                                                                 AP180   AP181
                                                                 AP190   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
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   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
                                                                 ...

MAD-TERMS-CD           Alpha 5
Element: Terms Cd

MAD-DISC-RATE          Percent 5.3  (Percent)
Element: Disc Rate

MAD-DISC-DATE          Numeric 8  (yyyymmdd)
Element: Disc Date

MAD-FLEX-FLAG          Alpha 1
Element: Flex Flag     Terms has been overriden with a flexible
                       term

MAD-PREPAY-QTY         Signed 13.4
Element: Prepay Qty    For prepayment invoices this quantity
                       will be used

MAD-PRPY-UNIT-CST      Signed 18.5
Element: Intl Cost     For prepayment invoice this unit cost
                       will be used

MAD-PRPY-TAX-CODE      Alpha 10
Element: Prpy Tax Code For prepayment invoices this tax code
                       will be used

MAD-PRPY-TAX-AMT       Signed 18.2
Element: Intl Amt      FOr prepayment invoice this tax amount
                       will be used.

MAD-PRPY-RTL-UCST      Signed 18.5
Element: Intl Cost

MAD-PREPAY-DATE        Numeric 8  (yyyymmdd)
Element: Prepay Date

MAD-MATCH-ERR-TYPE     Numeric 2
Element: Match Err TypeThis is the reason the match was not
                       successful.
                       01 = cost error
                       02 = quantity error
                       03 = item error

MAD-CATCH-WGT-COST     Signed 18.5
Element: Intl Cost

MAD-REASON-CODE        Alpha 4                                   AM19.1  AM19.2
Element: Reason Code   This field contains the reason code,      AP115   AP125
                       which indicates the cause for credit      AP126   AP131
                       memos.                                    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
                                                                 MA180   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
                                                                 ...

MAD-CHARGEBACK-FL      Alpha 1
Element: Chargeback Fl THis flag notes that there is a
                       chargeback associated with this invoice
                       line.
                       0 = no
                       1 = yes

MAD-IR-DIFF-AMT        Signed 18.2
Element: Intl Amt

MAD-MATCH-EXT-COST     Signed 18.5
Element: Intl Cost     THis is the extended cost of the line
                       updated at match

MAD-AGREEMENT-REF      Alpha 30                                  MA43.1  MA43.4
Element: Agreement Ref This is for contracts(agreements) coming  MA43.6
                       from the PO system.  Used to denote
                       message with contract associated.

MAD-INVC-TAX-AMT       Signed 18.2                               AM19.1  AM19.2
Element: Intl Amt                                                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
                                                                 MA180   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
                                                                 ...

MAD-ACCR-TAX-AMT       Signed 18.2                               AM19.1  AM19.2
Element: Intl Amt                                                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
                                                                 MA180   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
                                                                 ...

MAD-COMMODITY-CODE     Alpha 35                                  API1.1  MA43.1
Element: Commodity Code                                          POI3.1

                         MAINVDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MADSET1   COMPANY                                                AM19.1  AM19.2
          VENDOR                                                 AP115   AP125
          INVOICE                                                AP126   AP131
          SUFFIX                                                 AP195   AP198
          PO-NUMBER                                              AP20.1  AP20.2
          PO-RELEASE                                             AP20.3  AP20.4
          PO-CODE                                                AP20.5  AP20.7
          LINE-NBR                                               AP21.1  AP220
          SEQ-NBR                                                AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP295
                                                                 AP30.2  AP30.4
                                                                 AP300   AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 ...

MADSET10  COMPANY       KeyChange, Subset                        AP30.4  MA278
          PO-NUMBER     Where STATUS = 1                         MA70.1  MA75.1
          PO-RELEASE                                             PO135   PO139
          PO-CODE                                                PO64.1
          LINE-NBR
          UPDATE-DATE*
          UPDATE-TIME*
          VENDOR
          INVOICE
          SUFFIX
          SEQ-NBR

MADSET2   COMPANY       KeyChange                                AM19.1  AM19.2
          PO-NUMBER                                              AP115   AP125
          PO-RELEASE                                             AP126   AP131
          PO-CODE                                                AP20.1  AP20.2
          LINE-NBR                                               AP20.3  AP20.4
          VENDOR                                                 AP20.5  AP20.7
          INVOICE                                                AP21.1  AP220
          SUFFIX                                                 AP23.1  AP25.1
          SEQ-NBR                                                AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 ...

MADSET3   COMPANY       KeyChange                                AM19.1  AM19.2
          API-OBJ-ID                                             AP115   AP125
          PO-NUMBER                                              AP126   AP131
          PO-RELEASE                                             AP20.1  AP20.2
          PO-CODE                                                AP20.3  AP20.4
          MATCH-DTL-KEY                                          AP20.5  AP20.7
          SEQ-NBR                                                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
                                                                 ...

MADSET4   COMPANY       KeyChange                                AM19.1  AM19.2
          VENDOR                                                 AP115   AP125
          INVOICE                                                AP126   AP131
          SUFFIX                                                 AP20.1  AP20.2
          PO-NUMBER                                              AP20.3  AP20.4
          PO-RELEASE                                             AP20.5  AP20.7
          PO-CODE                                                AP21.1  AP220
          ITEM                                                   AP23.1  AP25.1
          SEQ-NBR                                                AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 ...

MADSET8   COMPANY       KeyChange                                AM19.1  AM19.2
          API-OBJ-ID                                             AP115   AP125
          PO-NUMBER                                              AP126   AP131
          PO-RELEASE                                             AP20.1  AP20.2
          PO-CODE                                                AP20.3  AP20.4
          LOCATION                                               AP20.5  AP20.7
          MATCH-DTL-KEY                                          AP21.1  AP220
          LINE-NBR                                               AP23.1  AP25.1
          SEQ-NBR                                                AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 ...

MADSET9   COMPANY       KeyChange, Subset                        AM19.1  AM19.2
          MATCH-OBJ-ID  Where INVOICE-TYPE = Spaces              AP115   AP125
          MATCH-SEQ-NBR                                          AP126   AP131
          VENDOR                                                 AP20.1  AP20.2
          INVOICE                                                AP20.3  AP20.4
          SUFFIX                                                 AP20.5  AP20.7
          PO-NUMBER                                              AP21.1  AP220
          PO-RELEASE                                             AP23.1  AP25.1
          PO-CODE                                                AP25.2  AP26.1
          LINE-NBR                                               AP27.1  AP30.2
          SEQ-NBR                                                AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 ...

                         MAINVDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apbatch        APBATCH      Not Required

                            MAD-COMPANY          -> APB-COMPANY
                            API-BATCH-NUM        -> APB-BATCH-NUM

Apcompany      APCOMPANY    Required

                            MAD-COMPANY          -> CPY-COMPANY

Apinvoice      APINVOICE    Required

                            MAD-COMPANY          -> API-COMPANY
                            MAD-VENDOR           -> API-VENDOR
                            MAD-INVOICE          -> API-INVOICE
                            MAD-SUFFIX           -> API-SUFFIX
                            Zeroes               -> API-CANCEL-SEQ

Iccompany      ICCOMPANY    Required

                            MAD-COMPANY          -> ICC-COMPANY

Itemloc        ITEMLOC      Required

                            MAD-COMPANY          -> ITL-COMPANY
                            MAD-LOCATION         -> ITL-LOCATION
                            MAD-ITEM             -> ITL-ITEM

Itemmast       ITEMMAST     Required
                            When MAD-ITEM-TYPE = "I"
                            Or   MAD-ITEM-TYPE = "N"

                            ICC-ITEM-GROUP       -> ITE-ITEM-GROUP
                            MAD-ITEM             -> ITE-ITEM

Location       ICLOCATION   Required

                            MAD-COMPANY          -> ICL-COMPANY
                            MAD-LOCATION         -> ICL-LOCATION

Macompany      MACOMPANY    Required

                            MAD-COMPANY          -> MAY-COMPANY

Mapoinv        MAPOINV      Not Required

                            MAD-COMPANY          -> AOI-COMPANY
                            MAD-PO-NUMBER        -> AOI-PO-NUMBER
                            MAD-PO-RELEASE       -> AOI-PO-RELEASE
                            MAD-PO-CODE          -> AOI-PO-CODE
                            MAD-VENDOR           -> AOI-VENDOR
                            MAD-INVOICE          -> AOI-INVOICE
                            MAD-SUFFIX           -> AOI-SUFFIX

Mmuaval        MMUAVAL      Required

                            MAD-COMPANY          -> MUA-COMPANY
                            "AP"                 -> MUA-SYSTEM-CD
                            MAD-LOCATION         -> MUA-LOCATION
                            "IN"                 -> MUA-DOC-TYPE
                            Spaces               -> MUA-DOC-NUMBER
                            Zeroes               -> MUA-DOC-NBR-NUM
                            Spaces               -> MUA-PO-CODE
                            MAD-LINE-NBR         -> MUA-LINE-NBR
                            MAD-API-OBJ-ID       -> MUA-API-OBJ-ID
                            MAD-SEQ-NBR          -> MUA-SEQ-NBR

Pocompany      POCOMPANY    Required

                            MAD-COMPANY          -> PCY-COMPANY

Poline         POLINE       Not Required

                            MAD-COMPANY          -> PLI-COMPANY
                            MAD-PO-NUMBER        -> PLI-PO-NUMBER
                            MAD-PO-RELEASE       -> PLI-PO-RELEASE
                            MAD-PO-CODE          -> PLI-PO-CODE
                            MAD-LINE-NBR         -> PLI-LINE-NBR

Purchorder     PURCHORDER   Required

                            MAD-COMPANY          -> PCR-COMPANY
                            MAD-PO-CODE          -> PCR-PO-CODE
                            MAD-PO-NUMBER        -> PCR-PO-NUMBER
                            MAD-PO-RELEASE       -> PCR-PO-RELEASE

Vendor         APVENMAST    Required

                            CPY-VENDOR-GROUP     -> VEN-VENDOR-GROUP
                            MAD-VENDOR           -> VEN-VENDOR

                         MAINVDTL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apvendiv       APVENDIV

                            CPY-VENDOR-GROUP     -> VDC-VENDOR-GROUP
                            MAD-VENDOR           -> VDC-VENDOR
                            API-LOCATION         -> VDC-LOCATION-CODE
                                                    VDC-DIVERSE-CODE
                                                    VDC-DCERT-DATE

Maaocdtl       MAAOCDTL

                            MAD-COMPANY          -> MAA-COMPANY
                            MAD-VENDOR           -> MAA-VENDOR
                            MAD-INVOICE          -> MAA-INVOICE
                            MAD-SUFFIX           -> MAA-SUFFIX
                            MAD-PO-NUMBER        -> MAA-PO-NUMBER
                            MAD-PO-RELEASE       -> MAA-PO-RELEASE
                            MAD-PO-CODE          -> MAA-PO-CODE
                            MAD-LINE-NBR         -> MAA-LINE-NBR
                                                    MAA-AOC-CODE
                                                    MAA-SEQ-NBR

Mainvmsg       MAINVMSG

                            MAD-COMPANY          -> MAG-COMPANY
                            MAD-VENDOR           -> MAG-VENDOR
                            MAD-INVOICE          -> MAG-INVOICE
                            MAD-SUFFIX           -> MAG-SUFFIX
                            Zeroes               -> MAG-CANCEL-SEQ
                            MAD-SEQ-NBR          -> MAG-MAD-SEQ-NBR
                                                    MAG-SEQ-NBR

Mmdist         MMDIST
                            Valid When MAD-ITEM-TYPE != "I"

                            MAD-COMPANY          -> MMD-COMPANY
                            "PO"                 -> MMD-SYSTEM-CD
                            MAD-LOCATION         -> MMD-LOCATION
                            "PT"                 -> MMD-DOC-TYPE
                            MAD-PO-NUMBER        -> MMD-DOC-NUMBER
                            MAD-PO-RELEASE       -> MMD-DOC-NBR-NUM
                            MAD-PO-CODE          -> MMD-PO-CODE
                            MAD-LINE-NBR         -> MMD-LINE-NBR
                            Zeroes               -> MMD-COMPONENT-SEQ
                            Spaces               -> MMD-AOC-CODE
                                                    MMD-LINE-SEQ
                                                    MMD-REQ-LOCATION
                                                    MMD-API-OBJ-ID

Porecline      PORECLINE

                            MAD-COMPANY          -> PRL-COMPANY
                            MAD-PO-CODE          -> PRL-PO-CODE
                            MAD-PO-NUMBER        -> PRL-PO-NUMBER
                            MAD-PO-RELEASE       -> PRL-PO-RELEASE
                            MAD-LOCATION         -> PRL-LOCATION
                            MAD-MATCH-DTL-KEY    -> PRL-MATCH-DTL-KEY
                                                    PRL-PO-LINE-NBR
                                                    PRL-REC-NUMBER
                                                    PRL-LINE-NBR