JDBC Driver for Zoho CRM

Build 23.0.8839

PurchaseItems

Query information regarding different product details.

View-Specific Information

Select

The driver 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 driver.

  • Id supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM PurchaseItems WHERE Id = '3152079000000301143'

NOTE: This table is not supported in v2.

Columns

Name Type Description
Id [KEY] String
S.NO Long
CreatedTime Datetime
ModifiedTime Datetime
ParentID_Id String
ParentID_Name String
ProductName_Id String
ProductName_Name String
PriceBook_Id String
PriceBook_Name String
Description String
Quantity String
ListPrice Decimal
Amount String
Discount Decimal
TotalAfterDiscount String
Tax Decimal
Total String
TaxbyPercentage String

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Word String
DuplicateCheckFields String
Converted Bool
Approved Bool
CustomViewId String
Trigger String

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839