Lawson Insight Technical Documentation

                             MAAOIHIST FILE

UPDATED BY

AP115     AP180     AP181     AP190     AP198     AP28.1
AP28.2    AP30.4    AP300     AP305     AP45.1

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.           AP30.4  AP305



MH2-INVOICE          Alpha 22                                    AP115   AP198
Invoice Number       Used to identify the invoice.               AP30.4  AP305

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                                                AP28.1  AP28.2
          SUFFIX                                                 AP30.4  AP300
          PO-NUMBER                                              AP305   AP45.1
          PO-RELEASE
          PO-CODE

                         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