 |
Lawson Insight Technical Documentation |
|
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.3 MA67.1 MA67.2 MA70.1 MAI1.1
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
API1.1 MA63.1 MAED.1
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 MA41.1 MA41.2 MA41.4
MA43.2 POI3.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AOI-COMPANY Numeric 4 AP115 AP180
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 MA41.1
MA41.2 MA43.2
POI3.1
AOI-PO-NUMBER Alpha 14 (Right Justified) AP115 AP180
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 MA41.1
MA41.2 MA43.2
POI3.1
AOI-PO-RELEASE Numeric 4 AP115 AP180
PO Release Number 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
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 MA41.1
MA41.2 MA43.2
POI3.1
AOI-PO-CODE Alpha 4 AP115 AP180
Purchase Order Code Purchase 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 MA41.1
MA41.2 MA43.2
POI3.1
AOI-VENDOR Alpha 9 (Right Justified) AP115 AP180
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 MA41.1
MA41.2 MA43.2
POI3.1
AOI-INVOICE Alpha 22 AP115 AP180
Invoice Number Invoice 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 MA41.1
MA41.2 MA43.2
POI3.1
AOI-SUFFIX Numeric 3 AP115 AP180
Invoice Suffix The 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 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 MA41.2
MA43.2 POI3.1
AOI-TAX-CODE Alpha 10 AP115 AP180
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 MA41.2
MA43.2 POI3.1
AOI-LOCATION Alpha 5 AP115 AP180
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 MA41.2
MA43.2 POI3.1
AOI-INVOICE-TYPE Alpha 1 AP115 AP180
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 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 IC28.1
MA01.1 MA180
MA41.2 MA43.2
MA43.7 MA43.8
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
...
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 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
...
AOISET4 COMPANY KeyChange
MATCH-REF-NBR
VENDOR
PO-NUMBER
PO-RELEASE
PO-CODE
LOCATION
INVOICE
SUFFIX
MAPOINV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apbatch APBATCH Not Required
AOI-COMPANY -> APB-COMPANY (APBSET1)
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 AOI-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
|