JDBC Driver for Zoho Books

Build 22.0.8479


Retrieves list of all involved transactions for the given account.

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 本製品. You can even provide criteria to search for matching uncategorised transactions.

  • ChartAccountId supports the '=' comparison.
  • TransactionType supports the '=' comparison.
  • Date supports the '=,<,>' comparisons.
  • Amount supports the '=,<,<=,>,>=' comparisons.
For example:
    SELECT * FROM ChartOfAccountTransactions WHERE ChartAccountId = '1894553000000003001' AND TransactionType = 'opening_balance'


Name Type References SupportedOperators Description
ChartAccountId String


Chart of Account Id.
CategorizedTransactionId [KEY] String ID of a categorized transaction in chart of account.
CreditAmount Decimal Total amount credited.
DebitAmount Decimal Total amount debited.
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.
DebitOrCredit String Indicates if transaction is Credit or Debit.
Description String Description of the chart of account transactions.
EntryNumber String Entry number of account transaction.
Payee String Information about the payee.
TransactionDate Date Date of the transaction.
TransactionId String


ID of the Transaction.
TransactionType String Type of transactions.

使用できる値は次のとおりです。invoice, customer_payment, bills, vendor_payment, credit_notes, creditnote_refund, expense, card_payment, purchase_or_charges, journal, deposit, refund, transfer_fund, base_currency_adjustment, opening_balance, sales_without_invoices, expense_refund, tax_refund, receipt_from_initial_debtors, owner_contribution, interest_income, other_income, owner_drawings, payment_to_initial_creditors


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
Date Date Date range filter of Chart of Account.
Amount Decimal Amount of the transaction.

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