PriceBookPricingDetails
Returns product-specific prices from price books; available only in paid Zoho CRM editions.
View-Specific Information
Select
The add-in uses the Zoho CRM API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the add-in.
- PriceBookId supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM PriceBookPricingDetails WHERE PriceBookId = '3152079000000317001'
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique numeric identifier for the pricing detail. |
| PriceBookId [KEY] | String | Unique numeric identifier for the price book associated with this pricing detail. |
| Discount | Double | The discount percentage or amount applied for this pricing detail. |
| FromRange | Double | Lower boundary of the amount range for which the discount is applicable. |
| ToRange | Double | Upper boundary of the amount range for which the discount is applicable. |