ITEMUPC FILE
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
IC11.1 IC11.2 ICI8.1 WH130 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 POI7.1
UPDATED BY
ICI4.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IPC-ITEM-GROUP Alpha 5 ICI4.1 ICI8.1
Item Group This field contains the identifier for
a group of items that can be shared by
one or more companies.
IPC-ITEM Alpha 32 ICI4.1 ICI8.1
Item Number This field contains the item
identifier.
IPC-UPC Alpha 15 ICI4.1 ICI8.1
Universal Product Universal Product Code.
Code
IPC-UOM Alpha 4 ICI4.1 ICI8.1
Unit of Measure This field contains the valid stock
unit of measure for this item.
IPC-UOM-COST Signed 13.5 ICI4.1 ICI8.1
Unit of Measure Cost Unit of measure cost.
IPC-UPC-TYPE Alpha 1 ICI4.1 ICI8.1
Universal Product Unverversal Product Code type.
Code Type
IPC-ZERO-SUPP-FL Alpha 6 ICI4.1 ICI8.1
Zero Suppress Flag Indicates whether leading zeros on the
UPC need to be suppressed.
IPC-USE-SALE-UOM Alpha 1 ICI4.1 ICI8.1
Use Sale Unit of Use sale unit of measure flag.
Measure N = No
Y = Yes
IPC-SALE-BY-MFG Alpha 1 ICI4.1 ICI8.1
Sale by Manufacturer Sale by manufacturer flag.
N = No
Y = Yes
IPC-SALE-BY-DISTR Alpha 1 ICI4.1 ICI8.1
Sale by Distributor Sale by distributor flag.
N = No
Y = Yes
ITEMUPC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IPCSET1 ITEM-GROUP IC11.1 IC11.2
ITEM ICI4.1 ICI8.1
UPC WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
IPCSET2 UPC ICI4.1 ICI8.1
IPCSET5 ITEM-GROUP Subset ICI4.1 ICI8.1
UPC Where UPC != Spaces
IPCSET6 ITEM-GROUP IC11.1 ICI4.1
ITEM ICI8.1 POI7.1
UOM
UPC
ITEMUPC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemupctoitem ITEMMAST Required
IPC-ITEM-GROUP -> ITE-ITEM-GROUP
IPC-ITEM -> ITE-ITEM
|
