Lawson Insight Technical Documentation

                             KWDSETUP FILE

REFERENCED BY

IC10.2    IC800     IC811     ICIA.1    ICIB.1    PO150
PO25.6    PO25.7    PO36.2    PO536     PO813     RQIC.1
RQIG.1    DR100     IC11.1    IC11.2    IC11.3    IC11.4
IC11.5    IC141     IC142     IC83.1    PO13.1    RQ500
RQIA.1    RQIB.1    RQII.1    RQIJ.1

UPDATED BY

IC00.5    IC00.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ICK-SEARCH-TYPE        Numeric 2                                 IC00.5
Element: Search Type   01 = Item
                       02 = Requisition

ICK-KWD-ORIGIN         Numeric 3                                 IC00.5
Element: Kwd Origin    001 = Item
                       002 = Description
                       003 = 2nd Description
                       004 = Manufacturer Item
                       005 = Purchasing Class
                       006 = Inventory Class
                       007 = Sales Class
                       008 = Generic Name
                       009 = First Alpha User Field
                       010 = Second Alpha User Field
                       011 = Third Alpha User Field
                       012 = Fourth Alpha User Field
                       013 = Fifth Alpha User Field
                       014 = First Numeric User Field
                       015 = Second Numeric User Field
                       016 = Third Numeric User Field
                       020 = First Item Master User Field
                       021 = Second Item Master User Field
                       022 = Third Item Master User Field
                       023 = Fourth Item Master User Field
                       024 = Fifth Item Master User Field
                       030 = UPC Number
                       040 = UPN1 Number
                       050 = UPN2 Number
                       060 = SKU Number
                       070 = Vendor Item
                       071 = Vendor Item Description
                       072 = Vendor Manufacturer Item

ICK-SEARCH-GROUP       Alpha 5                                   IC00.5
Element: Search Group

ICK-COMPANY            Numeric 4                                 IC00.5
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

ICK-USAGE-FLAG         Numeric 1                                 IC00.5
Element: Usage Flag    0 = Not Used
                       1 = Used

ICK-DESCRIPTION        Alpha 30  (Lower Case)                    IC00.5
Element: Description   This field displays the description.

                         KWDSETUP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICKSET1   SEARCH-TYPE                                            IC10.2  IC800
          KWD-ORIGIN                                             IC811   ICIA.1
          SEARCH-GROUP                                           ICIB.1  PO150
          COMPANY                                                PO25.6  PO25.7
          USAGE-FLAG                                             PO36.2  PO536
                                                                 PO813   RQIC.1
                                                                 RQIG.1

ICKSET2   SEARCH-TYPE                                            DR100   IC00.1
          SEARCH-GROUP                                           IC00.5  IC10.2
          KWD-ORIGIN                                             IC11.1  IC11.2
          COMPANY                                                IC11.3  IC11.4
          USAGE-FLAG                                             IC11.5  IC141
                                                                 IC142   IC800
                                                                 IC811   IC83.1
                                                                 ICIA.1  PO13.1
                                                                 PO150   PO25.6
                                                                 PO25.7  PO36.2
                                                                 PO536   PO813
                                                                 RQ500   RQIA.1
                                                                 RQIB.1  RQIC.1
                                                                 RQIG.1  RQII.1
                                                                 RQIJ.1

                         KWDSETUP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemgroup      ITEMGROUP    Not Required
                            Valid When ICK-SEARCH-GROUP != Spaces

                            ICK-SEARCH-GROUP    -> ITG-ITEM-GROUP