ITEMUPN2

Item UPN2

The Item UPN2 file contains the Universal Product Number information related related to an item in the Item Master file.
UPDATED BY
IC11.1 IC11.4 IC511 IC598 IC800 ICI6.1
ICI8.1 PO150 PO25.6 PO25.7 PO26.4 PO26.5
PO26.8 PO28.2 PO36.2 PO536 RQIC.1 RQID.1
RQIF.1 RQIG.1 RQIH.1 RQIJ.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IP2-ITEM-GROUP
Element: Item Group		Alpha 5
This field contains the identifier for a group of items that can be shared by one or more companies.
ICI6.1 ICI8.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IP2-ITEM
Element: Item		Alpha 32
This field contains the item identifier.
ICI6.1 ICI8.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IP2-UPN2-NBR
Element: Upn2 Nbr		Alpha 25 (Right Justified)
Universal Product Number.
ICI6.1 ICI8.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IP2-REPL-UPN2
Element: Repl Upn2		Alpha 25 (Right Justified)
Replacement UPN2.
ICI6.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IP2-MFG-PD-DESC
Element: Mfg Pd Desc		Alpha 80
Manufacturer's product description.
ICI6.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IP2-SALE-BY-DISTR
Element: Sale By Distr		Alpha 1
Sale by distributor flag.
N = No
Y = Yes
ICI6.1 ICI8.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IP2-SALE-BY-MFG
Element: Sale By Mfg		Alpha 1
Sale by manufacturer flag.
N = No
Y = Yes
ICI6.1 ICI8.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IP2-TRADE-NAME
Element: Trade Name		Alpha 30
Trade name for the product.
ICI6.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IP2-UOM
Element: Uom		Alpha 4
This field contains the valid stock unit of measure for this item.
ICI6.1 ICI8.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IP2-UOM-COST
Element: Intl Cost		Signed 18.5
ICI6.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IP2-MFG-NAME
Element: Mfg Name		Alpha 35 (Lower Case)
ICI6.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IP2-MFG-DIVISION
Element: Mfg Division		Alpha 35 (Lower Case)
ICI6.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IP2-ITEM-TYPE-UPN2
Element: Item Type Upn2		Derived


ITEMUPN2 FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IP2SET1 ITEM-GROUP
ITEM
UPN2-NBR
IC11.1 IC11.4
IC511 IC598
IC800 ICI6.1
ICI8.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IP2SET2 UPN2-NBR
ITEM-GROUP
ICI6.1 ICI8.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQIC.1
RQID.1 RQIF.1
RQIG.1 RQIH.1
RQIJ.1
IP2SET5 ITEM-GROUP
ITEM
UOM
UPN2-NBR
IC11.1 ICI6.1
ICI8.1 RQIC.1
RQID.1 RQIF.1
RQIG.1 RQIH.1
RQIJ.1
IP2SET6 ITEM-GROUP
UPN2-NBR
KeyChange


ITEMUPN2 FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 11:17:24 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.