SalesOrderProductDetails
Shows line items and pricing for products included in sales orders. Not available in free or standard ZohoCRM accounts.
View-Specific Information
Select
The add-in 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 add-in.
- SalesOrderId supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM SalesOrderProductDetails WHERE SalesOrderId = '3152079000000355025'
NOTE: ProductDetails has been changed to OrderedItems after v2.
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier for the product detail record. |
| SalesOrderId [KEY] | String | Unique identifier of the sales order this product detail is associated with. |
| ProductId | String | Unique identifier of the product listed in this detail. |
| ProductCode | String | Internal code used to identify the product. |
| ProductName | String | Name of the product listed in this detail. |
| ProductDescription | String | Description of the product listed in this detail. |
| Quantity | Double | Number of product units included in this sales order detail. |
| Discount | Double | Discount amount applied to this line item. |
| TotalAfterDiscount | Double | Total amount for this product line after applying the discount. |
| NetTotal | Double | Net amount before tax for this product detail. |
| Book | String | Ledger or accounting book associated with this product detail. |
| Tax | Double | Tax amount applied to this product detail. |
| ListPrice | Double | Original list price of the product before any adjustments. |
| UnitPrice | Double | Final price per unit of the product. |
| QuantityInStock | Double | Number of units currently available in stock for this product. |
| Total | Double | Final total amount for this product line, including all adjustments. |
| LineTax | String | Breakdown of individual taxes applied to this line item, if applicable. |