PriceBookPricingDetails
Returns product-specific pricing as defined in price books; restricted in free and standard 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 identifier for the pricing detail. |
| PriceBookId [KEY] | String | Unique identifier for the price book associated with this pricing detail. |
| Discount | Double | The discount amount to be applied for this pricing detail. |
| FromRange | Double | The minimum value from which the discount begins to apply. |
| ToRange | Double | The maximum value up to which the discount applies. |