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     AP220     API1.1    BL120
BL122     BL130     BL20.1    BL20.3    BL21.2    BL21.5
BL29.1    BL29.2    BL520     BL820     BL92.1    IC28.1
MA01.1    MA126     MA180     MA530     MA531     MA540
MA60.2    MA60.3    MA60.5    MA61.1    MA63.1    MA66.2
MA66.3    MA67.1    MA67.2    MA70.1    MA75.1    MA80.1
MAI1.1    OE10.1    OE10.2    OE10.3    OE10.4    OE10.5
OE10.6    OE10.7    OE10.8    OE11.1    OE11.4    OE11.8
OE11.9    OE110     OE111     OE113     OE114     OE116
OE129     OE13.2    OE13.3    OE13.5    OE13.6    OE14.4
OE30.1    OE30.2    OE30.3    OE30.4    OE30.5    OE30.6
OE30.7    OE30.9    OE510     OE530     OE81.1    OE810
OE830     OE90.1    OE90.2    PO100     PO101     PO122
PO131     PO20.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.1    PO29.1    PO30.1    PO30.2    PO30.3
PO300     PO31.1    PO31.2    PO32.2    PO33.1    PO34.1
PO35.1    PO38.1    PO39.1    PO39.2    PO44.1    PO50.1
PO52.1    PO520     POIE.1    POII.1    POIJ.1    RQ10.1
RQ10.2    WH20.2    WH20.7    API5.1    MAED.1

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AOI-COMPANY            Numeric 4                                 AP115   AP180
Element: Company       Identifies the AP company if the          AP181   AP190
                       resource type = V.  Identifies the HR     AP25.2  AP26.1
                       company if the resource type = E.  It is  AP27.1  AP28.1
                       blank for type A, P or Q resources.       AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 POI3.1

AOI-PO-NUMBER          Alpha 14  (Right Justified)               AP115   AP180
Element: PO Number     The purchase order number.                AP181   AP190
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 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       AP25.2  AP26.1
                       order).                                   AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 POI3.1

AOI-PO-CODE            Alpha 4                                   AP115   AP180
Element: Purchase OrderPurchase order code.                      AP181   AP190
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 POI3.1

AOI-VENDOR             Alpha 9  (Right Justified)                AP115   AP180
Element: Vendor ID     Vendor identification code.               AP181   AP190
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 POI3.1

AOI-INVOICE            Alpha 22                                  AP115   AP180
Element: Invoice NumberInvoice number.                           AP181   AP190
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 POI3.1

AOI-SUFFIX             Numeric 3                                 AP115   AP180
Element: Invoice SuffixThe suffix of the invoice.                AP181   AP190
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 POI3.1

AOI-MATCH-REF-NBR      Alpha 22                                  AP115   AP180
Matching Reference     Matching reference number used to match   AP181   AP190
Number                 invoices.                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 POI3.1

AOI-TAX-CODE           Alpha 10                                  AP115   AP180
Element: Tax Code      Tax code. Represents specific tax         AP181   AP190
                       information and rules.                    AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 POI3.1

AOI-LOCATION           Alpha 5                                   AP115   AP180
Element: Location Code A valid stocking location within the      AP181   AP190
                       company inventory.                        AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 POI3.1

AOI-INVOICE-TYPE       Alpha 1                                   AP115   AP180
Element: Invoice Type  Invoice type.                             AP181   AP190
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 POI3.1

                         MAPOINV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AOISET1   COMPANY                                                AP115   AP125
          PO-NUMBER                                              AP126   AP131
          PO-RELEASE                                             AP220   AP25.1
          PO-CODE                                                AP25.2  AP26.1
          VENDOR                                                 AP27.1  AP30.2
          INVOICE                                                AP30.4  AP305
          SUFFIX                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC28.1
                                                                 MA01.1  MA126
                                                                 MA180   MA530
                                                                 ...

AOISET2   COMPANY       KeyChange                                AP115   AP125
          VENDOR                                                 AP126   AP198
          INVOICE                                                AP25.1  AP25.2
          SUFFIX                                                 AP26.1  AP27.1
          PO-NUMBER                                              AP30.4  AP300
          PO-RELEASE                                             AP305   API1.1
          PO-CODE                                                API5.1  MA60.2
                                                                 MA60.3  MA61.1
                                                                 MA63.1  MA66.2
                                                                 MA67.1  MA70.1
                                                                 MA75.1  MAED.1
                                                                 MAI1.1

                         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-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-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