POITEMVEN FILE
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
BL92.1 CX05.1 CX205 DR100 IC11.1 IC140
IC141 IC142 IC211 IC225 IC281 IC520
IC521 IC522 IC523 IC524 IC525 IC526
IC527 IC83.1 PC120 PC20.1 PC540 SEA1.1
IN20.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE113 OE114 OE129 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE510 OE810 OE920 PO100 PO115 PO120
PO121 PO123 PO130 PO16.1 PO16.2 PO20.1
PO21.1 PO213 PO214 PO216 PO22.2 PO22.3
PO220 PO221 PO223 PO25.1 PO25.2 PO28.5
PO31.1 PO34.1 PO560 PO72.1 PO72.2 PO821
RQ10.1 RQ10.3 RQ11.1 RQ125 RQ20.1 RQ20.2
RQ20.4 RQ35.1 RQ500 SEA3.1 WH20.2 WH20.7
MA540 PO122 PO15.1
UPDATED BY
PO13.1 PO14.1 PO150 PO30.1 PO35.1 PO530
PO813
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIV-COMPANY Numeric 4 PO13.1 PO14.1
Company The company number. PO150 PO813
PIV-ITEM Alpha 32 PO13.1 PO14.1
Item Number This field contains the item PO150 PO813
identifier.
PIV-VENDOR Alpha 9 PO13.1 PO14.1
Vendor ID The vendor's identification code. PO150 PO813
PIV-VEN-ITEM Alpha 32 PO13.1 PO14.1
Vendor Item The vendor's item identifier. PO150 PO28.5
PO813
PIV-VEN-ITEM-DESC Alpha 30 (Lower Case) PO13.1 PO14.1
Vendor Item The description of the vendor's item PO150 PO28.5
Description identifier. PO813
PIV-VBUY-UOM Alpha 4 PO13.1 PO14.1
Vendor Buy Unit of The vendor's buying unit of measure. PO150 PO813
Measure
PIV-VBUY-UOM-MULT Signed 13.7 PO13.1 PO14.1
Vendor Buy UOM Vendor buy unit of measure multiplier. PO150 PO813
Multiplier Used to convert quantity and unit cost.
PIV-VBUY-UOM-CONV Signed 10.5 PO13.1 PO14.1
Vend Buy UOM The vendor buy unit of measure PO150 PO813
Conversion Factor conversion factor.
PIV-VPRI-UOM Alpha 4 PO13.1 PO14.1
Vendor Price Unit This is the vendor pricing unit of PO150 PO813
of Measure measure.
PIV-VPRI-UOM-MULT Signed 13.7 PO13.1 PO14.1
Vendor Price UOM This is the vendor pricing unit of PO150 PO813
Multiplier measure multiplier. It is used to
convert unit cost to stock unit of
measure terms.
PIV-VPRI-UOM-CONV Signed 10.5 PO13.1 PO14.1
Vendor Price UOM The vendor pricing unit of measure PO150 PO813
Conversion conversion factor.
PIV-MANUF-CODE Alpha 4 CX205 IC281
Manufacturer's Code This field contains a user defined code IC521 IC522
that indicates the manufacturer of an IC524 IC525
item. IC526 IC527
PO100 PO120
PO123 PO13.1
PO150 PO16.1
PO20.1 PO22.3
PO31.1 PO813
RQ20.1 RQ20.4
PIV-MANUF-DIVISION Alpha 4 CX205 IC281
Manufacturer's This is a user defined code that IC521 IC522
Division indicates which division of a IC524 IC525
manufacturer is tied to an item. IC526 IC527
PO100 PO120
PO123 PO13.1
PO150 PO16.1
PO20.1 PO22.3
PO31.1 PO813
RQ20.1 RQ20.4
PIV-MANUF-NBR Alpha 15 CX205 IC281
Manufacturer's Item This is the identifier that the IC521 IC522
Number manufacturer has assigned to an item. IC524 IC525
IC526 IC527
PO100 PO120
PO123 PO13.1
PO150 PO16.1
PO20.1 PO22.3
PO31.1 PO813
RQ20.1 RQ20.4
PIV-LIC-CODE Alpha 4 PO13.1 PO813
Lic Code 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.
PIV-LAST-LEADTIME Numeric 3 PO13.1 PO30.1
Last Lead Time This field contains the difference in PO35.1 PO530
days between the purchase order date and PO813
the received date for the last purchase
order for this item. This field is
updated by the Purchase Order system.
POITEMVEN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PIVSET1 COMPANY BL92.1 CX05.1
ITEM CX205 DR100
VENDOR IC11.1 IC140
IC141 IC142
IC211 IC225
IC281 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC83.1
PC120 PC20.1
PC540 SEA1.1
IN20.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
...
PIVSET2 COMPANY MA540 PO122
VEN-ITEM PO16.1 PO530
ITEM PO560 PO72.1
VENDOR
PIVSET3 COMPANY DR100 IC141
VENDOR IC142 IC83.1
VEN-ITEM MA540 PO122
PO13.1 PO14.1
PO15.1 PO150
PO16.1 PO16.2
PO530 PO560
PO813 RQ10.1
RQ10.3 RQ11.1
RQ20.1 RQ35.1
RQ500 WH20.7
PIVSET4 COMPANY PO13.1 PO15.1
VENDOR PO16.1 PO16.2
ITEM
POITEMVEN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
PIV-COMPANY -> CPY-COMPANY
Company ICCOMPANY Required
PIV-COMPANY -> ICC-COMPANY
Icmanufcode ICMANFCODE Required
When PIV-MANUF-CODE != Spaces
ICC-ITEM-GROUP -> IMC-ITEM-GROUP
PIV-MANUF-CODE -> IMC-MANUF-CODE
PIV-MANUF-DIVISION -> IMC-MANUF-DIVISION
Itemmaster ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
PIV-ITEM -> ITE-ITEM
Vendmast APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
PIV-VENDOR -> VEN-VENDOR
POITEMVEN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Poquotes POQUOTES Delete Restricted
PIV-COMPANY -> POQ-COMPANY
PIV-VENDOR -> POQ-VENDOR
PIV-ITEM -> POQ-ITEM
POQ-PURCH-FR-LOC
POQ-LOCATION
|