QuoteProductDetails
Query information regarding quote product 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 本製品.
- 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. |