Lawson Insight Technical Documentation

                              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

IC11.1    IC11.2    IC598     ICI8.1    RQIC.1    RQID.1
RQIG.1    RQIH.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     WH20.2    WH20.7    POI7.1

UPDATED BY

ICI4.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

IPC-ITEM-GROUP       Alpha 5                                     ICI4.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.

IPC-ITEM             Alpha 32                                    ICI4.1  ICI8.1
Item Number          This field contains the item                RQID.1  RQIH.1
                     identifier.

IPC-UPC              Alpha 15                                    ICI4.1  ICI8.1
Universal Product    Universal Product Code.                     RQID.1  RQIH.1
Code

IPC-UOM              Alpha 4                                     ICI4.1  ICI8.1
Unit of Measure      This field contains the valid stock         RQID.1  RQIH.1
                     unit of measure for this item.


IPC-UOM-COST         Signed 13.5                                 ICI4.1  ICI8.1
Unit of Measure Cost Unit of measure cost.                       RQID.1  RQIH.1

IPC-UPC-TYPE         Alpha 1                                     ICI4.1  ICI8.1
Universal Product    Unverversal Product Code type.              RQID.1  RQIH.1
Code Type            P = Primary

IPC-ZERO-SUPP-FL     Alpha 6                                     ICI4.1  ICI8.1
Zero Suppress Flag   Indicates whether leading zeros on the      RQID.1  RQIH.1
                     UPC need to be suppressed.

IPC-USE-SALE-UOM     Alpha 1                                     ICI4.1  ICI8.1
Use Sale Unit of     Use sale unit of measure flag.              RQID.1  RQIH.1
Measure              N = No
                     Y = Yes

IPC-SALE-BY-MFG      Alpha 1                                     ICI4.1  ICI8.1
Sale by Manufacturer Sale by manufacturer flag.                  RQID.1  RQIH.1
                     N = No
                     Y = Yes

IPC-SALE-BY-DISTR    Alpha 1                                     ICI4.1  ICI8.1
Sale by Distributor  Sale by distributor flag.                   RQID.1  RQIH.1
                     N = No
                     Y = Yes

                         ITEMUPC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IPCSET1   ITEM-GROUP                                             IC11.1  IC11.2
          ITEM                                                   IC598   ICI4.1
          UPC                                                    ICI8.1  RQIC.1
                                                                 RQID.1  RQIG.1
                                                                 RQIH.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
                                                                 ...

IPCSET2   UPC                                                    ICI4.1  ICI8.1
                                                                 RQID.1  RQIH.1

IPCSET5   ITEM-GROUP    Subset                                   ICI4.1  ICI8.1
          UPC           Where UPC != Spaces                      RQID.1  RQIH.1
                                                                 WH20.2  WH20.7

IPCSET6   ITEM-GROUP                                             IC11.1  ICI4.1
          ITEM                                                   ICI8.1  POI7.1
          UOM                                                    RQID.1  RQIH.1
          UPC

                         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