Lawson Insight Technical Documentation

                             MAAOIHIST FILE

UPDATED BY

AP115     AP180     AP181     AP190     AP198     AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.7    AP23.1
AP25.2    AP26.1    AP27.1    AP28.1    AP28.2    AP30.4
AP300     AP305     AP45.1    MA41.2    MA43.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MH2-COMPANY          Numeric 4                                   AP198
Company              The company number represents an
                     established company and is entered on
                     all function codes.


MH2-PO-NUMBER        Alpha 14  (Right Justified)                 AP198
PO Number            This field contains the number
                     representing the purchase order.

MH2-PO-RELEASE       Numeric 4                                   AP198
PO Release Number    Used to identify a purchase order
                     release (created from a Blanket or
                     Standing order).

MH2-PO-CODE          Alpha 4                                     AP198
Po Code              This is the purchase order code.

MH2-VENDOR           Alpha 9  (Right Justified)                  AP115   AP198
Vendor ID            The vendor's identification code.           AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  AP305
                                                                 MA41.2  MA43.2

MH2-INVOICE          Alpha 22                                    AP115   AP198
Invoice Number       Used to identify the invoice.               AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  AP305
                                                                 MA41.2  MA43.2

MH2-SUFFIX           Numeric 3                                   AP198
Invoice Suffix       This is the suffix for the invoice.

MH2-MATCH-REF-NBR    Alpha 22                                    AP198
Match Ref Nbr

MH2-TAX-CODE         Alpha 10                                    AP198
Tax Code             This field contains a code representing
                     specific tax information.  This must be
                     valid Tax Code.


MH2-LOCATION         Alpha 5                                     AP198
Location Code        This field contains a valid stocking
                     location within the company inventory.

MH2-INVOICE-TYPE     Alpha 1                                     AP198
Invoice Type

                         MAAOIHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MH2SET1   COMPANY
          PO-NUMBER
          PO-RELEASE
          PO-CODE
          VENDOR
          INVOICE
          SUFFIX

MH2SET2   COMPANY                                                AP115   AP180
          VENDOR                                                 AP181   AP190
          INVOICE                                                AP20.1  AP20.2
          SUFFIX                                                 AP20.3  AP20.4
          PO-NUMBER                                              AP20.5  AP20.7
          PO-RELEASE                                             AP23.1  AP25.2
          PO-CODE                                                AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP300
                                                                 AP305   AP45.1
                                                                 MA41.2  MA43.2

                         MAAOIHIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apapihist      APAPIHIST    Required

                            MH2-COMPANY         -> AH1-COMPANY
                            MH2-VENDOR          -> AH1-VENDOR
                            MH2-INVOICE         -> AH1-INVOICE
                            MH2-SUFFIX          -> AH1-SUFFIX
                            Zeroes              -> AH1-CANCEL-SEQ

Apcompany      APCOMPANY    Required

                            MH2-COMPANY         -> CPY-COMPANY

Purchorder     PURCHORDER   Required

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

Vendor         APVENMAST    Required

                            CPY-VENDOR-GROUP    -> VEN-VENDOR-GROUP
                            MH2-VENDOR          -> VEN-VENDOR

                         MAAOIHIST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mamadhist      MAMADHIST

                            MH2-COMPANY         -> MH1-COMPANY
                            MH2-VENDOR          -> MH1-VENDOR
                            MH2-INVOICE         -> MH1-INVOICE
                            MH2-SUFFIX          -> MH1-SUFFIX
                            MH2-PO-NUMBER       -> MH1-PO-NUMBER
                            MH2-PO-RELEASE      -> MH1-PO-RELEASE
                            MH2-PO-CODE         -> MH1-PO-CODE
                                                   MH1-LINE-NBR
                                                   MH1-AOC-CODE
                                                   MH1-SEQ-NBR

Mamadhist All  MAMADHIST

                            MH2-COMPANY         -> MH1-COMPANY
                            MH2-VENDOR          -> MH1-VENDOR
                            MH2-INVOICE         -> MH1-INVOICE
                            MH2-SUFFIX          -> MH1-SUFFIX
                                                   MH1-PO-NUMBER
                                                   MH1-PO-RELEASE
                                                   MH1-PO-CODE
                                                   MH1-LINE-NBR
                                                   MH1-AOC-CODE
                                                   MH1-SEQ-NBR

Popsphist      POPSPHIST    Delete Cascades

                            MH2-COMPANY         -> PH1-COMPANY
                            MH2-INVOICE         -> PH1-PO-NUMBER
                                                   PH1-PO-RELEASE
                                                   PH1-PO-CODE
                                                   PH1-AOC-CODE
                                                   PH1-INVOICE