KWDMASTER

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

01 = Item
02 = Requisition
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
IC1-KEYWORD
Element: Keyword
Alpha 32
IC1-SEARCH-GROUP
Element: Search Group
Alpha 5
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.
IC1-USAGE-COUNT
Element: Usage Count
Numeric 12


KWDMASTER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IC1SET1 SEARCH-TYPE
KWD-ORIGIN
KEYWORD
SEARCH-GROUP
COMPANY
IC1SET2 SEARCH-TYPE
SEARCH-GROUP
KWD-ORIGIN
KEYWORD
COMPANY
USAGE-COUNT
IC1SET3 SEARCH-TYPE
KEYWORD
KWD-ORIGIN
SEARCH-GROUP
COMPANY
USAGE-COUNT
IC1SET4 SEARCH-TYPE
SEARCH-GROUP
KEYWORD
KWD-ORIGIN
COMPANY


File created: Wed Jun 08 20:49:40 2016

Home
Contact Us



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