Lawson Insight Technical Documentation

                             KWDMASTER FILE

REFERENCED BY

IC32.1    RQIC.1    RQIG.1

UPDATED BY

IC811     ICIB.1    PO150     PO25.6    PO25.7    PO36.2
PO536     PO813     IC00.1    IC800

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IC1-SEARCH-TYPE        Numeric 2                                 IC811   ICIB.1
Element: Search Type   01 = Item                                 PO150   PO25.6
                       02 = Requisition                          PO25.7  PO36.2
                                                                 PO536   PO813

IC1-KWD-ORIGIN         Numeric 3                                 IC811   ICIB.1
Element: Kwd Origin    001 = Item                                PO150   PO25.6
                       002 = Description                         PO25.7  PO36.2
                       003 = 2nd Description                     PO536   PO813
                       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

IC1-KEYWORD            Alpha 32                                  IC811   ICIB.1
Element: Keyword                                                 PO150   PO25.6
                                                                 PO25.7  PO36.2
                                                                 PO536   PO813

IC1-SEARCH-GROUP       Alpha 5                                   IC811   ICIB.1
Element: Search Group                                            PO150   PO25.6
                                                                 PO25.7  PO36.2
                                                                 PO536   PO813

IC1-COMPANY            Numeric 4                                 IC811   ICIB.1
Element: Company       Identifies the AP company if the          PO150   PO25.6
                       resource type = V.  Identifies the HR     PO25.7  PO36.2
                       company if the resource type = E.  It is  PO536   PO813
                       blank for type A, P or Q resources.

IC1-USAGE-COUNT        Numeric 12                                IC811   ICIB.1
Element: Usage Count                                             PO150   PO25.6
                                                                 PO25.7  PO36.2
                                                                 PO536   PO813

                         KWDMASTER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IC1SET1   SEARCH-TYPE                                            IC811   ICIB.1
          KWD-ORIGIN                                             PO150   PO25.6
          KEYWORD                                                PO25.7  PO36.2
          SEARCH-GROUP                                           PO536   PO813
          COMPANY

IC1SET2   SEARCH-TYPE                                            IC00.1  IC800
          SEARCH-GROUP
          KWD-ORIGIN
          KEYWORD
          COMPANY
          USAGE-COUNT

IC1SET3   SEARCH-TYPE                                            IC32.1  RQIC.1
          KEYWORD                                                RQIG.1
          KWD-ORIGIN
          SEARCH-GROUP
          COMPANY
          USAGE-COUNT

IC1SET4   SEARCH-TYPE
          SEARCH-GROUP
          KEYWORD
          KWD-ORIGIN
          COMPANY