Lawson Insight Technical Documentation |
|
ITEMUPN2
ITEMUPN2 FILE
Item UPN2
The Item UPN2 file contains the Universal Product Number information related
related to an item in the Item Master file.
REFERENCED BY
IC11.1 IC11.4 IC800 ICI8.1 RQID.1 RQIF.1
RQIH.1 RQIJ.1 RQIC.1 RQIG.1
UPDATED BY
ICI6.1 PO150 PO25.6 PO25.7 PO36.2 PO536
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IP2-ITEM-GROUP Alpha 5 ICI6.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
IP2-ITEM Alpha 32 ICI6.1 ICI8.1
Element: Item This field contains the item PO150 PO25.6
identifier. PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IP2-UPN2-NBR Alpha 25 (Right Justified) ICI6.1 ICI8.1
Element: Upn2 Nbr Universal Product Number. PO150 PO25.6
PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IP2-REPL-UPN2 Alpha 25 (Right Justified) ICI6.1 ICI8.1
Element: Repl Upn2 Replacement UPN2. RQID.1 RQIF.1
RQIH.1 RQIJ.1
IP2-MFG-PD-DESC Alpha 80 ICI6.1 ICI8.1
Element: Mfg Pd Desc Manufacturer's product description. RQID.1 RQIF.1
RQIH.1 RQIJ.1
IP2-SALE-BY-DISTR Alpha 1 ICI6.1 ICI8.1
Element: Sale By Distr Sale by distributor flag. PO150 PO25.6
N = No PO25.7 PO36.2
Y = Yes PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IP2-SALE-BY-MFG Alpha 1 ICI6.1 ICI8.1
Element: Sale By Mfg Sale by manufacturer flag. PO150 PO25.6
N = No PO25.7 PO36.2
Y = Yes PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IP2-TRADE-NAME Alpha 30 ICI6.1 ICI8.1
Element: Trade Name Trade name for the product. RQID.1 RQIF.1
RQIH.1 RQIJ.1
IP2-UOM Alpha 4 ICI6.1 ICI8.1
Element: Uom This 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
IP2-UOM-COST Signed 18.5 ICI6.1 ICI8.1
Element: Intl Cost RQID.1 RQIF.1
RQIH.1 RQIJ.1
IP2-MFG-NAME Alpha 35 (Lower Case) ICI6.1 ICI8.1
Element: Mfg Name RQID.1 RQIF.1
RQIH.1 RQIJ.1
IP2-MFG-DIVISION Alpha 35 (Lower Case) ICI6.1 ICI8.1
Element: Mfg Division RQID.1 RQIF.1
RQIH.1 RQIJ.1
IP2-ITEM-TYPE-UPN2 Derived
Element: Item Type Upn2
ITEMUPN2 FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IP2SET1 ITEM-GROUP IC11.1 IC11.4
ITEM IC800 ICI6.1
UPN2-NBR ICI8.1 PO150
PO25.6 PO25.7
PO36.2 PO536
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IP2SET2 UPN2-NBR ICI6.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
IP2SET5 ITEM-GROUP ICI6.1 ICI8.1
ITEM RQIC.1 RQID.1
UOM RQIF.1 RQIG.1
UPN2-NBR RQIH.1 RQIJ.1
IP2SET6 ITEM-GROUP KeyChange
UPN2-NBR
ITEMUPN2 FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemupn2toitem ITEMMAST Required
IP2-ITEM-GROUP -> ITE-ITEM-GROUP (ITESET1)
IP2-ITEM -> ITE-ITEM
Upn2toitem ITEMMAST Required
IP2-ITEM-GROUP -> ITE-ITEM-GROUP
IP2-ITEM -> ITE-ITEM
|