JDBC Driver for Zoho Books

Build 22.0.8479


Retrieves list of all the Expenses.

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

  • AccountName supports the '=' comparison.
  • CustomerId supports the '=' comparison.
  • CustomerName supports the '=' comparison.
  • Description supports the '=' comparison.
  • PaidThroughAccountName supports the '=' comparison.
  • ReferenceNumber supports the '=' comparison.
  • Status supports the '=' comparison.
  • VendorId supports the '=' comparison.
  • VendorName supports the '=' comparison.
  • RecurringExpenseId supports the '=' comparison.
  • ExpenseFilter supports the '=' comparison.
  • Date supports the '=,<,>' comparisons.
  • Amount supports the '=,<,<=,>,>=' comparisons.
For example:
    SELECT * FROM Expenses WHERE Amount < 10000.0 AND Amount > 300.0

    SELECT * FROM Expenses WHERE ExpenseFilter = 'Status.Billable'


Name Type References SupportedOperators Description
ExpenseId [KEY] String ID of an expense.
AccountName String Name of the account.
BcyTotal Decimal Total Base Currency.
BcyTotalWithoutTax Decimal Base Currency total amount without tax.
CreatedTime Datetime Time at which the expense was created.
CurrencyCode String Currency code of the customer's currency.
CurrencyId String


Currency ID of the customer's currency.
CustomerId String


ID of the customer or vendor.
CustomerName String Name of the customer or vendor.
Date Date =,<,> Date of an expense.
Description String Description of the expense.
Distance Double Distance Covered.
EndReading String End reading of odometer when creating a mileage expense where mileage_type is odometer.
ExchangeRate Decimal Exchange rate of the currency.
ExpenseReceiptName String Name of the expense receipt.
ExpenseType String Type of an expense.
HasAttachment Boolean Check if the expense has attachment.
IsBillable Boolean Check if the expense is billable.
IsPersonal Boolean Check if the expense is personal.
LastModifiedTime Datetime The time of last modification of the expense.
MileageRate Double Mileage rate for a particular mileage expense.
MileageType String Type of Mileage.
MileageUnit String Unit of the distance travelled.
PaidThroughAccountName String Name of account which payment was paid.
ReferenceNumber String Reference number of a expense.
ReportId String ID of report.
ReportName String Name of the report.
StartReading String Start reading of odometer when creating a mileage expense where mileage_type is odometer.
Status String Status of the expense.

使用できる値は次のとおりです。unbilled, invoiced, reimbursed, non-billable, billable

Total Decimal Total of expenses.
TotalWithoutTax Decimal Total amount of expense calculated without tax.
VendorId String ID of the vendor the expense has been made.
VendorName String Name of the vendor the expense has been made.


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
Amount Decimal Amount of the expenses.
ExpenseFilter String Filter expenses by their status.

使用できる値は次のとおりです。Status.All, Status.Billable, Status.Nonbillable, Status.Reimbursed, Status.InvoicedStatus.Unbilled

RecurringExpenseId String Id of the recurring expense.

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