JDBC Driver for Zoho Books

Build 22.0.8479


Retrieves list of bills.

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 本製品.

  • BillNumber supports the '=' comparison.
  • Date supports the '=,<,>' comparisons.
  • LastModifiedTime supports the '=' comparison.
  • ReferenceNumber supports the '=' comparison.
  • Status supports the '=' comparison.
  • Total supports the '=,<,<=,>,>=' comparisons.
  • VendorId supports the '=' comparison.
  • VendorName supports the '=' comparison.
  • PurchaseOrderId supports the '=' comparison.
  • RecurringBillId supports the '=' comparison.
  • BillFilter supports the '=' comparison.
  • ItemId supports the '=' comparison.
  • ItemDescription. supports the '=' comparison.
For example:
    SELECT * FROM Bills WHERE Total < 100 AND Total <= 98

    SELECT * FROM Bills WHERE Date < '2018-07-03'

    SELECT * FROM Bills WHERE CONTAINS(BillNumber,'Bi')


Name Type References SupportedOperators Description
BillId [KEY] String Id of a bill.
BillNumber String Number of bill.
Balance Decimal Amount of bill.
CreatedTime Datetime Time at which the bill was created.
Date Date =,<,> Date of a bill.
DueDate Date Delivery date to pay the bill.
DueDays String Due days to pay the bill.
HasAttachment Boolean Check if the bill has attachment.
LastModifiedTime Datetime Last Modified Time of bill.
ReferenceNumber String Reference number of a bill.
Status String Status of a bill.

使用できる値は次のとおりです。paid, open, overdue, void, partially_paid

TdsTotal Decimal Total amount of TDS applied.
Total Decimal =,<,<=,>,>= Total of bills. Search by bill total.
VendorId String ID of the vendor the bill has been made. Search bills by Vendor ID.
VendorName String Name of the vendor the bill has been made. Search bills 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
PurchaseOrderId String Id of a Purchase Order.
RecurringBillId String Id of a Recurring Bill.
BillFilter String Filter bills by any status.

使用できる値は次のとおりです。Status.All, Status.PartiallyPaid, Status.Paid, Status.Overdue, Status.Void, Status.Open

ItemId String Id of an Item.
ItemDescription String Description of a bill.

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