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

AM19.1    AM19.2    AP125     AP126     AP131     AP220
API2.1    BL120     BL122     BL130     BL20.1    BL20.3
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL820
BL92.1    MA01.1    MA126     MA180     MA310     MA530
MA531     MA540     MA60.2    MA60.3    MA60.5    MA61.1
MA63.1    MA65.1    MA66.2    MA66.3    MA67.2    MA67.3
MA67.4    MA68.2    MA68.3    MA68.5    MA69.1    MA69.2
MA69.3    MA69.4    MA69.5    MA69.6    MA70.1    MA75.1
MA80.1    MA90.2    MA90.3    MA90.5    MAI1.1    PD10.1
PD10.2    PD130     PD20.1    PD20.2    PD20.3    PO100
PO101     PO122     PO131     PO20.1    PO21.1    PO21.2
PO21.3    PO21.4    PO21.5    PO22.1    PO23.1    PO24.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    PO32.4    PO33.1    PO34.1    PO35.1    PO36.1
PO36.2    PO38.1    PO39.1    PO39.2    PO44.1    PO50.1
PO52.1    PO520     PO536     POID.1    POII.1    POIJ.1
RQ10.1    RQ10.2    WH20.2    WH20.7    API5.1    MAED.1


UPDATED BY

AP115     AP180     AP181     AP190     AP20.1    AP20.2
AP20.3    AP20.4    AP20.5    AP20.7    AP21.1    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    MA41.7    MA43.2    POI3.1    AP198

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     AP20.1  AP20.2
                       company if the resource type = E.  It is  AP20.3  AP20.4
                       blank for type A, P or Q resources.       AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  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
                                                                 AP21.1  AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 POI3.1

AOI-PO-RELEASE         Numeric 4                                 AP115   AP180
Element: Po Release    Identifies 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
                                                                 AP21.1  AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  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
                                                                 AP21.1  AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 POI3.1

AOI-VENDOR             Alpha 9  (Right Justified)                AP115   AP180
Element: Vendor        Vendor identification code.               AP181   AP190
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 POI3.1

AOI-INVOICE            Alpha 22                                  AP115   AP180
Element: Invoice       Invoice number.                           AP181   AP190
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 POI3.1

AOI-SUFFIX             Numeric 3                                 AP115   AP180
Element: Suffix        The suffix of the invoice.                AP181   AP190
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  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
                                                                 AP21.1  AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  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
                                                                 AP21.1  AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 POI3.1

AOI-LOCATION           Alpha 5                                   AP115   AP180
Element: Location      A valid stocking location within the      AP181   AP190
                       company inventory.                        AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  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
                                                                 AP21.1  AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP305   AP45.1
                                                                 API1.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 POI3.1

                         MAPOINV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AOISET1   COMPANY                                                AM19.1  AM19.2
          PO-NUMBER                                              AP115   AP125
          PO-RELEASE                                             AP126   AP131
          PO-CODE                                                AP20.1  AP20.2
          VENDOR                                                 AP20.3  AP20.4
          INVOICE                                                AP20.5  AP20.7
          SUFFIX                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 ...

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                                             AP21.1  AP23.1
          PO-CODE                                                AP25.1  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.6
                                                                 ...

                         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