 |
Lawson Insight Technical Documentation |
|
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 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 DR100 IC11.1 IC141 IC142
IC211 IC28.1 IC281 IC520 IC521 IC522
IC524 IC525 IC526 IC527 IC598 IC83.1
ICI1.1 SEA1.1 MA180 MA41.2 MA43.1 MA43.2
MA43.3 MA43.9 MA530 MA540 MA60.2 MA60.3
MA60.5 MA61.1 MA65.1 MA66.3 MA67.1 MA67.2
MA70.1 MAI1.1 PO00.1 PO100 PO101 PO122
PO130 PO131 PO150 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 RQ35.1 RQ500 RQIC.1
RQID.1 RQIF.1 RQIG.1 SEA3.1 SEA4.1 WH20.2
WH20.7 PO25.1 PO25.7 PO25.8 PO27.2 PO27.4
POI7.1
UPDATED BY
MA531 PO13.1 PO30.1 PO30.2 PO30.3 PO35.1
PO52.1 PO813
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIV-PROCURE-GROUP Alpha 4 PO13.1 PO813
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 PO813
Item Number This field contains the item
identifier.
PIV-VENDOR Alpha 9 (Right Justified) PO13.1 PO813
Vendor ID The vendor's identification code.
PIV-VEN-ITEM Alpha 32 PO13.1 PO813
Vendor Item The vendor's item identifier.
PIV-VEN-ITEM-DESC Alpha 30 (Lower Case) PO13.1 PO813
Vendor Item The description of the vendor's item
Description identifier.
PIV-VBUY-UOM Alpha 4 PO13.1 PO813
Vendor Buy Unit of The vendor's buying unit of measure.
Measure
PIV-VPRI-UOM Alpha 4 PO13.1 PO813
Vendor Price Unit This is the vendor pricing unit of
of Measure measure.
PIV-MANUF-CODE Alpha 4 PO13.1 PO813
Manufacturer's Code This field contains a user defined code
that indicates the manufacturer of an
item.
PIV-MANUF-DIVISION Alpha 4 PO13.1 PO813
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 PO813
Manufacturer's Item This is the identifier that the
Number manufacturer has assigned to an item.
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 MA531 PO13.1
Last Lead Time This field contains the difference in PO30.1 PO30.2
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
Min Ord Qty
PIV-WARRANTY-PER Numeric 6 PO13.1 PO813
Warranty Per
POITEMVEN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PIVSET1 PROCURE-GROUP AP125 AP126
ITEM AP131 AP20.1
VENDOR AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
DR100 IC11.1
IC141 IC142
IC211 IC28.1
IC281 IC520
IC521 IC522
IC524 IC525
IC526 IC527
IC598 IC83.1
...
PIVSET2 PROCURE-GROUP AP125 AP126
VEN-ITEM AP131 AP25.1
ITEM AP25.2 AP26.1
VENDOR AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO16.1 PO20.1
PO21.2 PO21.3
...
PIVSET3 PROCURE-GROUP AP125 AP126
VENDOR AP131 AP20.1
VEN-ITEM AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
...
PIVSET4 PROCURE-GROUP PO13.1 PO150
VENDOR PO16.1 PO16.2
ITEM PO25.1 PO25.7
PO25.8 PO27.2
PO27.4
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
|