...
This refers to the name of the Price Parameter table that will be used for our data lookup. Only those tables that have at least one defined column will be included in this list.
This will include one or more attributes columns from the selected table that can be used to define our search criteria. These will reflect the known key field(s) for the selected table.
This will be the selected attribute column from the selected table whose value we are attempting to retrieve.
Table Name
The list of price parameter tables will vary by each installation, however there are a set of default tables (based on the Price Setting package) that are part of the standard configuration. We click on the drop-down in the Pricing Parameter Lookup to see all tables:
...
| Info |
|---|
NOTE: Once a table has been selected, then the list of search attribute columns will be displayed with the ability to connect specific values for each attribute. |
Search Attributes
The selected price parameter table will have a predefined set of attribute columns that are designated for search purposes. These search attributes will appear immediately below the selected table. In the following example, we have selected the Categories table:
...
| Info |
|---|
NOTE: The query associated with your data lookup is executed automatically after every update made to the search attribute values. |
Live Preview
The Live Preview will contain both the set of rows from the Price Parameter table and the results data lookup based on your search criteria. In the following example, we are using Discount table and have defined specific values for its search attributes (industry, business unit and product group category).
...