Lawson Insight Technical Documentation |
|
KWDDETAIL
KWDDETAIL FILE
REFERENCED BY
ICIA.1 RQIC.1 RQIG.1 IC11.1 IC11.2 IC11.3
IC11.4 IC11.5
UPDATED BY
IC10.2 IC32.1 IC800 IC811 ICIB.1 PO150
PO25.6 PO25.7 PO36.2 PO536 PO813 IC00.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IC2-SEARCH-TYPE Numeric 2 IC10.2 IC32.1
Element: Search Type 01 = Item IC800 IC811
02 = Requisition ICIB.1 PO150
PO25.6 PO25.7
PO36.2 PO536
PO813
IC2-KWD-ORIGIN Numeric 3 IC10.2 IC32.1
Element: Kwd Origin IC800 IC811
ICIB.1 PO150
PO25.6 PO25.7
PO36.2 PO536
PO813
IC2-KEYWORD Alpha 32 IC10.2 IC32.1
Element: Keyword IC800 IC811
ICIB.1 PO150
PO25.6 PO25.7
PO36.2 PO536
PO813
IC2-SEARCH-GROUP Alpha 5 IC10.2 IC32.1
Element: Search Group IC800 IC811
ICIB.1 PO150
PO25.6 PO25.7
PO36.2 PO536
PO813
IC2-ITEM Alpha 32 IC10.2 IC32.1
Element: Item Number This field contains the item IC800 IC811
identifier. ICIB.1 PO150
PO25.6 PO25.7
PO36.2 PO536
PO813
IC2-COMPANY Numeric 4 IC10.2 IC32.1
Element: Company The company number represents an IC800 IC811
established company and is entered on ICIB.1 PO150
all function codes. PO25.6 PO25.7
PO36.2 PO536
PO813
IC2-REQUISITION Numeric 9 IC32.1
Element: Requisition
IC2-IS-SYNONYM Numeric 1 IC10.2 IC32.1
Element: Is Synonym 0 = No IC800 IC811
1 = Yes ICIB.1 PO150
PO25.6 PO25.7
PO36.2 PO536
PO813
KWDDETAIL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IC2SET1 SEARCH-TYPE IC10.2 IC800
KWD-ORIGIN IC811 ICIA.1
KEYWORD ICIB.1 PO150
SEARCH-GROUP PO25.6 PO25.7
ITEM PO36.2 PO536
COMPANY PO813 RQIC.1
REQUISITION RQIG.1
IS-SYNONYM
IC2SET2 SEARCH-TYPE This index is used to delete Keyword IC00.1 IC10.2
SEARCH-GROUP details when an origin flag in setup is IC32.1 IC800
KWD-ORIGIN changed from 1 to 0 IC811 ICIA.1
KEYWORD ICIB.1 PO150
COMPANY PO25.6 PO25.7
ITEM PO36.2 PO536
REQUISITION PO813 RQIC.1
RQIG.1
IC2SET3 SEARCH-TYPE This index is used to delete Synonym IC32.1
KEYWORD keyword details when a synoynym is
IS-SYNONYM deleted in the system
KWD-ORIGIN
SEARCH-GROUP
ITEM
COMPANY
REQUISITION
IC2SET4 SEARCH-TYPE IC10.2 IC11.1
SEARCH-GROUP IC11.2 IC11.3
ITEM IC11.4 IC11.5
KWD-ORIGIN IC800 IC811
KEYWORD ICIA.1 ICIB.1
COMPANY PO150 PO25.6
REQUISITION PO25.7 PO36.2
PO536 PO813
RQIC.1 RQIG.1
KWDDETAIL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemgroup ITEMGROUP Not Required
Valid When IC2-SEARCH-GROUP != Spaces
IC2-SEARCH-GROUP -> ITG-ITEM-GROUP
Kwdmaster KWDMASTER Required
IC2-SEARCH-TYPE -> IC1-SEARCH-TYPE
IC2-KWD-ORIGIN -> IC1-KWD-ORIGIN
IC2-KEYWORD -> IC1-KEYWORD
IC2-SEARCH-GROUP -> IC1-SEARCH-GROUP
IC2-COMPANY -> IC1-COMPANY
KWDDETAIL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Synonym1 KWDSYNONYM
IC2-KEYWORD -> IC3-SYNONYM
IC3-KEYWORD
Synonym2 KWDSYNONYM
IC2-KEYWORD -> IC3-KEYWORD
IC3-SYNONYM
|