JDBC Driver for Zoho Books

Build 22.0.8479


To list, add, update and delete specified bank or credit card account ID.

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

  • RuleAccountId supports the '=' comparison.
  • RuleId supports the '=' comparison.
For example:
    SELECT * FROM BankRules WHERE RuleAccountId = '1894553000000085382' AND RuleId = '1894553000000085386'


Name Type ReadOnly References SupportedOperators Description
RuleId [KEY] String True

Id of the rule.

RuleName String False

Name of the rule.

RuleOrder Integer True

Order of rule.

ApplyTo String False

To whom can rule be applied.

CriteriaType String False

Type of criteria0.

Criterion String False


RecordAs String False

Entity as which it should be recorded.

RuleAccountId String True


ID of the Bank Account.

AccountName String True

Name of the account.

TaxId String False


Id of a tax.

TargetAccountId String False

The account on which the rule has to be applied.

AccountId String False


Account which is involved in the rule with the target account.

CustomerId String False


ID of the customer or vendor.

CustomerName String True

Name of the customer or vendor.

ReferenceNumber String False

Reference number of a bank rule.

PaymentMode String True

Mode through which payment is made.

ProductType String False

Product Type associated with the Rule.

TaxAuthorityId String False


ID of a tax authority.

TaxAuthorityName String True

Name of a tax authority.

TaxExemptionId String False

ID of a tax exemption.

TaxExemptionCode String True

Code of a tax exemption.

IsReverseCharge Boolean True

Check if it is charged reverse.

VatTreatment String False

VAT treatment for the bank rules.

GstTreatment String True

Choose whether the bank rule is GST registered/unregistered/consumer/overseas.

TaxTreatment String True

VAT treatment for the Bank Rule.

GstNo String True

GST Number.

HsnOrSac String True

HSN Code.

DestinationOfSupply String True

Place where the goods/services are supplied to.

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