ITEMUPC

Item Universal Product Code

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

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.
IPC-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
IPC-UPC
Element: Upc
Alpha 15
Universal Product Code.
IPC-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
IPC-UOM-COST
Element: Intl Cost
Signed 18.5
IPC-UPC-TYPE
Element: Upc Type
Alpha 1
Unverversal Product Code type.
P = Primary
IPC-ZERO-SUPP-FL
Element: Zero Supp Fl
Alpha 6
Indicates whether leading zeros on the UPC need to be suppressed.
IPC-USE-SALE-UOM
Element: Use Sale Uom
Alpha 1
Use sale unit of measure flag.
N = No
Y = Yes
IPC-SALE-BY-MFG
Element: Sale By Mfg
Alpha 1
Sale by manufacturer flag.
N = No
Y = Yes
IPC-SALE-BY-DISTR
Element: Sale By Distr
Alpha 1
Sale by distributor flag.
N = No
Y = Yes
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
IPCSET2 UPC
ITEM-GROUP
IPCSET5 ITEM-GROUP
UPC
Subset
WhereUPC !=Spaces
IPCSET6 ITEM-GROUP
ITEM
UOM
UPC
POI7.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: Wed Jun 08 20:49:40 2016

Home
Contact Us



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