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
DR100 IC11.1 IC141 IC142 IC211 IC281
IC520 IC521 IC522 IC524 IC525 IC526
IC527 IC83.1 ICI1.1 SEA1.1 MA65.1 PO00.1
PO130 PO16.1 PO16.2 PO213 PO216 PO220
PO223 PO560 PO72.1 POIJ.1 RQ11.1 SEA3.1
POI7.1
UPDATED BY
PO13.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIV-PROCURE-GROUP Alpha 4 PO13.1
Procure Group This field contains the identifier for a
group of companies that share a common
procurement effort. They buy items and
services together.
PIV-ITEM Alpha 32 PO13.1
Item Number This field contains the item
identifier.
PIV-VENDOR Alpha 9 (Right Justified) PO13.1
Vendor ID The vendor's identification code.
PIV-VEN-ITEM Alpha 32 PO13.1
Vendor Item The vendor's item identifier.
PIV-VEN-ITEM-DESC Alpha 30 (Lower Case) PO13.1
Vendor Item The description of the vendor's item
Description identifier.
PIV-VBUY-UOM Alpha 4 PO13.1
Vendor Buy Unit of The vendor's buying unit of measure.
Measure
PIV-VPRI-UOM Alpha 4 PO13.1
Vendor Price Unit This is the vendor pricing unit of
of Measure measure.
PIV-MANUF-CODE Alpha 4 PO13.1
Manufacturer's Code This field contains a user defined code
that indicates the manufacturer of an
item.
PIV-MANUF-DIVISION Alpha 4 PO13.1
Manufacturer's This is a user defined code that
Division indicates which division of a
manufacturer is tied to an item.
PIV-MANUF-NBR Alpha 15 PO13.1
Manufacturer's Item This is the identifier that the
Number manufacturer has assigned to an item.
PIV-LIC-CODE Alpha 4 PO13.1
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
Last Lead Time 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 the Purchase
Order system. The field is display only
in the item vendor record, it is not
used for defaulting.
PIV-MIN-ORD-QTY Signed 13.4 PO13.1
Min Ord Qty
PIV-WARRANTY-PER Numeric 6 PO13.1
Warranty Per
POITEMVEN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PIVSET1 PROCURE-GROUP DR100 IC11.1
ITEM IC141 IC142
VENDOR IC211 IC281
IC520 IC521
IC522 IC524
IC525 IC526
IC527 IC83.1
ICI1.1 SEA1.1
MA65.1 PO00.1
PO13.1 PO130
PO16.1 PO213
PO216 PO220
PO223 PO560
PO72.1 POIJ.1
RQ11.1 SEA3.1
PIVSET2 PROCURE-GROUP PO16.1 PO560
VEN-ITEM PO72.1 POIJ.1
ITEM
VENDOR
PIVSET3 PROCURE-GROUP DR100 IC141
VENDOR IC142 IC83.1
VEN-ITEM MA65.1 PO13.1
PO16.1 PO16.2
PO560 POI7.1
POIJ.1 RQ11.1
PIVSET4 PROCURE-GROUP PO13.1 PO16.1
VENDOR PO16.2
ITEM
PIVSET5 PROCURE-GROUP
VENDOR
MANUF-CODE
MANUF-DIVISION
MANUF-NBR
ITEM
POITEMVEN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
Procuregrp PROCUREGRP Required
PIV-PROCURE-GROUP -> PCG-PROCURE-GROUP
|
