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 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 DR100 IC11.1
IC140 IC141 IC142 IC211 IC270 IC28.1
IC281 IC520 IC521 IC522 IC524 IC525
IC526 IC527 IC598 IC800 IC83.1 ICI1.1
PC20.1 SEA1.1 MA180 MA41.2 MA41.7 MA43.1
MA43.2 MA43.3 MA43.9 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
PO00.1 PO100 PO101 PO122 PO131 PO16.1
PO16.2 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO213 PO216 PO22.1 PO220 PO223
PO23.1 PO27.2 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
POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1
RQ12.1 RQ13.1 RQ35.1 RQ500 RQIC.1 RQID.1
RQIE.1 RQIF.1 RQIG.1 RQIH.1 RQIJ.1 SEA3.1
SEA4.1 WH20.2 WH20.7 PO258 PO58.1 PO58.2
PO737 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 PO25.6 PO25.7
PO36.2 PO536
PO813
PIV-VBUY-UOM Alpha 4 PO13.1 PO813
Element: Unit of Measure
PIV-VPRI-UOM Alpha 4 PO13.1 PO813
Element: 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
Accounts Receivable PO25.6 PO25.7
Code PO36.2 PO536
PO813
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 AP20.1
VENDOR AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC11.1
IC140 IC141
IC142 IC211
IC270 IC28.1
IC281 IC520
IC521 IC522
IC524 IC525
...
PIVSET2 PROCURE-GROUP AP125 AP126
VEN-ITEM AP131 AP20.1
ITEM AP20.2 AP20.3
VENDOR AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
...
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
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
...
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
|