MAPOINV

Multiple PO Invoice

The Matching Purchase Order file contains header information for purchase orders.

REFERENCED BY
AM19.1 AM19.2 AP125 AP126 AP131 AP220
AP510 API2.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC12.1 IC140 IC141 IC142 IC145
IC243 IC330 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC83.1 MA01.1 MA126 MA180 MA26.1 MA278
MA53.1 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA67.2 MA67.3
MA67.4 MA68.2 MA68.3 MA68.5 MA69.1 MA69.2
MA69.3 MA69.4 MA69.5 MA69.6 MA80.1 MA90.2
MA90.3 MA90.5 MA90.6 MAI1.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO136 PO15.1
PO15.2 PO15.4 PO150 PO17.1 PO190 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO220
PO222 PO224 PO225 PO229 PO23.1 PO230
PO234 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO251 PO26.3 PO26.7 PO26.9 PO27.2 PO27.3
PO27.4 PO275 PO276 PO277 PO28.2 PO280
PO29.1 PO30.1 PO30.2 PO30.3 PO30.4 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 PO54.5
POCP.1 POID.1 POII.1 POIJ.1 RQ01.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810
RQIB.1 RQIF.1 RQII.1 RQIJ.1 WH130 WH132
WH190 WH20.2 WH20.7 WH222 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830 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
AP305 AP45.1 API1.1 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA44.1 MA44.2 MA70.1
MA75.1 POI3.1 AP198 AP300

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AOI-COMPANY
Element: Company		Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
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
AP305 AP45.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 POI3.1
AOI-PO-NUMBER
Element: Po Number		Alpha 14 (Right Justified)
The purchase order number.
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
AP305 AP45.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 POI3.1
AOI-PO-RELEASE
Element: Po Release		Numeric 4
Identifies a purchase order release (created from a blanket or standing order).
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
AP305 AP45.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 POI3.1
AOI-PO-CODE
Element: Purchase Order Code		Alpha 4
Purchase order code.
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
AP305 AP45.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 POI3.1
AOI-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
Vendor identification code.
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
AP305 AP45.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 POI3.1
AOI-INVOICE
Element: Invoice		Alpha 22
Invoice number.
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
AP305 AP45.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 POI3.1
AOI-SUFFIX
Element: Suffix		Numeric 3
The suffix of the invoice.
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
AP305 AP45.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 POI3.1
AOI-MATCH-REF-NBR
Matching Reference
Number		Alpha 22
Matching reference number used to match invoices.
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
AP305 AP45.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 POI3.1
AOI-TAX-CODE
Element: Tax Code		Alpha 10
Tax code. Represents specific tax information and rules.
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
AP305 AP45.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 POI3.1
AOI-LOCATION
Element: Location		Alpha 5
A valid stocking location within the company inventory.
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
AP305 AP45.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 POI3.1
AOI-INVOICE-TYPE
Element: Invoice Type		Alpha 1
Invoice type.
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
AP305 AP45.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 POI3.1


MAPOINV FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AOISET1 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
VENDOR
INVOICE
SUFFIX
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
AOISET2 COMPANY
VENDOR
INVOICE
SUFFIX
PO-NUMBER
PO-RELEASE
PO-CODE
KeyChange
...
AP115 AP125
AP126 AP198
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP300
AP305 API1.1
API5.1 MA26.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.1 MA42.2
MA43.1 MA43.2


MAPOINV FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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
Poreceive PORECEIVE
AOI-COMPANY->POR-COMPANY
AOI-PO-CODE->POR-PO-CODE
AOI-PO-NUMBER->POR-PO-NUMBER
AOI-PO-RELEASE->POR-PO-RELEASE
  POR-PO-LOCATION
  POR-REC-NUMBER
Porecline PORECLINE
AOI-COMPANY->PRL-COMPANY
AOI-PO-CODE->PRL-PO-CODE
AOI-PO-NUMBER->PRL-PO-NUMBER
AOI-PO-RELEASE->PRL-PO-RELEASE
  PRL-PO-LINE-NBR
  PRL-UPDATE-DATE
  PRL-UPDATE-TIME
  PRL-REC-NUMBER
  PRL-LINE-NBR

File created: Thu Jun 09 02:22:57 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.