Lawson Insight Technical Documentation |
|
ITEMUPN1
ITEMUPN1 FILE
Item UPN1
The Item UPN1 file contains the Universal Product Number information related
to an item in the Item Master file.
REFERENCED BY
IC11.1 IC11.3 IC598 IC800 ICI8.1 RQID.1
RQIF.1 RQIH.1 RQIJ.1 RQIC.1 RQIG.1
UPDATED BY
ICI5.1 PO150 PO25.6 PO25.7 PO36.2 PO536
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IPN-ITEM-GROUP Alpha 5 ICI5.1 ICI8.1
Element: Item Group This field contains the identifier for PO150 PO25.6
a group of items that can be shared by PO25.7 PO36.2
one or more companies. PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IPN-ITEM Alpha 32 ICI5.1 ICI8.1
Element: Item Number This field contains the item PO150 PO25.6
identifier. PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IPN-UPN-NBR Alpha 20 ICI5.1 ICI8.1
Universal Product Universal Product Number. PO150 PO25.6
Number PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IPN-REPL-UPN1 Alpha 20 ICI5.1 ICI8.1
Element: Replacement UPReplacement UPN. RQID.1 RQIF.1
RQIH.1 RQIJ.1
IPN-MFG-PD-DESC Alpha 80 ICI5.1 ICI8.1
Manufacturer's Manufacturer's product description. RQID.1 RQIF.1
Product Desc RQIH.1 RQIJ.1
IPN-SALE-BY-DISTR Alpha 1 ICI5.1 ICI8.1
Element: Sale by DistriSale by distributor flag. PO150 PO25.6
PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IPN-SALE-BY-MFG Alpha 1 ICI5.1 ICI8.1
Element: Sale by ManufaSale by manufacturer flag. PO150 PO25.6
PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IPN-TRADE-NAME Alpha 30 ICI5.1 ICI8.1
Element: Trade Name Trade name for the product. RQID.1 RQIF.1
RQIH.1 RQIJ.1
IPN-UOM Alpha 4 ICI5.1 ICI8.1
Element: Unit of MeasurThis field contains the valid stock PO150 PO25.6
unit of measure for this item. PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IPN-UOM-COST Signed 18.5 ICI5.1 ICI8.1
Element: Intl Cost Unit of measure cost. RQID.1 RQIF.1
RQIH.1 RQIJ.1
IPN-MFG-NAME Alpha 35 (Lower Case) ICI5.1 ICI8.1
Element: Mfg Name RQID.1 RQIF.1
RQIH.1 RQIJ.1
IPN-MFG-DIVISION Alpha 35 (Lower Case) ICI5.1 ICI8.1
Element: Mfg Division RQID.1 RQIF.1
RQIH.1 RQIJ.1
IPN-ITEM-TYPE-UPN1 Derived
Element: Item Type Upn1
ITEMUPN1 FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IPNSET1 ITEM-GROUP IC11.1 IC11.3
ITEM IC598 IC800
UPN-NBR ICI5.1 ICI8.1
PO150 PO25.6
PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IPNSET2 UPN-NBR ICI5.1 ICI8.1
ITEM-GROUP PO150 PO25.6
PO25.7 PO36.2
PO536 RQIC.1
RQID.1 RQIF.1
RQIG.1 RQIH.1
RQIJ.1
IPNSET5 ITEM-GROUP ICI5.1 ICI8.1
ITEM RQIC.1 RQID.1
UOM RQIF.1 RQIG.1
UPN-NBR RQIH.1 RQIJ.1
IPNSET6 ITEM-GROUP KeyChange
UPN-NBR
ITEMUPN1 FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemupn1toitem ITEMMAST Required
IPN-ITEM-GROUP -> ITE-ITEM-GROUP (ITESET1)
IPN-ITEM -> ITE-ITEM
Upn1toitem ITEMMAST Required
IPN-ITEM-GROUP -> ITE-ITEM-GROUP
IPN-ITEM -> ITE-ITEM
|