POITEMVEN

PO Vendor Item Information

This file contains the vendor's item identifier and forms a cross reference between the item number and the vendor's item identifier and item description.

REFERENCED BY
POIH.1


UPDATED BY
AP125 AP126 AP131 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 AP30.2 API1.1
API2.1 ICI1.1 ICI9.1 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA540 MAI1.1 PO00.1 PO136 PO190
PO300 PO520 POCP.1 POI3.1 POI7.1 POII.1
POIJ.1 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM500 AM51.1 AM551 AM97.1 AP03.3
AP110 AP115 AP150 AP210 AP220 AP300
AP305 AP510 AP90.1 AP91.1 API3.1 API4.1
MX123 MX500 PO10.1 PR05.1 PR05.3 PR226
PR247 PR26.1 PR47.1 PR514 UK47.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIV-PROCURE-GROUP
Element: Procure Group		Alpha 4
This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together.
AP125 AP126
AP131 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
API1.1 API2.1
ICI1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PIV-ITEM
Element: Item		Alpha 32
This field contains the item identifier.
AP125 AP126
AP131 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
API1.1 API2.1
ICI1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PIV-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
AP125 AP126
AP131 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
API1.1 API2.1
ICI1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PIV-VEN-ITEM
Element: Item		Alpha 32
The vendor's item identifier.
AP125 AP126
AP131 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
API1.1 API2.1
ICI1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PIV-VEN-ITEM-DESC
Element: Description		Alpha 30 (Lower Case)
This field displays the description.
AP125 AP126
AP131 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
API1.1 API2.1
ICI1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PIV-VBUY-UOM
Element: Uom		Alpha 4
This field contains the valid stock unit of measure for this item.
AP125 AP126
AP131 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
API1.1 API2.1
ICI1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PIV-VPRI-UOM
Element: Uom		Alpha 4
This field contains the valid stock unit of measure for this item.
AP125 AP126
AP131 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
API1.1 API2.1
ICI1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PIV-MANUF-CODE
Element: Manuf Code		Alpha 4
This field contains a user defined code that indicates the manufacturer of an item.
AP125 AP126
AP131 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
API1.1 API2.1
ICI1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PIV-MANUF-DIVISION
Element: Manuf Division		Alpha 4
This is a user defined code that indicates which division of a manufacturer is tied to an item.
AP125 AP126
AP131 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
API1.1 API2.1
ICI1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PIV-MANUF-NBR
Element: Manuf Nbr		Alpha 35
This is the identifier that the manufacturer has assigned to an item.
AP125 AP126
AP131 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
API1.1 API2.1
ICI1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PIV-LIC-CODE
Element: Lic Code		Alpha 4
The Labeler Identification Code (LIC) is assigned to any organization in the healthcare industry. The LIC is used with bar code technology to identify the company that put the label on the product.
AP125 AP126
AP131 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
API1.1 API2.1
ICI1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PIV-LAST-LEADTIME
Element: Leadtime Days		Numeric 3
This field contains the difference in days between the purchase order date and the received date for the last purchase order for this item for this vendor. This field is updated by Purchase Order. The field is display only in the item vendor record, it is not used for defaulting.
AP125 AP126
AP131 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
API1.1 API2.1
ICI1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PIV-MIN-ORD-QTY
Element: Min Ord Qty		Signed 13.4
AP125 AP126
AP131 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
API1.1 API2.1
ICI1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PIV-WARRANTY-PER
Element: Warranty Per		Numeric 6
AP125 AP126
AP131 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
API1.1 API2.1
ICI1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PIV-DEFAULT-FLG
Element: Default Flg		Numeric 1

0 = No
1 = Yes
AP125 AP126
AP131 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
API1.1 API2.1
ICI1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PIV-STATUS
Element: Status		Numeric 1

0 = Active
1 = Inactive
AP125 AP126
AP131 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
API1.1 API2.1
ICI1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PIV-ITEM-CODE-USED
Element: Item Code Used		Derived


POITEMVEN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PIVSET1 PROCURE-GROUP
ITEM
VENDOR
VEN-ITEM
...
AP125 AP126
AP131 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
API1.1 API2.1
ICI1.1 ICI9.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
PIVSET2 PROCURE-GROUP
VEN-ITEM
ITEM
VENDOR
PIVSET3 PROCURE-GROUP
VENDOR
VEN-ITEM
ITEM
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
PIVSET4 PROCURE-GROUP
VENDOR
ITEM
VEN-ITEM
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
PIVSET5 PROCURE-GROUP
VENDOR
MANUF-CODE
MANUF-DIVISION
MANUF-NBR
ITEM
VEN-ITEM
...
AP125 AP126
AP131 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
API1.1 API2.1
ICI1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
PIVSET6 PROCURE-GROUP
MANUF-CODE
MANUF-DIVISION
MANUF-NBR
ITEM
VBUY-UOM
VENDOR
VEN-ITEM
Subset
WhereMANUF-CODE !=Spaces
AndMANUF-NBR !=Spaces


POITEMVEN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Apvenmast APVENMAST Required
PCG-VENDOR-GROUP->VEN-VENDOR-GROUP (VENSET1)
PIV-VENDOR->VEN-VENDOR
Itemmast ITEMMAST Required
PCG-ITEM-GROUP->ITE-ITEM-GROUP
PIV-ITEM->ITE-ITEM
Procuregrp PROCUREGRP Required
PIV-PROCURE-GROUP->PCG-PROCURE-GROUP


POITEMVEN FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Icitemgtin ICITEMGTIN
Valid When PIV-MANUF-CODE !=Spaces
AndPIV-MANUF-NBR !=Spaces
PCG-ITEM-GROUP->GTI-ITEM-GROUP
PIV-MANUF-CODE->GTI-MANUF-CODE
PIV-MANUF-DIVISION->GTI-MANUF-DIVISION
PIV-MANUF-NBR->GTI-MANUF-NBR
PIV-ITEM->GTI-ITEM
  GTI-UOM
  GTI-GTIN
Icitemgtinbuom ICITEMGTIN
Valid When PIV-VBUY-UOM !=Spaces
Or(PIV-MANUF-CODE !=Spaces
OrPIV-MANUF-NBR !=Spaces )
PCG-ITEM-GROUP->GTI-ITEM-GROUP
PIV-MANUF-CODE->GTI-MANUF-CODE
PIV-MANUF-DIVISION->GTI-MANUF-DIVISION
PIV-MANUF-NBR->GTI-MANUF-NBR
PIV-ITEM->GTI-ITEM
PIV-VBUY-UOM->GTI-UOM
  GTI-GTIN

File created: Wed Jun 08 20:50:48 2016

Home
Contact Us



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