JDBC Driver for Zoho Books

Build 22.0.8479


Retrieves the list of inline transactions.

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

  • TransactionDate supports the '=' comparison.
  • ToDate supports the '=' comparison.
  • FromDate supports the '=' comparison.
  • AccountId supports the '=' comparison.
For example:
    SELECT * FROM ReportsAccountTransactionsDetails

    SELECT * FROM ReportsAccountTransactionsDetails WHERE TransactionDate = 'Today'

    SELECT * FROM ReportsAccountTransactionsDetails WHERE ToDate = '2022-10-31'

    SELECT * FROM ReportsAccountTransactionsDetails WHERE FromDate = '2022-10-10' and ToDate = '2022-10-31'

    SELECT * FROM ReportsAccountTransactionsDetails WHERE AccountId = 1055236000000014066


Name Type References SupportedOperators Description
AccountGroup String Account Group
AccountType String Account Type
AccountId Long = Account Id
AccountName String Account Name
Branch String Branch
ContactId Long


Contact Id
Credit Decimal Credit
CurrencyCode String Currency Code
Date Date Date
Debit Decimal Debit
EntityNumber String Entity Number
NetAmount String Net Amount
OffsetAccountId Long Offset Account Id
OffsetAccountType String Offset Account Type
ProjectIds Long


Project Ids
ReferenceNumber String Reference Number
ReferenceTransactionId Long Reference Transaction Id
TransactionDetails String Transaction Details
TransactionType String Transaction Type
TransactionId Long Transaction Id


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
TransactionDate String Transaction Date

使用できる値は次のとおりです。Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear and CustomDate

ToDate Date To Date
FromDate Date From Date

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