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
IC11.1 IC14.1 IC800 ICI9.1 PO00.1 PO192
PO213 PO69.1 PO72.1 PO258 PO58.1 PO58.2
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 AP150 AP210
AP220 AP271 AP300 AP305 AP90.1 AP91.1
API3.1 API4.1 IC840 MX123 MX500 MA126
MA279 MA63.1 MA69.1 PD235 PO195 PO233
PO253 PO254 PO278 PO529 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 PR514 RQ260


UPDATED BY
MA531 PO13.1 PO13.3 PO150 PO25.6 PO25.7
PO25.1 PO25.5 PO26.4 PO26.5 PO26.3 PO26.7
PO26.9 PO28.2 PO30.1 PO30.2 PO30.3 PO30.4
PO35.1 PO36.2 PO36.1 PO52.1 PO536 PO813
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 AP510 API1.1
API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX205 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC12.1 IC140 IC141 IC142 IC145
IC175 IC211 IC216 IC243 IC270 IC281
IC330 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 IC83.1 ICI1.1 MA180 MA278 MA41.1
MA41.2 MA41.4 MA41.7 MA42.2 MA43.1 MA43.2
MA43.3 MA43.7 MA44.1 MA44.2 MA53.1 MA530
MA540 MA60.2 MA60.3 MA60.5 MA61.1 MA65.1
MA66.2 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA70.1 MA75.1 MA80.1 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 PO16.1 PO16.2 PO17.1 PO190
PO20.1 PO20.6 PO20.9 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO216 PO22.1 PO22.3
PO22.4 PO220 PO222 PO223 PO224 PO225
PO229 PO23.1 PO230 PO234 PO24.1 PO251
PO27.2 PO27.3 PO27.4 PO275 PO276 PO277
PO280 PO29.1 PO300 PO31.1 PO31.2 PO32.2
PO32.4 PO33.1 PO34.1 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO520 PO54.5 PO560 POCP.1
POI3.1 POI7.1 POID.1 POIH.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 RQIC.1 RQID.1 RQIF.1
RQIG.1 RQIH.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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIV-PROCURE-GROUP
Element: Procure Group
Alpha 4
Type or select a procurement group. A procurement group is 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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC175 IC211
IC243 IC270
IC281 IC330
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
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC175 IC211
IC243 IC270
IC281 IC330
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
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC175 IC211
IC243 IC270
IC281 IC330
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
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC175 IC211
IC243 IC270
IC281 IC330
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
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC175 IC211
IC243 IC270
IC281 IC330
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
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC175 IC211
IC243 IC270
IC281 IC330
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
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC175 IC211
IC243 IC270
IC281 IC330
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
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC175 IC211
IC243 IC270
IC281 IC330
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
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC175 IC211
IC243 IC270
IC281 IC330
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
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC175 IC211
IC243 IC270
IC281 IC330
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
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC175 IC211
IC243 IC270
IC281 IC330
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
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC175 IC211
IC243 IC270
IC281 IC330
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
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC175 IC211
IC243 IC270
IC281 IC330
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
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC175 IC211
IC243 IC270
IC281 IC330
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
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC175 IC211
IC243 IC270
IC281 IC330
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
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC175 IC211
IC243 IC270
IC281 IC330
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
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.1
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
MA540 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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.1
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
Popivaudit POPIVAUDIT
PIV-PROCURE-GROUP->PIU-PROCURE-GROUP
PIV-ITEM->PIU-ITEM
PIV-VENDOR->PIU-VENDOR
PIV-VEN-ITEM->PIU-VENDOR-ITEM
  PIU-DATE
  PIU-TIME
  PIU-FLD-NBR


File created: Thu Jun 09 02:27:04 2016

Home
Contact Us



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