JDBC Driver for Zoho Books

Build 22.0.8479


Retrieves list of all purchase orders.

Table Specific Information


The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.

  • Date supports the '=' comparison.
  • LastModifiedTime supports the '=' comparison.
  • PurchaseorderNumber supports the '=' comparison.
  • ReferenceNumber supports the '=' comparison.
  • Status supports the '=' comparison.
  • Total supports the '=,<,<=,>,>=' comparisons.
  • VendorId supports the '=' comparison.
  • VendorName supports the '=' comparison.
  • PurchaseOrderFilter supports the '=' comparison.
  • ItemId supports the '=' comparison.
  • ItemDescription supports the '=' comparison.
For example:
    SELECT * FROM PurchaseOrders WHERE VendorId = 1894553000000077963

    SELECT * FROM PurchaseOrders WHERE Total < 300

    SELECT * FROM PurchaseOrders WHERE CONTAINS(PurchaseorderNumber,'PO-')


Name Type References SupportedOperators Description
PurchaseorderId [KEY] String ID of a purchase order.
BilledStatus String Billed status of a purchase order.
ClientViewedTime Datetime Last time when the client has viewed purchase order.
ColorCode String Color code of this purchase order.
CompanyName String Name of the company.
CreatedTime Datetime Time at which the purchase order was created.
CurrencyCode String Currency code of the customer's currency.
CurrencyId String


Currency ID of the customer's currency.
CurrentSubStatus String Current sub status of a purchase order.
CurrentSubStatusId String Current sub status ID of a purchase order.
Date Date The date the purchase order is created.
DeliveryDate Date Delivery date of the order.
HasAttachment Boolean Check if the purchase order has attachment.
IsDropShipment Boolean Check if it has drop shipment.
IsViewedByClient Boolean Check if the purchase order is viewed by client.
LastModifiedTime Datetime Last modified time of a purchase order.
OrderStatus String Status of purchase order.
PricePrecision String The precision for the price.
PurchaseorderNumber String Number of the purchase order.
QuantityYetToReceive Decimal Number of quantity yet to receive from purchase order.
ReferenceNumber String Reference number of a purchase order.
Status String Status of a purchase order.

使用できる値は次のとおりです。draft, open, billed, cancelled

Total Decimal =,<,<=,>,>= Total of purchase orders. Search by purchase order total.
VendorId String ID of the vendor the purchase orders has been made. Search by vendor id.
VendorName String Name of the vendor the purchase orders has been made. Search by vendor name.


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
PurchaseOrderFilter String Filter purchase order by any status.

使用できる値は次のとおりです。Status.All, Status.Draft, Status.Open, Status.Billed, Status.Cancelled

ItemId String Id of an item.
ItemDescription String Description of an item.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479