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
ICI4.1 | PO150 | PO25.6 | PO25.7 | PO26.4 | PO26.5 |
PO26.8 | PO28.2 | PO36.2 | PO536 |
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 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
IPCSET1 |
ITEM-GROUP ITEM UPC |
|
|||||||||||||||||||||||
IPCSET2 |
UPC ITEM-GROUP |
|
| ||||||||||||||||||||||
IPCSET5 |
ITEM-GROUP UPC |
|
| ||||||||||||||||||||||
IPCSET6 |
ITEM-GROUP ITEM UOM UPC |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Itemupctoitem | ITEMMAST |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.