Pricing Administration Guide > Using Mappings in Pricing Factors > About Search Specifications for Mappings >

About Search Specifications in the Pricing Mapping Definition List

The Pricing Mapping Definition list, shown in Figure 10, allows you to create search specification by entering criteria on multiple rows:

• In each row, you use a drop-down list to choose a field name, and you enter the rest of the search specification in the Search Spec Value field.
• The rows are all joined with the logical AND operator.

Figure 10.  Pricing Mapping Definition List

The drop-down list of field names includes only the fields in the business component you specified in the Pricing Mapping view, reducing the chance of error. However, if you need to join two search conditions with an OR, you cannot do it here; you must use the Search Spec field in the Pricing Mapping list.

The syntax follows the standard Siebel query syntax. Because the Pricing Mapping Definition list automatically applies some formatting, the following rules also apply:

• Do not enclose a character string in quotes, even if there is a space between two words.
• Use single quotation marks to enclose a value that contains a hyphen, such as an ID value equal to '1-15VMV'.
• Enclose a numeric value or a date and time in single or double quotation marks only if there is an embedded space in the value. If you do not use quotation marks, only the numbers to the left of the space will be considered in the search. In the following example, both the date and the time will be considered:

  ='01/01/00 5:30:00PM'

  • If you use only the date portion and enclose it in single quotation marks, Siebel ePricer assumes the time is midnight. For example, ='01/01/00' is interpreted as ='01/01/00 00:00:00'.
  • If you use only the date portion and do not enclose it in single quotation marks, the results returned will be for the entire day. For example, 01/01/00 returns results for 01/01/00 00:00:00 to 01/01/00 11:59:59 PM.