KWDMASTER

REFERENCED BY
IC32.1 ICIA.1 RQIC.1 RQIG.1


UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 AP510 API1.1
API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC10.2 IC12.1 IC140 IC141 IC142 IC145
IC243 IC330 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC811 IC83.1 ICIB.1 MA180 MA278 MA41.1
MA41.2 MA41.4 MA41.7 MA42.2 MA43.2 MA43.7
MA44.1 MA44.2 MA53.1 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA70.1 MA75.1 MA80.1
MAI1.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PD570 PO04.1 PO04.2 PO10.1 PO10.2
PO100 PO101 PO115 PO120 PO122 PO131
PO132 PO136 PO15.1 PO15.2 PO15.4 PO150
PO17.1 PO190 PO20.1 PO20.6 PO20.9 PO204
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.3 PO22.4 PO220 PO222 PO224 PO225
PO229 PO23.1 PO230 PO234 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO251 PO26.2 PO26.3
PO26.4 PO26.5 PO26.6 PO26.7 PO26.9 PO27.2
PO27.3 PO27.4 PO275 PO276 PO277 PO28.2
PO280 PO29.1 PO30.1 PO30.2 PO30.3 PO30.4
PO300 PO31.1 PO31.2 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
PO54.5 PO813 POCP.1 POI3.1 POID.1 POII.1
POIJ.1 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4
RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1 RQII.1
RQIJ.1 WH130 WH132 WH190 WH20.2 WH20.7
WH222 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
IC00.1 IC800

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

01 = Item
02 = Requisition
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC12.1
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC811 IC83.1
ICIB.1 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
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
098 = 3rd Description
099 = Agrmt special item desc3
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC12.1
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC811 IC83.1
ICIB.1 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
IC1-KEYWORD
Element: Keyword
Alpha 32
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC12.1
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC811 IC83.1
ICIB.1 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
IC1-SEARCH-GROUP
Element: Search Group
Alpha 5
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC12.1
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC811 IC83.1
ICIB.1 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
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.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC12.1
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC811 IC83.1
ICIB.1 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
IC1-USAGE-COUNT
Element: Usage Count
Numeric 12
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC12.1
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC811 IC83.1
ICIB.1 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7


KWDMASTER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IC1SET1 SEARCH-TYPE
KWD-ORIGIN
KEYWORD
SEARCH-GROUP
COMPANY
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
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 02:19:10 2016

Home
Contact Us



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