QuoteProductDetails
Displays product-level details for quotes, including discounts, taxes, and quantity. Not available in free or standard 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.
- 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 | Unique identifier for the quote product detail record. |
| QuoteId [KEY] | String | Identifier of the quote associated with this product detail. |
| ProductId | String | Identifier of the product included in the quote. |
| ProductCode | String | Code used to identify the product. |
| ProductName | String | Name of the product listed in the quote. |
| ProductDescription | String | Description of the product included in the quote. |
| Quantity | Double | Quantity of the product in this line item. |
| Discount | Double | Discount amount or percentage applied to this product line. |
| TotalAfterDiscount | Double | Total amount for this product line after applying the discount. |
| NetTotal | Double | Net total amount for the product line before tax. |
| Book | String | Ledger or accounting book associated with this product detail. |
| Tax | Double | Total tax amount applied to this product line. |
| ListPrice | Double | Original listed price of the product before any discounts. |
| UnitPrice | Double | Price per unit of the product. |
| QuantityInStock | Double | Quantity of the product currently available in stock. |
| Total | Double | Final total price for this product detail, including discounts and taxes. |
| LineTax | String | Tax breakdown applied to this specific product line. |