ITEMUPN2 FILE
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 ICI8.1
UPDATED BY
ICI6.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IP2-ITEM-GROUP Alpha 5 ICI6.1 ICI8.1
Item Group This field contains the identifier for
a group of items that can be shared by
one or more companies.
IP2-ITEM Alpha 32 ICI6.1 ICI8.1
Item Number This field contains the item
identifier.
IP2-UPN2-NBR Alpha 25 (Right Justified) ICI6.1 ICI8.1
Universal Product Universal Product Number.
Number
IP2-REPL-UPN2 Alpha 25 (Right Justified) ICI6.1 ICI8.1
Replacement UPN2 Replacement UPN2.
IP2-MFG-PD-DESC Alpha 80 ICI6.1 ICI8.1
Manufacturer's Manufacturer's product description.
Product Desc
IP2-SALE-BY-DISTR Alpha 1 ICI6.1 ICI8.1
Sale by Distributor Sale by distributor flag.
N = No
Y = Yes
IP2-SALE-BY-MFG Alpha 1 ICI6.1 ICI8.1
Sale by Manufacturer Sale by manufacturer flag.
N = No
Y = Yes
IP2-TRADE-NAME Alpha 30 ICI6.1 ICI8.1
Trade Name Trade name for the product.
IP2-UOM Alpha 4 ICI6.1 ICI8.1
Unit of Measure This field contains the valid stock
unit of measure for this item.
IP2-UOM-COST Signed 13.5 ICI6.1 ICI8.1
Unit of Measure Cost Unit of measure cost.
ITEMUPN2 FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IP2SET1 ITEM-GROUP IC11.1 IC11.4
ITEM ICI6.1 ICI8.1
UPN2-NBR
IP2SET2 UPN2-NBR ICI6.1 ICI8.1
IP2SET5 ITEM-GROUP ICI6.1 ICI8.1
ITEM
UOM
UPN2-NBR
ITEMUPN2 FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemupn2toitem ITEMMAST Required
IP2-ITEM-GROUP -> ITE-ITEM-GROUP
IP2-ITEM -> ITE-ITEM
Upn2toitem ITEMMAST Required
IP2-ITEM-GROUP -> ITE-ITEM-GROUP
IP2-ITEM -> ITE-ITEM
|
