Lawson Insight Technical Documentation |
|
KWDMASTER
KWDMASTER FILE
REFERENCED BY
IC32.1 ICIA.1 RQIC.1 RQIG.1
UPDATED BY
IC10.2 IC800 IC811 ICIB.1 PO150 PO25.6
PO25.7 PO36.2 PO536 PO813 IC00.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IC1-SEARCH-TYPE Numeric 2 IC10.2 IC800
Element: Search Type 01 = Item IC811 ICIB.1
02 = Requisition PO150 PO25.6
PO25.7 PO36.2
PO536 PO813
IC1-KWD-ORIGIN Numeric 3 IC10.2 IC800
Element: Kwd Origin 001 = Item IC811 ICIB.1
002 = Description PO150 PO25.6
003 = 2nd Description PO25.7 PO36.2
004 = Manufacturer Item PO536 PO813
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
IC1-KEYWORD Alpha 32 IC10.2 IC800
Element: Keyword IC811 ICIB.1
PO150 PO25.6
PO25.7 PO36.2
PO536 PO813
IC1-SEARCH-GROUP Alpha 5 IC10.2 IC800
Element: Search Group IC811 ICIB.1
PO150 PO25.6
PO25.7 PO36.2
PO536 PO813
IC1-COMPANY Numeric 4 IC10.2 IC800
Element: Company The company number represents an IC811 ICIB.1
established company and is entered on PO150 PO25.6
all function codes. PO25.7 PO36.2
PO536 PO813
IC1-USAGE-COUNT Numeric 12 IC10.2 IC800
Element: Usage Count IC811 ICIB.1
PO150 PO25.6
PO25.7 PO36.2
PO536 PO813
KWDMASTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IC1SET1 SEARCH-TYPE IC10.2 IC800
KWD-ORIGIN IC811 ICIB.1
KEYWORD PO150 PO25.6
SEARCH-GROUP PO25.7 PO36.2
COMPANY PO536 PO813
IC1SET2 SEARCH-TYPE IC00.1
SEARCH-GROUP
KWD-ORIGIN
KEYWORD
COMPANY
USAGE-COUNT
IC1SET3 SEARCH-TYPE IC32.1 ICIA.1
KEYWORD RQIC.1 RQIG.1
KWD-ORIGIN
SEARCH-GROUP
COMPANY
USAGE-COUNT
KWDMASTER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemgroup ITEMGROUP Not Required
Valid When IC1-SEARCH-TYPE = 1
IC1-SEARCH-GROUP -> ITG-ITEM-GROUP
KWDMASTER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Item Detail KWDDETAIL
IC1-SEARCH-TYPE -> IC2-SEARCH-TYPE
IC1-KWD-ORIGIN -> IC2-KWD-ORIGIN
IC1-KEYWORD -> IC2-KEYWORD
IC1-SEARCH-GROUP -> IC2-SEARCH-GROUP
IC2-ITEM
IC2-COMPANY
IC2-REQUISITION
IC2-IS-SYNONYM
Origin Detail KWDDETAIL
IC1-SEARCH-TYPE -> IC2-SEARCH-TYPE
IC1-SEARCH-GROUP -> IC2-SEARCH-GROUP
IC1-KWD-ORIGIN -> IC2-KWD-ORIGIN
IC1-KEYWORD -> IC2-KEYWORD
IC2-COMPANY
IC2-ITEM
IC2-REQUISITION
|