Item UPN2
The Item UPN2 file contains the Universal Product Number information related related to an item in the Item Master file.
REFERENCED BY
IC11.1 | IC11.4 | IC511 | IC598 | IC800 | ICI8.1 |
RQID.1 | RQIF.1 | RQIH.1 | RQIJ.1 | RQIC.1 | RQIG.1 |
ICI6.1 | PO150 | PO25.6 | PO25.7 | PO26.4 | PO26.5 |
PO26.8 | PO28.2 | PO36.2 | PO536 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
IP2-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. |
|
||||||||||||||||
IP2-ITEM Element: Item | Alpha 32 This field contains the item identifier. |
|
||||||||||||||||
IP2-UPN2-NBR Element: Upn2 Nbr | Alpha 25 (Right Justified) Universal Product Number. |
|
||||||||||||||||
IP2-REPL-UPN2 Element: Repl Upn2 | Alpha 25 (Right Justified) Replacement UPN2. |
|
||||||||||||||||
IP2-MFG-PD-DESC Element: Mfg Pd Desc | Alpha 80 Manufacturer's product description. |
|
||||||||||||||||
IP2-SALE-BY-DISTR Element: Sale By Distr | Alpha 1 Sale by distributor flag. N = No Y = Yes |
|
||||||||||||||||
IP2-SALE-BY-MFG Element: Sale By Mfg | Alpha 1 Sale by manufacturer flag. N = No Y = Yes |
|
||||||||||||||||
IP2-TRADE-NAME Element: Trade Name | Alpha 30 Trade name for the product. |
|
||||||||||||||||
IP2-UOM Element: Uom | Alpha 4 This field contains the valid stock unit of measure for this item. |
|
||||||||||||||||
IP2-UOM-COST Element: Intl Cost | Signed 18.5 |
|
||||||||||||||||
IP2-MFG-NAME Element: Mfg Name | Alpha 35 (Lower Case) |
|
||||||||||||||||
IP2-MFG-DIVISION Element: Mfg Division | Alpha 35 (Lower Case) |
|
||||||||||||||||
IP2-ITEM-TYPE-UPN2 Element: Item Type Upn2 | Derived |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
IP2SET1 |
ITEM-GROUP ITEM UPN2-NBR |
|
| ||||||||||||||||||||||||||
IP2SET2 |
UPN2-NBR ITEM-GROUP |
|
| ||||||||||||||||||||||||||
IP2SET5 |
ITEM-GROUP ITEM UOM UPN2-NBR |
|
| ||||||||||||||||||||||||||
IP2SET6 |
ITEM-GROUP UPN2-NBR |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Itemupn2toitem | ITEMMAST |
Required
| ||||||
Upn2toitem | ITEMMAST |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.