JDBC Driver for Zoho Books

Build 22.0.8479


Get the list of payments made for a bill.

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

  • BillId supports the '=' comparison.
For example:
    SELECT * FROM BillPayments WHERE BillId = '1894253000000085259'


Name Type References SupportedOperators Description
BillPaymentId [KEY] String ID of bill payment.
BillId String


ID of a Bill.
VendorId String ID of the vendor the bill payments has been made.
VendorName String Name of the vendor the bill payments has been made.
PaymentId String Id of a payment.
Amount Decimal Amount of the bill payments.
Date Date Date of a bill payment.
Description String Description of the bill payment.
ExchangeRate Decimal Exchange rate of bill payments.
IsSingleBillPayment Boolean Check if it is single bill payment.
PaidThrough String Amount paid via check/cash/credit.
PaymentMode String Mode through which payment is made.
ReferenceNumber String Reference number of bill payment.

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