Bookshelf Home | Contents | Index | Search | PDF

Pricing Administration Guide > Matrix-Based Pricing Factors > About Matrix-Based Pricing Factors >

Search Specifications for a Matrix-Based Pricing Factor

---

Search specifications are entered in the Matrix SearchSpec field of the Pricing Factor form. They are logical conditions that use fields in the quote or order as variables. For any quote or order, only one row in the matrix-pricing table should satisfy the condition, and the price adjustment in this row is applied to the order.

NOTE:  If the search specification in this field can describe more than one record, then the search returns the first matching record that it finds, which may vary from one session to another. You should test search specifications to make sure that they cannot be satisfied by multiple records.

Search specifications use the standard Siebel query syntax and formatting rules, as follows:

Enclose the field name in square brackets, for example, [Entitlement Id]
Specify all names (business object, business component, field) with the same capitalization, spacing, and punctuation used in Siebel Tools.
Join multiple search criteria with AND or OR.
Repeat the field name when you are comparing a field to multiple values.

For more information about the standard syntax used in search specifications and queries, see Siebel Tools Reference.

The following examples will give you a general idea of search specification formatting and syntax. These examples were created to function in a specific context, and they may not to work in your environment.

The following searchspec would be used to give discounts to customers based on their entitlement and the product ordered; it would be used with the sample business component described in A Preconfigured Matrix-Pricing Business Component.

[Entitlement Id]={Order Entry - Orders.Entitlement Id} AND [Product Id]={Order Entry - Line Items.Product Id}

The following search spec would be used to give discounts to customers based on the Service Agreement's price list, the service product and the covered product (the product for that service is for).

[Price List Id]={Service Agreement.Price List Id} AND [Parent Product Id] = {FS Agreement Item.Product Id} AND [Product Id] = {FS Agreement Item.Covered Asset Product Id}

Bookshelf Home | Contents | Index | Search | PDF