PriceBookPricingDetails
Query information regarding pricing details. Not available in free and standard ZohoCRM accounts.
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 | A unique numeric identifier for the pricing detail. |
| PriceBookId [KEY] | String | A unique numeric identifier for the price book this pricing detail belongs to. |
| Discount | Double | How much discount should be applied for this pricing detail. |
| FromRange | Double | Starting from what amount should this discount be applied. |
| ToRange | Double | Until what amount should this discount be applied. |