JDBC Driver for Zoho Books

Build 22.0.8479


Retrieves list of all the payments made by your customer.

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

  • PaymentMode supports the '=' comparison.
  • Amount supports the '=,<,<=,>,>=' comparisons.
  • CustomerName supports the '=' comparison.
  • Date supports the '=' comparison.
  • ReferenceNumber supports the '=' comparison.
  • PaymentModeFilter supports the '=' comparison.
  • Notes supports the '=' comparison.
For example:
    SELECT * FROM CustomerPayments WHERE Amount < 900 AND Amount > 50 AND ReferenceNumber = '1894553000000079879'

    SELECT * FROM CustomerPayments WHERE CustomerName = 'Harry'

    SELECT * FROM CustomerPayments WHERE CONTAINS(ReferenceNumber,'455')


Name Type References SupportedOperators Description
PaymentId [KEY] String Id of a payment.
AccountId String


ID of the Bank Account.
PaymentMode String Mode through which payment is made.
PaymentNumber Integer Number through which payment is made.
PaymentType String Type of the payment.
AccountName String Name of the account.
Amount Decimal =,<,<=,>,>= Amount of the customer payments.
BcyAmount Decimal Amount applied for Base Currency.
BcyRefundedAmount Decimal Refunded amount from Base Currency.
BcyUnusedAmount Decimal Unused amount from Base Currency.
CreatedTime Datetime Time at which the customer payment was created.
CustomerId String


ID of the customer or vendor.
CustomerName String Name of the customer or vendor.
Date Date Date of a customer payment.
GatewayTransactionId String ID of gateway transaction.
HasAttachment Boolean Check if the customer payment has an attachment.
LastModifiedTime Datetime The time of last modification of the customer payment.
ReferenceNumber String Reference number of a customer payment.


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
PaymentModeFilter String Filter customer payments by payment mode.

使用できる値は次のとおりです。PaymentMode.All, PaymentMode.Check, PaymentMode.Cash, PaymentMode.BankTransfer, PaymentMode.Paypal, PaymentMode.CreditCard, PaymentMode.GoogleCheckout, PaymentMode.Credit, PaymentMode.Authorizenet, PaymentMode.BankRemittance, PaymentMode.Payflowpro, PaymentMode.Stripe, PaymentMode.TwoCheckout, PaymentMode.Braintree, PaymentMode.Others

Notes String Notes of customer payments.

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