SA Word Index Rebuild Report ranges and options

Ranges

See Ranges.

Options

Table: (All) or Single Table Name

Specify the name of the table you want to rebuild or update, or specify All to generate reports for all word index tables.

These are valid table names:

apss	apsv	arsc	arsg	arss	contact
edsv	gletr	glsa	iceti	icsc	icsd
icsei	icses	icsp	icsw	item	oeeh
oeel	pdsc	poeh	poel	sled	smsn
vaeh	wteh	wtel

Note:  The word index table for Product Warehouse Product Setup (ICSW) is based on the Product Setup (ICSP) table. If you run the report for the ICSW table, the report shows that zero records were updated. You must run the report for the ICSP table to rebuild or update the word index for products.

Force Rebuild?

Select No to create any missing word index records for the specified table(s).

Select Yes to force recreation of the word index data for all records of the specified table(s). The number of records rebuilt are noted on the report.

Note: We recommend running the SA Word Index Rebuild Report first with this option set to No and Remove Orphaned Records set to Yes. Then re-run the report with Force Rebuild set to Yes.

OE Active Orders Only?

Select Yes to exclude all invoiced orders when rebuilding the word index.

Remove Orphaned Records?

Select Yes to remove orphaned records from the specified table(s). The number of orphaned records removed are noted on the report.