InvoiceProductDetails
Provides detailed product line item information for invoices. This view is not available in free or 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 | Unique identifier for the invoice product detail record. |
| InvoiceId [KEY] | String | Unique identifier of the invoice associated with this product detail. |
| ProductId | String | Unique identifier of the product listed in this detail entry. |
| ProductCode | String | Code used to identify the product in the system. |
| ProductName | String | Name of the product listed in the invoice. |
| ProductDescription | String | Description of the product as provided in the invoice. |
| Quantity | Double | Number of product units included in this invoice detail. |
| Discount | Double | Discount amount applied to this product line item. |
| TotalAfterDiscount | Double | Total amount after applying the discount to this product line. |
| NetTotal | Double | Net total amount excluding taxes and after discounts. |
| Book | String | Ledger or book associated with this product detail. |
| Tax | Double | Total tax amount applied to this product line item. |
| ListPrice | Double | Original listing price of the product before discounts. |
| UnitPrice | Double | Price per unit of the product. |
| QuantityInStock | Double | Current quantity of the product available in stock. |
| Total | Double | Total price for this product line, including discounts and taxes. |
| LineTax | String | Line-level tax breakdown applied to this product detail. |