ADO.NET Provider for Zoho Books

Build 20.0.7654

ChartOfAccountTransactions

Retrieves list of all involved transactions for the given account.

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 本製品. You can even provide criteria to search for matching uncategorised transactions.

  • ChartAccountId supports the '=' comparison.
  • TransactionType supports the '=' comparison.
  • Date supports the '=,<,>' comparisons.
  • Amount supports the '=,<,<=,>,>=' comparisons.
For example:
    SELECT * FROM ChartOfAccountTransactions WHERE ChartAccountId = '1894553000000003001' AND TransactionType = 'opening_balance'

Columns

Name Type References SupportedOperators Description
ChartAccountId String

BankAccounts.AccountId

ID of the Bank Account.
CategorizedTransactionId [KEY] String ID of a categorized transaction in chart of account.
CreditAmount Integer Total amount credited.
CurrencyCode String Currency code of the customer's currency.
CurrencyId String

Currencies.CurrencyId

Currency ID of the customer's currency.
CustomerId String

Contacts.ContactId

ID of the customer or vendor.
DebitOrCredit String Indicates if transaction is Credit or Debit.
Description String Description of the chart of account transactions.
EntryNumber String Entry number of account transaction.
Payee String Information about the payee.
TransactionDate Date Date of the transaction.
TransactionId String

BankTransactions.TransactionId

ID of the Transaction.
TransactionType String Type of transactions.

使用できる値は次のとおりです。invoice, customer_payment, bills, vendor_payment, credit_notes, creditnote_refund, expense, card_payment, purchase_or_charges, journal, deposit, refund, transfer_fund, base_currency_adjustment, opening_balance, sales_without_invoices, expense_refund, tax_refund, receipt_from_initial_debtors, owner_contribution, interest_income, other_income, owner_drawings, payment_to_initial_creditors

Pseudo-Columns

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
Date Date Date range filter of Chart of Account.
Amount Decimal Amount of the transaction.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654