JDBC Driver for Zoho CRM

Build 22.0.8462

QuoteProductDetails

Query information regarding different product 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.

  • QuoteId supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM QuoteProductDetails WHERE QuoteId = '3152079000000317060'

Columns

Name Type Description
Id [KEY] String A unique numeric identifier for the product detail.
QuoteId [KEY] String A unique numeric identifier for the quote this product detail belongs to.
ProductId String A unique numeric identifier for the id of the product.
ProductCode String The code of the product.
ProductName String The name of the product.
ProductDescription String The description of the product.
Quantity Double The quantity of products in this product detail.
Discount Double The discount applied to this product detail.
TotalAfterDiscount Double The total after discount for this product detail.
NetTotal Double The net total for this product detail.
Book String The book linked with this product detail.
Tax Double The total tax of this product detail.
ListPrice Double The listing price of this product detail.
UnitPrice Double The unit price of the product.
QuantityInStock Double The quantity in stock for this product.
Total Double The total price for this product detail.
LineTax String A line tax aggregate regarding this product detail.

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