Lawson Insight Technical Documentation |
|
POITEMVEN
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
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 DR100 IC11.1 IC141 IC142
IC211 IC270 IC28.1 IC281 IC520 IC521
IC522 IC524 IC525 IC526 IC527 IC598
IC800 IC83.1 ICI1.1 SEA1.1 MA180 MA530
MA540 MA60.2 MA60.3 MA60.5 MA61.1 MA65.1
MA66.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.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 OE111 OE113 OE114
OE116 OE129 OE13.2 OE13.3 OE13.5 OE13.6
OE14.4 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE510 OE530 OE81.1
OE810 OE830 OE90.1 OE90.2 PO00.1 PO100
PO101 PO122 PO131 PO16.1 PO16.2 PO20.1
PO21.2 PO21.3 PO21.4 PO21.5 PO213 PO216
PO22.1 PO220 PO223 PO23.1 PO29.1 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO520 PO560
PO72.1 POI3.1 POIE.1 POII.1 POIJ.1 RQ10.1
RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ500 RQIC.1 RQID.1 RQIF.1 RQIG.1
RQIJ.1 WH20.2 WH20.7 PO258 PO58.1 PO58.2
POI7.1
UPDATED BY
MA531 PO13.1 PO150 PO25.6 PO25.7 PO30.1
PO30.2 PO30.3 PO35.1 PO36.2 PO52.1 PO536
PO813
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIV-PROCURE-GROUP Alpha 4 PO13.1 PO150
Element: Procure Group This field contains the identifier for a PO25.6 PO25.7
group of companies that share a common PO36.2 PO536
procurement effort. They buy items and PO813
services together.
PIV-ITEM Alpha 32 PO13.1 PO150
Element: Item Number This field contains the item PO25.6 PO25.7
identifier. PO36.2 PO536
PO813
PIV-VENDOR Alpha 9 (Right Justified) PO13.1 PO150
Element: Vendor ID The vendor's identification code. PO25.6 PO25.7
PO36.2 PO536
PO813
PIV-VEN-ITEM Alpha 32 PO13.1 PO150
Element: Item Number The vendor's item identifier. PO25.6 PO25.7
PO36.2 PO536
PO813
PIV-VEN-ITEM-DESC Alpha 30 (Lower Case) PO13.1 PO150
Element: Description The description of the vendor's item PO25.6 PO25.7
identifier. PO36.2 PO536
PO813
PIV-VBUY-UOM Alpha 4 PO13.1 PO813
Element: Unit of MeasurThe vendor's buying unit of measure.
PIV-VPRI-UOM Alpha 4 PO13.1 PO813
Element: Unit of MeasurThis is the vendor pricing unit of
measure.
PIV-MANUF-CODE Alpha 4 PO13.1 PO150
Element: Manufacturer'sThis field contains a user defined code PO25.6 PO25.7
that indicates the manufacturer of an PO36.2 PO536
item. PO813
PIV-MANUF-DIVISION Alpha 4 PO13.1 PO150
Manufacturer's This is a user defined code that PO25.6 PO25.7
Division indicates which division of a PO36.2 PO536
manufacturer is tied to an item. PO813
PIV-MANUF-NBR Alpha 15 PO13.1 PO150
Manufacturer's Item This is the identifier that the PO25.6 PO25.7
Number manufacturer has assigned to an item. PO36.2 PO536
PO813
PIV-LIC-CODE Alpha 4 PO13.1 PO150
Element: Lic Code The Labeler Identification Code (LIC) PO25.6 PO25.7
is assigned to any organization in the PO36.2 PO536
healthcare industry. The LIC is used PO813
with bar code technology to identify the
company that put the label on the
product.
PIV-LAST-LEADTIME Numeric 3 MA531 PO13.1
Leadtime Number of This field contains the difference in PO30.1 PO30.2
Days days between the purchase order date and PO30.3 PO35.1
the received date for the last purchase PO52.1
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 PO813
Element: Min Ord Qty
PIV-WARRANTY-PER Numeric 6 PO13.1 PO813
Element: Warranty Per
PIV-ITEM-CODE-USED Derived
Element: Item Code Used
POITEMVEN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PIVSET1 PROCURE-GROUP AP125 AP126
ITEM AP131 AP25.1
VENDOR AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC11.1
IC141 IC142
IC211 IC270
IC28.1 IC281
IC520 IC521
...
PIVSET2 PROCURE-GROUP AP125 AP126
VEN-ITEM AP131 AP25.1
ITEM AP25.2 AP26.1
VENDOR AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
...
PIVSET3 PROCURE-GROUP AP125 AP126
VENDOR AP131 AP25.1
VEN-ITEM AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
...
PIVSET4 PROCURE-GROUP PO13.1 PO150
VENDOR PO16.1 PO16.2
ITEM PO25.6 PO25.7
PO36.2 PO536
RQIC.1 RQIG.1
PIVSET5 PROCURE-GROUP PO150 PO25.6
VENDOR PO25.7 PO36.2
MANUF-CODE PO536
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
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
POITEMVEN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemndc ITEMNDC
PCG-ITEM-GROUP -> IDC-ITEM-GROUP
PIV-ITEM -> IDC-ITEM
IDC-NDC-NBR
|