Custom Lookup Configuration for Guided Buying
Set up custom lookup configurations that support Guided Buying integrations for Statements of Work in the Request for Estimate process.
Context
This task can be performed by the Buyer's Admin.
For more information, see Custom Lookup in the Administration Fundamentals guide.
Procedure
- Log in as the buyer's admin and open the Administration Menu.
- Under Configuration, select Custom Lookup.
The Custom Lookup List page opens.
- Choose New. The Add New Custom Lookup page opens.
- Define the following custom lookup field values:
- Name: enter: SOW_COMMODITY_CODE.
- Lookup Type: select SOW Commodity Code.
- Number of Segments: enter 3.
- Delimter: enter ;
- Add the following Key/Value field details.
SOW Commodity Code Custom Lookup Key/Vaue Fields Segment #
Header Type
Type
Lookup Headers
1
KEY
Classification Code
Classification Code
2
VALUE
Commodity Code
Commodity Code
3
VALUE
Commodity Code Description
Commodity Code Description
- Repeat Steps 1-3.
- Define the following custom lookup field values:
- Name: enter: MDS_COMMODITY_CODE.
- Lookup Type: select MDS Commodity Code.
- Number of Segments: enter 2.
- Delimter: enter ;
- Add the following Key/Value field details.
MDS Commodity Code Custom Lookup Key/Vaue Fields Segment #
Header Type
Type
Lookup Headers
1
KEY
Commodity Code
Commodity Code
2
VALUE
Commodity Code Description
Commodity Code Description
- Once a lookup is created, download the template using the Download Data element, update the data and save it.
- To upload the template go to:
Admin Objects
Upload Data
, then navigate to the file and select Upload.