PriceBookPricingDetails
Query information regarding pricing details. Not available in free and standard ZohoCRM accounts.
View-Specific Information
Select
The connector 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 connector.
- 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. |