ITEMUPN1

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 IC511 IC598 IC800 ICI8.1
RQID.1 RQIF.1 RQIH.1 RQIJ.1 IC524 RQIC.1
RQIG.1


UPDATED BY
ICI5.1 PO150 PO25.6 PO25.7 PO26.4 PO26.5
PO26.8 PO28.2 PO36.2 PO536

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IPN-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.
ICI5.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
IPN-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
ICI5.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
IPN-UPN-NBR
Element: Upn Nbr
Alpha 20
Universal Product Number.
ICI5.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
IPN-REPL-UPN1
Element: Repl Upn1
Alpha 20
Replacement UPN.
ICI5.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IPN-MFG-PD-DESC
Element: Mfg Pd Desc
Alpha 80
Manufacturer's product description.
ICI5.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IPN-SALE-BY-DISTR
Element: Sale By Distr
Alpha 1
Sale by distributor flag.
ICI5.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
IPN-SALE-BY-MFG
Element: Sale By Mfg
Alpha 1
Sale by manufacturer flag.
ICI5.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
IPN-TRADE-NAME
Element: Trade Name
Alpha 30
Trade name for the product.
ICI5.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IPN-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
ICI5.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
IPN-UOM-COST
Element: Intl Cost
Signed 18.5
ICI5.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IPN-MFG-NAME
Element: Mfg Name
Alpha 35 (Lower Case)
ICI5.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IPN-MFG-DIVISION
Element: Mfg Division
Alpha 35 (Lower Case)
ICI5.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IPN-ITEM-TYPE-UPN1
Element: Item Type Upn1
Derived


ITEMUPN1 FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IPNSET1 ITEM-GROUP
ITEM
UPN-NBR
IC11.1 IC11.3
IC511 IC598
IC800 ICI5.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
IPNSET2 UPN-NBR
ITEM-GROUP
ICI5.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
IPNSET5 ITEM-GROUP
ITEM
UOM
UPN-NBR
IC11.1 IC524
ICI5.1 ICI8.1
RQIC.1 RQID.1
RQIF.1 RQIG.1
RQIH.1 RQIJ.1
IPNSET6 ITEM-GROUP
UPN-NBR
KeyChange


ITEMUPN1 FILE RELATIONS


ONE TO ONE RELATIONS

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


File created: Thu Jun 09 02:19:06 2016

Home
Contact Us



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