ADO.NET Provider for Zoho Books

Build 22.0.8479

BankRules

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

Table Specific Information

Select

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'

Columns

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

Criterion.

RecordAs String False

Entity as which it should be recorded.

RuleAccountId String True

BankAccounts.AccountId

ID of the Bank Account.

AccountName String True

Name of the account.

TaxId String False

Taxes.TaxId

Id of a tax.

TargetAccountId String False

The account on which the rule has to be applied.

AccountId String False

BankAccounts.AccountId

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

CustomerId String False

Contacts.ContactId

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

Taxes.TaxAuthorityId

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