Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ITEMUPN1


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

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IPN-ITEM-GROUP         Alpha 5                                   ICI5.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

IPN-ITEM               Alpha 32                                  ICI5.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

IPN-UPN-NBR            Alpha 20                                  ICI5.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

IPN-REPL-UPN1          Alpha 20                                  ICI5.1  ICI8.1
Element: Replacement UPReplacement UPN.                          RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

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

IPN-SALE-BY-DISTR      Alpha 1                                   ICI5.1  ICI8.1
Element: Sale by DistriSale by distributor flag.                 PO150   PO25.6
                                                                 PO25.7  PO36.2
                                                                 PO536   RQID.1
                                                                 RQIF.1  RQIH.1
                                                                 RQIJ.1

IPN-SALE-BY-MFG        Alpha 1                                   ICI5.1  ICI8.1
Element: Sale by ManufaSale by manufacturer flag.                PO150   PO25.6
                                                                 PO25.7  PO36.2
                                                                 PO536   RQID.1
                                                                 RQIF.1  RQIH.1
                                                                 RQIJ.1

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

IPN-UOM                Alpha 4                                   ICI5.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

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

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

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

IPN-ITEM-TYPE-UPN1     Derived
Element: Item Type Upn1

                         ITEMUPN1 FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IPNSET1   ITEM-GROUP                                             IC11.1  IC11.3
          ITEM                                                   IC598   IC800
          UPN-NBR                                                ICI5.1  ICI8.1
                                                                 PO150   PO25.6
                                                                 PO25.7  PO36.2
                                                                 PO536   RQID.1
                                                                 RQIF.1  RQIH.1
                                                                 RQIJ.1

IPNSET2   UPN-NBR                                                ICI5.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

IPNSET5   ITEM-GROUP                                             ICI5.1  ICI8.1
          ITEM                                                   RQIC.1  RQID.1
          UOM                                                    RQIF.1  RQIG.1
          UPN-NBR                                                RQIH.1  RQIJ.1

                         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