Power BI Connector for Zoho CRM

Build 24.0.9062

PriceBookPricingDetails

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

View-Specific Information

Select

The 本製品 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 本製品.

  • 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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062