InvoiceProductDetails
Query information regarding product details. Not available in free and standard ZohoCRM 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.
- InvoiceId supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM InvoiceProductDetails WHERE InvoiceId = '3152079000000301143'
NOTE: ProductDetails has been changed to InvoicedItems after v2
Columns
| Name | Type | Description |
| Id [KEY] | String | A unique numeric identifier for the product detail. |
| InvoiceId [KEY] | String | A unique numeric identifier for the invoice 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. |