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