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

  • PODate supports the '=' comparison.
  • ToDate supports the '=' comparison.
  • FromDate supports the '=' comparison.
  • VendorId supports the 'IN, NOT IN' comparison.
  • Status supports the 'IN' comparison.
For example:
    SELECT * FROM PurchaseOrdersByVendorReport

    SELECT * FROM PurchaseOrdersByVendorReport WHERE PODate = 'Today'

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

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

    SELECT * FROM PurchaseOrdersByVendorReport WHERE Status in ('draft')
	SELECT * FROM PurchaseOrdersByVendorReport WHERE VendorId in ('3285934000000104023')


Name Type References SupportedOperators Description
Amount Integer Amount
Count Integer Count
FcyAmount Integer Fcy Amount
VendorCompanyName String Vendor CompanyName
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 First Name
VendorLastModifiedTime Datetime Vendor Last ModifiedTime
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 Amount Bcy
VendorPaymentTerms String Vendor Payment Terms
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 Amount Bcy
VendorWebsite String Vendor Website
VendorName String Vendor Name
VendorId String IN, NOT IN 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
PODate String Filter transaction by any purchase order date.

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

ToDate Date To Date
FromDate Date From Date
Status String Status

使用できる値は次のとおりです。draft, pending_approval, approval_overdue, approved, rejected, open, billed, billed_not_received, cancelled, partially_billed, issued, partially_received, received, received_not_billed, manually_received, drop_shipped, closed, accepted, signed

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