IC800 – Keyword Search Load

System
Inventory Control (IC)
Type
Batch program
Updates
4 tables
References
14 tables

IC800 (Keyword Search Load) is a Lawson Inventory Control batch program. It updates CKPOINT, KWDDETAIL, KWDMASTER and POVAGRMTLN and references ICITEMGTIN, ICITEUF, ITEMMAST, ITEMNDC, ITEMSKU, ITEMUPC, ITEMUPN1, ITEMUPN2 and 6 more.

About IC800

Run Keyword Search Load (IC800) to create Keyword and Item Keyword records that can be searched upon in Lawson Requisitions Self-Service. Theprogram can also be run to update keywords when an origin field has been changed from No to Yes on Keyword Search Setup (IC00.5). **Processing Effect For UNIX/Windows platforms: This program will scan the KWDSETUP table for every origin field that is set to load keywords. It reads all records in ITEMMAST, POITEMVEN, ITEMUPN1, ITEMUPN2, ITEMUPC, ITEMSKU, ICUSRFLDEF. The program will then create Keyword and Keyword Item records. For System i platform: This program will scan the DBICICK table for every origin field that is set to load keywords. It reads all records in DBICITE, DBPOPIV, DBICIPN, DBICIP2, DBICIPC, DBICISK, DBICICU. The program will then create Keyword and Keyword Item records.

Updated files (4)

TableDescriptionSystem
CKPOINTNo description in the Lawson data dictionary—
KWDDETAILNo description in the Lawson data dictionaryIC
KWDMASTERNo description in the Lawson data dictionaryIC
POVAGRMTLNVendor Agreement LinePO

Referenced files (14)

TableDescriptionSystem
ICITEMGTINInventory Item for GTINIC
ICITEUFItem User FieldIC
ITEMMASTItem MasterIC
ITEMNDCItem National Drug CodeIC
ITEMSKUItem SKUIC
ITEMUPCItem Universal Product CodeIC
ITEMUPN1Item UPN1IC
ITEMUPN2Item UPN2IC
KWDDETAILNo description in the Lawson data dictionaryIC
KWDMASTERNo description in the Lawson data dictionaryIC
KWDSETUPNo description in the Lawson data dictionaryIC
POITEMVENPO Vendor Item InformationPO
POVAGRMTLNVendor Agreement LinePO
PROCUREGRPProcurement GroupPO

Program calls

Invoked programs (1)

ICIB