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

  • ReportDate supports the '=' comparison.
  • VendorId supports the '=' comparison.
For example:
    SELECT * FROM VendorBalancesReport

    SELECT * FROM VendorBalancesReport WHERE ReportDate = '2022-10-31'
    SELECT * FROM VendorBalancesReport WHERE VendorId   = '3285934000000104023'


Name Type References SupportedOperators Description
VendorName String Vendor Name
BillBalance Integer Bill Balance
BcyAdvancePayment String Bcy Advance Payment
BcyBalance Integer Bcy Balance
BcyBillBalance Integer Bcy Bill Balance
BcyCreditBalance String Bcy Credit Balance
BcyExcessPayment Integer Bcy Excess Payment
BcyJournalCredits String Bcy Journal Credits
CurrencyId String CurrencyId
ExcessPayment Integer Excess Payment
FcyAdvancePayment String Fcy Advance Payment
FcyBalance Integer Fcy Balance
FcyCreditBalance String Fcy Credit Balance
FcyJournalCredits String Fcy Journal Credits
VendorCompanyName String Vendor Company Name
VendorCreatedBy String Vendor Created By
VendorCreatedTime Datetime Vendor Created Time
VendorDepartment String Vendor Department
VendorDesignation String Vendor Designation
VendorEmail String Vendor Email
VendorFacebook String Vendor Facebook
VendorFirstName String Vendor FirstName
VendorLastModifiedTime Datetime Vendor Last Modified Time
VendorLastName String Vendor Last Name
VendorMobilePhone String Vendor Mobile Phone
VendorNotes String Vendor Notes
VendorOutstandingPayableAmount Integer Vendor Outstanding Payable Amount
VendorOutstandingPayableAmountBcy Integer Vendor Outstanding Payable AmountBcy
VendorPaymentTerms String Vendor PaymentTerms
VendorPhone String Vendor Phone
VendorSkype String Vendor Skype
VendorStatus String Vendor Status
VendorTwitter String Vendor Twitter
VendorUnusedCreditsPayableAmount Integer Vendor Unused Credits Payable Amount
VendorUnusedCreditsPayableAmountBcy Integer Vendor Unused Credits Payable AmountBcy
VendorWebsite String Vendor Website
VendorId String = Vendor 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
ReportDate Date Report Date

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