SSIS Components for Zoho CRM

Build 24.0.9060

PriceBookPricingDetails

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

View-Specific Information

Select

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

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