PurchaseOrderProductDetails
Query information regarding different product details. Not available in free and standard ZohoCRM accounts.
View-Specific Information
Select
The adapter will use 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 adapter.
- PurchaseOrderId supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM PurchaseOrderProductDetails WHERE PurchaseOrderId = '3152079000000317029'
Columns
| Name | Type | Description |
| Id [KEY] | String | A unique numeric identifier for the product detail. |
| PurchaseOrderId [KEY] | String | A unique numeric identifier for the purchase order 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. |