Lawson Insight Technical Documentation |
|
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
|