Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MAAOIHIST


                             MAAOIHIST FILE

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MH2-COMPANY            Numeric 4                                 AP198
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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

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

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

MH2-VENDOR             Alpha 9  (Right Justified)                AP115   AP198
Element: Vendor ID     The vendor's identification code.         AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 AP305

MH2-INVOICE            Alpha 22                                  AP115   AP198
Element: Invoice NumberUsed to identify the invoice.             AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 AP305

MH2-SUFFIX             Numeric 3                                 AP198
Element: Invoice SuffixThis is the suffix for the invoice.

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

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


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

MH2-INVOICE-TYPE       Alpha 1                                   AP198
Element: Invoice Type  THis field will be filled in from the
                       Invoice based on PO number.  This is a
                       carrier for the field.  The PORECEIVE
                       file will have to be updated with this
                       field.

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

                         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