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
IC14.1 IC216 MA278 POIH.1 PO00.1 PO72.1


UPDATED BY
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM22.1 AM500 AM51.1 AM551 AM97.1
AP03.3 AP10.2 AP110 AP115 AP125 AP126
AP131 AP150 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP210 AP220 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP271 AP30.2
AP30.4 AP300 AP305 AP510 AP90.1 AP91.1
API1.1 API2.1 API3.1 API4.1 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX205 CX220 CX30.1
CX300 CX506 CXCP.1 DR100 IC11.1 IC140
IC141 IC142 IC175 IC211 IC270 IC281
IC520 IC521 IC522 IC524 IC525 IC526
IC527 IC598 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC800 IC83.1 IC840 ICI1.1 ICI9.1 ZC522
MX123 MX500 MA180 MA279 MA41.1 MA41.2
MA41.4 MA41.7 MA42.1 MA42.2 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA44.1 MA44.2
MA530 MA531 MA540 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA69.1 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD235 PO10.1 PO100 PO101
PO120 PO122 PO13.1 PO13.3 PO131 PO136
PO150 PO16.1 PO16.2 PO190 PO20.1 PO20.6
PO20.9 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO213 PO216 PO22.1 PO22.2 PO22.3 PO22.4
PO22.5 PO220 PO223 PO23.1 PO233 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO253 PO254
PO258 PO26.4 PO26.5 PO27.2 PO278 PO28.2
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.1
PO54.2 PO54.3 PO54.4 PO54.5 PO560 PO58.1
PO58.2 PO813 POCP.1 POI3.1 POI7.1 POID.1
POII.1 POIJ.1 PR05.1 PR05.3 PR226 PR247
PR26.1 PR47.1 PR514 UK47.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ260 RQ35.1 RQ500 RQIC.1 RQID.1 RQIF.1
RQIG.1 RQIH.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 ZW130

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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC141
IC142 IC175
IC211 IC270
IC281 IC520
IC521 IC522
IC524 IC525
IC526 IC527
IC598 IC66.1
IC83.1 ICI1.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.1 MA43.2
MA43.3 MA43.7
MA44.1 MA44.2
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC141
IC142 IC175
IC211 IC270
IC281 IC520
IC521 IC522
IC524 IC525
IC526 IC527
IC598 IC66.1
IC83.1 ICI1.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.1 MA43.2
MA43.3 MA43.7
MA44.1 MA44.2
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC141
IC142 IC175
IC211 IC270
IC281 IC520
IC521 IC522
IC524 IC525
IC526 IC527
IC598 IC66.1
IC83.1 ICI1.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.1 MA43.2
MA43.3 MA43.7
MA44.1 MA44.2
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC141
IC142 IC175
IC211 IC270
IC281 IC520
IC521 IC522
IC524 IC525
IC526 IC527
IC598 IC66.1
IC83.1 ICI1.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.1 MA43.2
MA43.3 MA43.7
MA44.1 MA44.2
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC141
IC142 IC175
IC211 IC270
IC281 IC520
IC521 IC522
IC524 IC525
IC526 IC527
IC598 IC66.1
IC83.1 ICI1.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.1 MA43.2
MA43.3 MA43.7
MA44.1 MA44.2
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC141
IC142 IC175
IC211 IC270
IC281 IC520
IC521 IC522
IC524 IC525
IC526 IC527
IC598 IC66.1
IC83.1 ICI1.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.1 MA43.2
MA43.3 MA43.7
MA44.1 MA44.2
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC141
IC142 IC175
IC211 IC270
IC281 IC520
IC521 IC522
IC524 IC525
IC526 IC527
IC598 IC66.1
IC83.1 ICI1.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.1 MA43.2
MA43.3 MA43.7
MA44.1 MA44.2
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC141
IC142 IC175
IC211 IC270
IC281 IC520
IC521 IC522
IC524 IC525
IC526 IC527
IC598 IC66.1
IC83.1 ICI1.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.1 MA43.2
MA43.3 MA43.7
MA44.1 MA44.2
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC141
IC142 IC175
IC211 IC270
IC281 IC520
IC521 IC522
IC524 IC525
IC526 IC527
IC598 IC66.1
IC83.1 ICI1.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.1 MA43.2
MA43.3 MA43.7
MA44.1 MA44.2
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC141
IC142 IC175
IC211 IC270
IC281 IC520
IC521 IC522
IC524 IC525
IC526 IC527
IC598 IC66.1
IC83.1 ICI1.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.1 MA43.2
MA43.3 MA43.7
MA44.1 MA44.2
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC141
IC142 IC175
IC211 IC270
IC281 IC520
IC521 IC522
IC524 IC525
IC526 IC527
IC598 IC66.1
IC83.1 ICI1.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.1 MA43.2
MA43.3 MA43.7
MA44.1 MA44.2
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC141
IC142 IC175
IC211 IC270
IC281 IC520
IC521 IC522
IC524 IC525
IC526 IC527
IC598 IC66.1
IC83.1 ICI1.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.1 MA43.2
MA43.3 MA43.7
MA44.1 MA44.2
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC141
IC142 IC175
IC211 IC270
IC281 IC520
IC521 IC522
IC524 IC525
IC526 IC527
IC598 IC66.1
IC83.1 ICI1.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.1 MA43.2
MA43.3 MA43.7
MA44.1 MA44.2
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC141
IC142 IC175
IC211 IC270
IC281 IC520
IC521 IC522
IC524 IC525
IC526 IC527
IC598 IC66.1
IC83.1 ICI1.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.1 MA43.2
MA43.3 MA43.7
MA44.1 MA44.2
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC141
IC142 IC175
IC211 IC270
IC281 IC520
IC521 IC522
IC524 IC525
IC526 IC527
IC598 IC66.1
IC83.1 ICI1.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.1 MA43.2
MA43.3 MA43.7
MA44.1 MA44.2
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC141
IC142 IC175
IC211 IC270
IC281 IC520
IC521 IC522
IC524 IC525
IC526 IC527
IC598 IC66.1
IC83.1 ICI1.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.1 MA43.2
MA43.3 MA43.7
MA44.1 MA44.2
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
PIVSET2 PROCURE-GROUP
VEN-ITEM
ITEM
VENDOR
PO258 PO58.1
PO58.2 PO72.1
RQIC.1 RQIG.1
PIVSET3 PROCURE-GROUP
VENDOR
VEN-ITEM
ITEM
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.2
AP110 AP115
AP125 AP126
AP131 AP150
AP20.1 AP20.2
AP20.3 AP20.4
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
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 PO13.1
PO13.3 RQIC.1
RQIG.1
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
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
Popivuf POPIVUF Not Required
PIV-PROCURE-GROUP->UFI-PROCURE-GROUP
PIV-ITEM->UFI-ITEM
PIV-VENDOR->UFI-VENDOR
PIV-VEN-ITEM->UFI-VEN-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
Itemndc ITEMNDC
PCG-ITEM-GROUP->IDC-ITEM-GROUP
PIV-ITEM->IDC-ITEM
  IDC-NDC-NBR

File created: Thu Jun 09 11:24:12 2016

Home
Contact Us



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