ITEMUPC

Item Universal Product Code

The Item UPC file contains all the Universal Product Codes related to an item on the Item Master file.

REFERENCED BY
WH20.2 WH20.7


UPDATED BY
IC11.1 IC11.2 IC511 IC598 IC800 ICI4.1
ICI8.1 PO150 PO25.6 PO25.7 PO26.4 PO26.5
PO26.8 PO28.2 PO36.2 PO536 POI7.1 RQIC.1
RQID.1 RQIF.1 RQIG.1 RQIH.1 RQIJ.1 WH130
WH132 WH190 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IPC-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.
ICI4.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
IPC-ITEM
Element: Item		Alpha 32
This field contains the item identifier.
ICI4.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
IPC-UPC
Element: Upc		Alpha 15
Universal Product Code.
ICI4.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
IPC-UOM
Element: Uom		Alpha 4
This field contains the valid stock unit of measure for this item.
ICI4.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
IPC-UOM-COST
Element: Intl Cost		Signed 18.5
ICI4.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IPC-UPC-TYPE
Element: Upc Type		Alpha 1
Unverversal Product Code type.
P = Primary
ICI4.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IPC-ZERO-SUPP-FL
Element: Zero Supp Fl		Alpha 6
Indicates whether leading zeros on the UPC need to be suppressed.
ICI4.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IPC-USE-SALE-UOM
Element: Use Sale Uom		Alpha 1
Use sale unit of measure flag.
N = No
Y = Yes
ICI4.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IPC-SALE-BY-MFG
Element: Sale By Mfg		Alpha 1
Sale by manufacturer flag.
N = No
Y = Yes
ICI4.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
IPC-SALE-BY-DISTR
Element: Sale By Distr		Alpha 1
Sale by distributor flag.
N = No
Y = Yes
ICI4.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
IPC-ITEM-TYPE-UPC
Element: Item Type Upc		Derived


ITEMUPC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IPCSET1 ITEM-GROUP
ITEM
UPC
...
IC11.1 IC11.2
IC511 IC598
IC800 ICI4.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 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
IPCSET2 UPC
ITEM-GROUP
ICI4.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
IPCSET5 ITEM-GROUP
UPC
Subset
WhereUPC !=Spaces
ICI4.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
WH20.2 WH20.7
IPCSET6 ITEM-GROUP
ITEM
UOM
UPC
IC11.1 ICI4.1
ICI8.1 POI7.1
RQIC.1 RQID.1
RQIF.1 RQIG.1
RQIH.1 RQIJ.1


ITEMUPC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Itemupctoitem ITEMMAST Required
IPC-ITEM-GROUP->ITE-ITEM-GROUP
IPC-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.