PurchaseOrderProductDetails
Returns item-level purchase order information, such as quantity and unit price. Not available in free or standard 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.
- PurchaseOrderId supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM PurchaseOrderProductDetails WHERE PurchaseOrderId = '3152079000000317029'
NOTE: ProductDetails has been changed to PurchaseItems after v2.
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier for the purchase order product detail record. |
| PurchaseOrderId [KEY] | String | Identifier of the purchase order associated with this product detail. |
| ProductId | String | Identifier of the product included in the purchase order. |
| ProductCode | String | Code used to identify the product. |
| ProductName | String | Name of the product listed in the purchase order. |
| ProductDescription | String | Description of the product. |
| Quantity | Double | Quantity of the product included in this line item. |
| Discount | Double | Discount applied to this product line. |
| TotalAfterDiscount | Double | Total amount after applying the discount to this product line. |
| NetTotal | Double | Net total amount before taxes for this product detail. |
| Book | String | Ledger or accounting book associated with this product detail. |
| Tax | Double | Total tax amount applied to this product line. |
| ListPrice | Double | Original listed price of the product. |
| 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 | Tax breakdown for this specific product line. |