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