KWDSETUP – No description in the Lawson data dictionary

System
Inventory Control (IC)
Prefix
ICK
Primary key
SEARCH-TYPE, KWD-ORIGIN, SEARCH-GROUP, COMPANY, USAGE-FLAG
Fields
6
Updated by
2 programs
Referenced by
243 programs

KWDSETUP is a Lawson Inventory Control table (prefix ICK); no description in the lawson data dictionary. It is indexed by SEARCH-TYPE, KWD-ORIGIN, SEARCH-GROUP, COMPANY, USAGE-FLAG (ICKSET1); alternate indexes: ICKSET2. It is updated by IC00.1 and IC00.5 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 235 more. The table has 6 fields, 2 indexes and 0 documented relations.

About KWDSETUP

No description in the Lawson data dictionary.

Fields (6)

Column = COBOL field name without the ICK- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ICK-SEARCH-TYPE PK
SEARCH_TYPE		Numeric 2—
  • 01 Item
  • 02 Requisition
IC00.5
ICK-KWD-ORIGIN PK
KWD_ORIGIN		Numeric 3—
  • 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
  • 080 GTIN Number
  • 091 Agreement special item
  • 092 Agrmt special item description
  • 093 Agrmt special item desc2
  • 094 Agrmt special item manuf nbr
  • 095 Agrmt special item purch class
  • 096 Agmnt special vendor item
  • 097 Agrmt special GTIN
  • 098 3rd Description
  • 099 Agrmt special item desc3
IC00.5
ICK-SEARCH-GROUP PK
SEARCH_GROUP		Alpha 5—IC00.5
ICK-COMPANY PK
COMPANY		Numeric 4Identifies 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.IC00.5
ICK-USAGE-FLAG PK
USAGE_FLAG		Numeric 1—
  • 0 Not Used
  • 1 Used
IC00.5
ICK-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.IC00.5

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ICKSET1SEARCH-TYPE, KWD-ORIGIN, SEARCH-GROUP, COMPANY, USAGE-FLAGPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
ICKSET2SEARCH-TYPE, SEARCH-GROUP, KWD-ORIGIN, COMPANY, USAGE-FLAGAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Programs

Updated by (2)

Referenced by (243)