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    IC11.6    IC141     IC142     IC83.1    PO13.1
RQ10.1    RQ10.3    RQ11.1    RQ13.2    RQ35.1    RQ500
RQIA.1    RQIB.1    RQIF.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       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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  IC11.6
                                                                 IC141   IC142
                                                                 IC800   IC811
                                                                 IC83.1  ICIA.1
                                                                 PO13.1  PO150
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536
                                                                 PO813   RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ13.2  RQ35.1
                                                                 RQ500   RQIA.1
                                                                 ...