 |
Lawson Insight Technical Documentation |
|
MAPOINV FILE
Matching Purchase Order
The Matching Purchase Order file contains header information for purchase
orders.
REFERENCED BY
MA01.1 POIJ.1 MA63.1 MAED.1
UPDATED BY
AP115 AP180 AP181 AP190 AP198 AP28.1
AP28.2 AP30.4 AP300 AP305 AP45.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 AP28.1 AP28.2
all function codes. AP30.4 AP305
AP45.1
AOI-PO-NUMBER Alpha 14 (Right Justified) AP115 AP180
PO Number The purchase order number. AP181 AP190
AP28.1 AP28.2
AP30.4 AP305
AP45.1
AOI-PO-RELEASE Numeric 4 AP115 AP180
PO Release Number Identifies a purchase order release AP181 AP190
(created from a Blanket or Standing AP28.1 AP28.2
order). AP30.4 AP305
AP45.1
AOI-PO-CODE Alpha 4 AP115 AP180
Purchase Order Code Purchase order code. AP181 AP190
AP28.1 AP28.2
AP30.4 AP305
AP45.1
AOI-VENDOR Alpha 9 (Right Justified) AP115 AP180
Vendor ID Vendor identification code. AP181 AP190
AP28.1 AP28.2
AP30.4 AP305
AP45.1
AOI-INVOICE Alpha 22 AP115 AP180
Invoice Number Invoice number. AP181 AP190
AP28.1 AP28.2
AP30.4 AP305
AP45.1
AOI-SUFFIX Numeric 3 AP115 AP180
Invoice Suffix The suffix of the invoice. AP181 AP190
AP28.1 AP28.2
AP30.4 AP305
AP45.1
AOI-MATCH-REF-NBR Alpha 22 AP115 AP180
Matching Reference Matching reference number used to match AP181 AP190
Number invoices. AP28.1 AP28.2
AP30.4 AP305
AP45.1
AOI-TAX-CODE Alpha 10 AP115 AP180
Tax Code Tax code. Represents specific tax AP181 AP190
information and rules. AP28.1 AP28.2
AP30.4 AP305
AP45.1
AOI-LOCATION Alpha 5 AP115 AP180
Location Code A valid stocking location within the AP181 AP190
company inventory. AP28.1 AP28.2
AP30.4 AP305
AP45.1
AOI-INVOICE-TYPE Alpha 1 AP115 AP180
Invoice Type Invoice type. AP181 AP190
AP28.1 AP28.2
AP30.4 AP305
AP45.1
MAPOINV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AOISET1 COMPANY AP115 AP30.4
PO-NUMBER AP305 MA01.1
PO-RELEASE POIJ.1
PO-CODE
VENDOR
INVOICE
SUFFIX
AOISET2 COMPANY KeyChange AP115 AP198
VENDOR AP30.4 AP300
INVOICE AP305 MA63.1
SUFFIX MAED.1
PO-NUMBER
PO-RELEASE
PO-CODE
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
|