Lawson Insight Technical Documentation |
|
ITEMUPC
ITEMUPC FILE
Item Universal Product Code
The Item UPC file contains all the Universal Product Codes related to an item
on the Item Master file.
REFERENCED BY
BL92.1 IC11.1 IC11.2 IC598 IC800 ICI8.1
OE114 RQID.1 RQIF.1 RQIH.1 RQIJ.1 WH130
WH132 WH190 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 OE10.1
OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7
OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110
OE111 OE113 OE116 OE129 OE13.2 OE13.3
OE13.5 OE13.6 OE14.4 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510
OE530 OE810 OE830 RQIC.1 RQIG.1 WH20.2
WH20.7 POI7.1
UPDATED BY
ICI4.1 PO150 PO25.6 PO25.7 PO36.2 PO536
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IPC-ITEM-GROUP Alpha 5 ICI4.1 ICI8.1
Element: Item Group This field contains the identifier for PO150 PO25.6
a group of items that can be shared by PO25.7 PO36.2
one or more companies. PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IPC-ITEM Alpha 32 ICI4.1 ICI8.1
Element: Item Number This field contains the item PO150 PO25.6
identifier. PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IPC-UPC Alpha 15 ICI4.1 ICI8.1
Universal Product Universal Product Code. PO150 PO25.6
Code PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IPC-UOM Alpha 4 ICI4.1 ICI8.1
Element: Unit of MeasurThis field contains the valid stock PO150 PO25.6
unit of measure for this item. PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IPC-UOM-COST Signed 18.5 ICI4.1 ICI8.1
Element: Intl Cost Unit of measure cost. RQID.1 RQIF.1
RQIH.1 RQIJ.1
IPC-UPC-TYPE Alpha 1 ICI4.1 ICI8.1
Universal Product Unverversal Product Code type. RQID.1 RQIF.1
Code Type P = Primary RQIH.1 RQIJ.1
IPC-ZERO-SUPP-FL Alpha 6 ICI4.1 ICI8.1
Element: Zero Suppress Indicates whether leading zeros on the RQID.1 RQIF.1
UPC need to be suppressed. RQIH.1 RQIJ.1
IPC-USE-SALE-UOM Alpha 1 ICI4.1 ICI8.1
Use Sale Unit of Use sale unit of measure flag. RQID.1 RQIF.1
Measure N = No RQIH.1 RQIJ.1
Y = Yes
IPC-SALE-BY-MFG Alpha 1 ICI4.1 ICI8.1
Element: Sale by ManufaSale by manufacturer flag. PO150 PO25.6
N = No PO25.7 PO36.2
Y = Yes PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IPC-SALE-BY-DISTR Alpha 1 ICI4.1 ICI8.1
Element: Sale by DistriSale by distributor flag. PO150 PO25.6
N = No PO25.7 PO36.2
Y = Yes PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IPC-ITEM-TYPE-UPC Derived
Element: Item Type Upc
ITEMUPC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IPCSET1 ITEM-GROUP BL92.1 IC11.1
ITEM IC11.2 IC598
UPC IC800 ICI4.1
ICI8.1 OE114
PO150 PO25.6
PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
...
IPCSET2 UPC ICI4.1 ICI8.1
ITEM-GROUP PO150 PO25.6
PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IPCSET5 ITEM-GROUP Subset BL120 BL122
UPC Where UPC != Spaces BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
ICI4.1 ICI8.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
...
IPCSET6 ITEM-GROUP IC11.1 ICI4.1
ITEM ICI8.1 POI7.1
UOM RQIC.1 RQID.1
UPC RQIF.1 RQIG.1
RQIH.1 RQIJ.1
ITEMUPC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemupctoitem ITEMMAST Required
IPC-ITEM-GROUP -> ITE-ITEM-GROUP
IPC-ITEM -> ITE-ITEM
|