KWDMASTER – No description in the Lawson data dictionary

System
Inventory Control (IC)
Prefix
IC1
Primary key
SEARCH-TYPE, KWD-ORIGIN, KEYWORD, SEARCH-GROUP, COMPANY
Fields
6
Updated by
230 programs
Referenced by
4 programs

KWDMASTER is a Lawson Inventory Control table (prefix IC1); no description in the lawson data dictionary. It is indexed by SEARCH-TYPE, KWD-ORIGIN, KEYWORD, SEARCH-GROUP, COMPANY (IC1SET1); alternate indexes: IC1SET2, IC1SET3 and IC1SET4. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 222 more and referenced by IC32.1, ICIA.1, RQIC.1 and RQIG.1. The table has 6 fields, 4 indexes and 0 documented relations.

About KWDMASTER

No description in the Lawson data dictionary.

Fields (6)

Column = COBOL field name without the IC1- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#IC1-SEARCH-TYPE PK
SEARCH_TYPE		Numeric 2—
  • 01 Item
  • 02 Requisition
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#IC1-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 Agrmt special vendor item
  • 097 Agrmt special GTIN
  • 098 3rd Description
  • 099 Agrmt special item desc3
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#IC1-KEYWORD PK
KEYWORD		Alpha 32—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#IC1-SEARCH-GROUP PK
SEARCH_GROUP		Alpha 5—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#IC1-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.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#IC1-USAGE-COUNT SET2 SET3
USAGE_COUNT		Numeric 12—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (4)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
IC1SET1
  1. SEARCH-TYPE
  2. KWD-ORIGIN
  3. KEYWORD
  4. SEARCH-GROUP
  5. COMPANY
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
IC1SET2
  1. SEARCH-TYPE
  2. SEARCH-GROUP
  3. KWD-ORIGIN
  4. KEYWORD
  5. COMPANY
  6. USAGE-COUNT
IC00.1, IC800
IC1SET3
  1. SEARCH-TYPE
  2. KEYWORD
  3. KWD-ORIGIN
  4. SEARCH-GROUP
  5. COMPANY
  6. USAGE-COUNT
IC32.1, ICIA.1, RQIC.1, RQIG.1
IC1SET4
  1. SEARCH-TYPE
  2. SEARCH-GROUP
  3. KEYWORD
  4. KWD-ORIGIN
  5. COMPANY
—

Programs

Updated by (230)

Referenced by (4)