JDBC Driver for Zoho CRM

Build 22.0.8462

PriceBookPricingDetails

Query information regarding different pricing details. Not available in free and standard ZohoCRM accounts.

View-Specific Information

Select

The driver 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 driver.

  • 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462