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    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          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
Element: Upn Nbr       Universal Product Number.                 PO150   PO25.6
                                                                 PO25.7  PO36.2
                                                                 PO536   RQID.1
                                                                 RQIF.1  RQIH.1
                                                                 RQIJ.1

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

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

IPN-SALE-BY-DISTR      Alpha 1                                   ICI5.1  ICI8.1
Element: Sale By Distr Sale 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 Mfg   Sale 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: Uom           This 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 18.5                               ICI5.1  ICI8.1
Element: Intl 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                                                   IC800   ICI5.1
          UPN-NBR                                                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   RQID.1
                                                                 RQIF.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

IPNSET6   ITEM-GROUP    KeyChange
          UPN-NBR

                         ITEMUPN1 FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemupn1toitem ITEMMAST     Required

                            IPN-ITEM-GROUP    -> ITE-ITEM-GROUP  (ITESET1)
                            IPN-ITEM          -> ITE-ITEM

Upn1toitem     ITEMMAST     Required

                            IPN-ITEM-GROUP    -> ITE-ITEM-GROUP
                            IPN-ITEM          -> ITE-ITEM