JDBC Driver for Zoho Books

Build 22.0.8479


Generated schema file.

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.
  • CashBased supports the '=' comparison.
  • AccountType supports the '=' comparison.
  • ProjectId supports the 'IN, IS NULL, IS NOT NULL' comparison.
For example:
    SELECT * FROM GeneralLedgerReport

    SELECT * FROM GeneralLedgerReport WHERE TransactionDate = 'Today'

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

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

    SELECT * FROM GeneralLedgerReport WHERE CashBased = True
	SELECT * FROM GeneralLedgerReport WHERE AccountType = 'Asset'
	SELECT * FROM GeneralLedgerReport WHERE ProjectId IN ('234457895670')


Name Type References SupportedOperators Description
AccountCode String Account Code
AccountGroup String Account Group
AccountId String Account Id
Balance Integer Balance
BalanceSubAccount String Balance Sub Account
ClosingBalance Integer Closing Balance
ClosingBalanceSubAccount Integer Closing Balance Sub Account
CreditTotal Integer Credit Total
CreditTotalSubAccount String Credit TotalSub Account
DebitTotal Integer Debit Total
DebitTotalSubAccount String Debit TotalSub Account
Depth Integer Depth
IsChildPresent Boolean Is Child Present
IsCollapsedView Boolean Is Collapsed View
IsDebit Boolean IsDebit
Name String Name
OpeningBalance Integer Opening Balance
OpeningBalanceSubAccount Integer Opening Balance Sub Account
PreviousValues String Previous Values
AccountType String = Account Type

使用できる値は次のとおりです。Asset, OtherAsset, OtherCurrentAsset, Bank, Cash, FixedAsset, Liability, OtherCurrentLiability, CreditCard, LongTermLiablity, OtherLiability, Equity, Income, OtherIncome, Expense, CostOfGoodsSold, OtherExpense, AccountsReceivable, AccountsPayable, Stock, PaymentClearingAccount, PrepaidCard, OverseasTaxPayable, OutputTax, InputTax


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
CashBased Boolean Cash Based
TransactionDate String Filter transaction by any transaction date.

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

ToDate Date To Date
FromDate Date From Date
ProjectId String

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