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.

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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
IC1SET1SEARCH-TYPE, KWD-ORIGIN, KEYWORD, SEARCH-GROUP, COMPANYPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
IC1SET2SEARCH-TYPE, SEARCH-GROUP, KWD-ORIGIN, KEYWORD, COMPANY, USAGE-COUNTIC00.1, IC800
IC1SET3SEARCH-TYPE, KEYWORD, KWD-ORIGIN, SEARCH-GROUP, COMPANY, USAGE-COUNTIC32.1, ICIA.1, RQIC.1, RQIG.1
IC1SET4SEARCH-TYPE, SEARCH-GROUP, KEYWORD, KWD-ORIGIN, COMPANY—

Programs

Updated by (230)

Referenced by (4)