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 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 AP30.2 API1.1
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
CXCP.1 IC11.1 IC14.1 IC211 IC800 ICI1.1
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.7 MA43.4 MA43.6 MA530
MA540 MA60.2 MA60.3 MA60.5 MA61.1 MA65.1
MA66.2 MA66.3 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 PO00.1
PO100 PO101 PO122 PO131 PO16.1 PO16.2
PO190 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO213 PO216 PO22.1 PO220 PO223
PO23.1 PO24.1 PO27.2 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 PO560
PO72.1 POCP.1 POI3.1 POID.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 RQIH.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 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 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 AM500
AM51.1 AM551 AM97.1 AP03.3 AP110 AP115
AP210 AP220 AP300 AP305 AP510 AP90.1
AP91.1 API2.1 API3.1 API4.1 MX123 MX500
MA279 MA63.1 PD235 PO10.1 PO120 PO233
PO253 PO254 PO278 PO54.1 PO54.2 PO54.3
PO54.4 POI7.1 PR05.1 PR05.3 PR226 PR247
PR26.1 PR47.1 PR514 UK47.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 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 The vendor's identification code. PO25.6 PO25.7
PO36.2 PO536
PO813
PIV-VEN-ITEM Alpha 32 PO13.1 PO150
Element: Item 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 This field displays the description. PO25.6 PO25.7
PO36.2 PO536
PO813
PIV-VBUY-UOM Alpha 4 PO13.1 PO813
Element: Uom This field contains the valid stock
unit of measure for this item.
PIV-VPRI-UOM Alpha 4 PO13.1 PO813
Element: Uom This field contains the valid stock
unit of measure for this item.
PIV-MANUF-CODE Alpha 4 PO13.1 PO150
Element: Manuf Code This 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
Element: Manuf DivisionThis is a user defined code that PO25.6 PO25.7
indicates which division of a PO36.2 PO536
manufacturer is tied to an item. PO813
PIV-MANUF-NBR Alpha 15 PO13.1 PO150
Element: Manuf Nbr This is the identifier that the PO25.6 PO25.7
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
Element: Leadtime Days 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 Purchase Order.
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 AP20.1
VENDOR AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
...
PIVSET2 PROCURE-GROUP AP125 AP126
VEN-ITEM AP131 AP20.1
ITEM AP20.2 AP20.3
VENDOR AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
PIVSET3 PROCURE-GROUP AC160 AM115
VENDOR AM117 AM15.1
VEN-ITEM AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.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
|