ADO.NET Provider for Zoho Books

Build 26.0.9655

BankTransactionImportedTransaction

Retrieves Imported Transactions.

Table Specific Information

Select

The provider uses the Zoho Books API to process WHERE clause conditions built with the TransactionId column, which supports '=,IN' comparisons.

The rest of the filter is executed client-side in the provider.

For example:

    SELECT * FROM BankTransactionImportedTransaction WHERE transactionid = '3255827000000101458'

    SELECT * FROM BankTransactionImportedTransaction WHERE transactionid IN ('3255827000000101458', '3255827000000102354')

Columns

Name Type References SupportedOperators Description
ImportedTransactionId [KEY] Long The Imported Transaction Id
TransactionId String

BankTransactions.TransactionId

= The Transaction Id
AccountId String

BankAccounts.AccountId

The Id of the Bank/Credit Card account
Amount Integer Amount
Date Date The Date of the transaction
Description String Description
Payee String The Payee involved in the transaction
ReferenceNumber String A Reference Number
Status String Status

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655