KWDMASTER

REFERENCED BY
IC32.1


UPDATED BY
IC00.1 IC10.2 IC800 IC811 ICIA.1 ICIB.1
PO150 PO25.6 PO25.7 PO26.4 PO26.5 PO28.2
PO36.2 PO536 PO813 RQIC.1 RQIG.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IC1-SEARCH-TYPE
Element: Search Type		Numeric 2

01 = Item
02 = Requisition
IC10.2 IC811
ICIB.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536 PO813
IC1-KWD-ORIGIN
Element: 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
IC10.2 IC811
ICIB.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536 PO813
IC1-KEYWORD
Element: Keyword		Alpha 32
IC10.2 IC811
ICIB.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536 PO813
IC1-SEARCH-GROUP
Element: Search Group		Alpha 5
IC10.2 IC811
ICIB.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536 PO813
IC1-COMPANY
Element: Company		Numeric 4
Identifies 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.
IC10.2 IC811
ICIB.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536 PO813
IC1-USAGE-COUNT
Element: Usage Count		Numeric 12
IC10.2 IC811
ICIB.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536 PO813


KWDMASTER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IC1SET1 SEARCH-TYPE
KWD-ORIGIN
KEYWORD
SEARCH-GROUP
COMPANY
IC10.2 IC811
ICIB.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536 PO813
IC1SET2 SEARCH-TYPE
SEARCH-GROUP
KWD-ORIGIN
KEYWORD
COMPANY
USAGE-COUNT
IC00.1 IC800
IC1SET3 SEARCH-TYPE
KEYWORD
KWD-ORIGIN
SEARCH-GROUP
COMPANY
USAGE-COUNT
IC32.1 ICIA.1
RQIC.1 RQIG.1
IC1SET4 SEARCH-TYPE
SEARCH-GROUP
KEYWORD
KWD-ORIGIN
COMPANY

File created: Thu Jun 09 11:17:26 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.