TDV Adapter for Zoho CRM

Build 21.0.8137

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.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137