ITEMUPN1 FILE
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 IC598 ICI8.1 RQIC.1 RQID.1
RQIG.1 RQIH.1
UPDATED BY
ICI5.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IPN-ITEM-GROUP Alpha 5 ICI5.1 ICI8.1
Item Group This field contains the identifier for RQID.1 RQIH.1
a group of items that can be shared by
one or more companies.
IPN-ITEM Alpha 32 ICI5.1 ICI8.1
Item Number This field contains the item RQID.1 RQIH.1
identifier.
IPN-UPN-NBR Alpha 20 ICI5.1 ICI8.1
Universal Product Universal Product Number. RQID.1 RQIH.1
Number
IPN-REPL-UPN1 Alpha 20 ICI5.1 ICI8.1
Replacement UPN1 Replacement UPN. RQID.1 RQIH.1
IPN-MFG-PD-DESC Alpha 80 ICI5.1 ICI8.1
Manufacturer's Manufacturer's product description. RQID.1 RQIH.1
Product Desc
IPN-SALE-BY-DISTR Alpha 1 ICI5.1 ICI8.1
Sale by Distributor Sale by distributor flag. RQID.1 RQIH.1
IPN-SALE-BY-MFG Alpha 1 ICI5.1 ICI8.1
Sale by Manufacturer Sale by manufacturer flag. RQID.1 RQIH.1
IPN-TRADE-NAME Alpha 30 ICI5.1 ICI8.1
Trade Name Trade name for the product. RQID.1 RQIH.1
IPN-UOM Alpha 4 ICI5.1 ICI8.1
Unit of Measure This field contains the valid stock RQID.1 RQIH.1
unit of measure for this item.
IPN-UOM-COST Signed 13.5 ICI5.1 ICI8.1
Unit of Measure Cost Unit of measure cost. RQID.1 RQIH.1
ITEMUPN1 FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IPNSET1 ITEM-GROUP IC11.1 IC11.3
ITEM IC598 ICI5.1
UPN-NBR ICI8.1 RQIC.1
RQID.1 RQIG.1
RQIH.1
IPNSET2 UPN-NBR ICI5.1 ICI8.1
RQID.1 RQIH.1
IPNSET5 ITEM-GROUP ICI5.1 ICI8.1
ITEM RQID.1 RQIH.1
UOM
UPN-NBR
ITEMUPN1 FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemupn1toitem ITEMMAST Required
IPN-ITEM-GROUP -> ITE-ITEM-GROUP
IPN-ITEM -> ITE-ITEM
Upn1toitem ITEMMAST Required
IPN-ITEM-GROUP -> ITE-ITEM-GROUP
IPN-ITEM -> ITE-ITEM
|
