Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ITEMUPN2


                             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    IC598     IC800     ICI8.1    RQID.1
RQIF.1    RQIH.1    RQIJ.1    RQIC.1    RQIG.1

UPDATED BY

ICI6.1    PO150     PO25.6    PO25.7    PO36.2    PO536

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IP2-ITEM-GROUP         Alpha 5                                   ICI6.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

IP2-ITEM               Alpha 32                                  ICI6.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

IP2-UPN2-NBR           Alpha 25  (Right Justified)               ICI6.1  ICI8.1
Universal Product      Universal Product Number.                 PO150   PO25.6
Number                                                           PO25.7  PO36.2
                                                                 PO536   RQID.1
                                                                 RQIF.1  RQIH.1
                                                                 RQIJ.1

IP2-REPL-UPN2          Alpha 25  (Right Justified)               ICI6.1  ICI8.1
Element: Replacement UPReplacement UPN2.                         RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

IP2-MFG-PD-DESC        Alpha 80                                  ICI6.1  ICI8.1
Manufacturer's         Manufacturer's product description.       RQID.1  RQIF.1
Product Desc                                                     RQIH.1  RQIJ.1

IP2-SALE-BY-DISTR      Alpha 1                                   ICI6.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

IP2-SALE-BY-MFG        Alpha 1                                   ICI6.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

IP2-TRADE-NAME         Alpha 30                                  ICI6.1  ICI8.1
Element: Trade Name    Trade name for the product.               RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

IP2-UOM                Alpha 4                                   ICI6.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

IP2-UOM-COST           Signed 13.5                               ICI6.1  ICI8.1
Element: Unit of MeasurUnit of measure cost.                     RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

IP2-MFG-NAME           Alpha 35  (Lower Case)                    ICI6.1  ICI8.1
Element: Mfg Name                                                RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

IP2-MFG-DIVISION       Alpha 35  (Lower Case)                    ICI6.1  ICI8.1
Element: Mfg Division                                            RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

IP2-ITEM-TYPE-UPN2     Derived
Element: Item Type Upn2

                         ITEMUPN2 FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IP2SET1   ITEM-GROUP                                             IC11.1  IC11.4
          ITEM                                                   IC598   IC800
          UPN2-NBR                                               ICI6.1  ICI8.1
                                                                 PO150   PO25.6
                                                                 PO25.7  PO36.2
                                                                 PO536   RQID.1
                                                                 RQIF.1  RQIH.1
                                                                 RQIJ.1

IP2SET2   UPN2-NBR                                               ICI6.1  ICI8.1
          ITEM-GROUP                                             PO150   PO25.6
                                                                 PO25.7  PO36.2
                                                                 PO536   RQIC.1
                                                                 RQID.1  RQIF.1
                                                                 RQIG.1  RQIH.1
                                                                 RQIJ.1

IP2SET5   ITEM-GROUP                                             ICI6.1  ICI8.1
          ITEM                                                   RQIC.1  RQID.1
          UOM                                                    RQIF.1  RQIG.1
          UPN2-NBR                                               RQIH.1  RQIJ.1

                         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