46 Update the Search Word Table

This chapter contains this topic:

Section 46.1, "Update the Search Word Table"

46.1 Update the Search Word Table

You must build a search word table before you can perform a query search for equipment. For example, you might perform a query search if you need to locate the equipment master for a piece of equipment, but you do not know the equipment number. The Search Word table consists of possible words you might use on a search form to access the equipment information that you need.

The Build Search Word Table program scans your equipment information and creates a Search Word table on all the words that you enter in the following tables:

Item Master table (F1201)
- Equipment description fields
- Any remark fields
- Model number
- Any of the first ten category codes
- AFE number

Supplemental Data tables (F12090, F12092, F12093)
- User defined code values
- Remark fields
- Narrative text

When you select Build Search Word Table, the system submits the job directly to batch. You should run this update to maintain and refresh the Search Word table as you add, change, and delete equipment. JD Edwards World recommends running this program as part of your unattended operations.

Navigation

From Equipment/Plan Management (G13), enter 27

From Advanced Operations (G1331), choose Build Search Word Table

46.1.1 What You Should Know About

Search Word Table	Description
Using uppercase and lowercase descriptions for equipment	The Build Search Word Table procedure is not case sensitive. The procedure locates and retrieves words in the equipment description fields regardless of whether they are upper or lower case.
Including supplemental data in the search word table	You must specify the supplemental data that you want to include in the search word table. See Chapter 39, "Setting Up Data Types"