Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MAPOINV


                              MAPOINV FILE

                        Matching Purchase Order

The Matching Purchase Order file contains header information for purchase
orders.

REFERENCED BY

AP125     AP126     AP131     IC28.1    MA01.1    MA180
MA530     MA531     MA540     MA60.2    MA60.3    MA60.5
MA61.1    MA66.2    MA66.3    MA67.1    MA67.2    MA70.1
MA75.1    MA80.1    MAI1.1    PO100     PO101     PO122
PO131     PO20.1    PO21.1    PO21.2    PO21.3    PO21.4
PO21.5    PO22.1    PO23.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    PO33.1    PO34.1
PO35.1    PO36.1    PO36.2    PO38.1    PO39.1    PO39.2
PO44.1    PO50.1    PO52.1    PO520     PO536     POII.1
POIJ.1    RQ10.1    RQ10.2    RQ10.3    RQIE.1    WH20.2
WH20.7    API5.1    MA63.1    MAED.1    MM280     MM80.1
MM80.2

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    API1.1    MA41.1    MA41.2
MA41.4    MA43.2    POI3.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AOI-COMPANY            Numeric 4                                 AP115   AP180
Element: Company       The company number represents an          AP181   AP190
                       established company and is entered on     AP20.1  AP20.2
                       all function codes.                       AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 MA41.1  MA41.2
                                                                 MA43.2  POI3.1

AOI-PO-NUMBER          Alpha 14  (Right Justified)               AP115   AP180
Element: PO Number     The purchase order number.                AP181   AP190
                                                                 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  AP305
                                                                 AP45.1  API1.1
                                                                 MA41.1  MA41.2
                                                                 MA43.2  POI3.1

AOI-PO-RELEASE         Numeric 4                                 AP115   AP180
Element: PO Release NumIdentifies a purchase order release       AP181   AP190
                       (created from a Blanket or Standing       AP20.1  AP20.2
                       order).                                   AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 MA41.1  MA41.2
                                                                 MA43.2  POI3.1

AOI-PO-CODE            Alpha 4                                   AP115   AP180
Element: Purchase OrderPurchase order code.                      AP181   AP190
                                                                 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  AP305
                                                                 AP45.1  API1.1
                                                                 MA41.1  MA41.2
                                                                 MA43.2  POI3.1

AOI-VENDOR             Alpha 9  (Right Justified)                AP115   AP180
Element: Vendor ID     Vendor identification code.               AP181   AP190
                                                                 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  AP305
                                                                 AP45.1  API1.1
                                                                 MA41.1  MA41.2
                                                                 MA43.2  POI3.1

AOI-INVOICE            Alpha 22                                  AP115   AP180
Element: Invoice NumberInvoice number.                           AP181   AP190
                                                                 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  AP305
                                                                 AP45.1  API1.1
                                                                 MA41.1  MA41.2
                                                                 MA43.2  POI3.1

AOI-SUFFIX             Numeric 3                                 AP115   AP180
Element: Invoice SuffixThe suffix of the invoice.                AP181   AP190
                                                                 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  AP305
                                                                 AP45.1  API1.1
                                                                 MA41.1  MA41.2
                                                                 MA43.2  POI3.1

AOI-MATCH-REF-NBR      Alpha 22                                  AP115   AP180
Matching Reference     Matching reference number used to match   AP181   AP190
Number                 invoices.                                 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  AP305
                                                                 AP45.1  API1.1
                                                                 MA41.2  MA43.2
                                                                 POI3.1

AOI-TAX-CODE           Alpha 10                                  AP115   AP180
Element: Tax Code      Tax code. Represents specific tax         AP181   AP190
                       information and rules.                    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  AP305
                                                                 AP45.1  API1.1
                                                                 MA41.2  MA43.2
                                                                 POI3.1

AOI-LOCATION           Alpha 5                                   AP115   AP180
Element: Location Code A valid stocking location within the      AP181   AP190
                       company inventory.                        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  AP305
                                                                 AP45.1  API1.1
                                                                 MA41.2  MA43.2
                                                                 POI3.1

AOI-INVOICE-TYPE       Alpha 1                                   AP115   AP180
Element: Invoice Type  Invoice type.                             AP181   AP190
                                                                 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  AP305
                                                                 AP45.1  API1.1
                                                                 MA41.2  MA43.2
                                                                 POI3.1

                         MAPOINV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AOISET1   COMPANY                                                AP115   AP125
          PO-NUMBER                                              AP126   AP131
          PO-RELEASE                                             AP20.1  AP20.2
          PO-CODE                                                AP20.3  AP20.4
          VENDOR                                                 AP20.5  AP20.7
          INVOICE                                                AP23.1  AP25.1
          SUFFIX                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 AP305   API1.1
                                                                 IC28.1  MA01.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA43.8
                                                                 MA43.9  MA530
                                                                 ...

AOISET2   COMPANY       KeyChange                                AP115   AP125
          VENDOR                                                 AP126   AP198
          INVOICE                                                AP20.1  AP20.2
          SUFFIX                                                 AP20.3  AP20.4
          PO-NUMBER                                              AP20.5  AP20.7
          PO-RELEASE                                             AP23.1  AP25.1
          PO-CODE                                                AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 AP300   AP305
                                                                 API1.1  API5.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.4
                                                                 MA43.5  MA43.7
                                                                 ...

                         MAPOINV FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apbatch        APBATCH      Not Required

                            AOI-COMPANY         -> APB-COMPANY
                            API-BATCH-NUM       -> APB-BATCH-NUM

Apcompany      APCOMPANY    Required

                            AOI-COMPANY         -> CPY-COMPANY

Apinvoice      APINVOICE    Required

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

Iccompany      ICCOMPANY    Required

                            AOI-COMPANY         -> ICC-COMPANY

Macompany      MACOMPANY    Required

                            AOI-COMPANY         -> MAY-COMPANY

Pocompany      POCOMPANY    Required

                            AOI-COMPANY         -> PCY-COMPANY

Purchorder     PURCHORDER   Required

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

Vendor         APVENMAST    Required

                            CPY-VENDOR-GROUP    -> VEN-VENDOR-GROUP
                            AOI-VENDOR          -> VEN-VENDOR

Vendorloc      APVENLOC     Not Required
                            Valid When PCR-PURCH-FR-LOC != Spaces

                            CPY-VENDOR-GROUP    -> VLO-VENDOR-GROUP
                            AOI-VENDOR          -> VLO-VENDOR
                            PCR-PURCH-FR-LOC    -> VLO-LOCATION-CODE

                         MAPOINV FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mainvdtl       MAINVDTL

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

Mainvdtl All   MAINVDTL

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

Poaochdrdtl    POAOCDTL

                            AOI-COMPANY         -> PAO-COMPANY
                            Spaces              -> PAO-PROCURE-GROUP
                            Spaces              -> PAO-VEN-AGRMT-REF
                            AOI-PO-NUMBER       -> PAO-PO-NUMBER
                            AOI-PO-RELEASE      -> PAO-PO-RELEASE
                            AOI-PO-CODE         -> PAO-PO-CODE
                            Zeroes              -> PAO-LINE-NBR
                                                   PAO-AOC-CODE

Poaocsprd      POAOCSPRD    Delete Cascades

                            AOI-COMPANY         -> PSP-COMPANY
                            AOI-INVOICE         -> PSP-INVOICE
                                                   PSP-AOC-CODE
                                                   PSP-PO-NUMBER
                                                   PSP-PO-RELEASE
                                                   PSP-PO-CODE

Poline         POLINE

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