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 ICI8.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
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
identifier.
IPN-UPN-NBR Alpha 20 ICI5.1 ICI8.1
Universal Product Universal Product Number.
Number
IPN-REPL-UPN1 Alpha 20 ICI5.1 ICI8.1
Replacement UPN1 Replacement UPN.
IPN-MFG-PD-DESC Alpha 80 ICI5.1 ICI8.1
Manufacturer's Manufacturer's product description.
Product Desc
IPN-SALE-BY-DISTR Alpha 1 ICI5.1 ICI8.1
Sale by Distributor Sale by distributor flag.
IPN-SALE-BY-MFG Alpha 1 ICI5.1 ICI8.1
Sale by Manufacturer Sale by manufacturer flag.
IPN-TRADE-NAME Alpha 30 ICI5.1 ICI8.1
Trade Name Trade name for the product.
IPN-UOM Alpha 4 ICI5.1 ICI8.1
Unit of Measure This field contains the valid stock
unit of measure for this item.
IPN-UOM-COST Signed 13.5 ICI5.1 ICI8.1
Unit of Measure Cost Unit of measure cost.
ITEMUPN1 FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IPNSET1 ITEM-GROUP IC11.1 IC11.3
ITEM ICI5.1 ICI8.1
UPN-NBR
IPNSET2 UPN-NBR ICI5.1 ICI8.1
IPNSET5 ITEM-GROUP ICI5.1 ICI8.1
ITEM
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
|
