ODBC Driver for Zoho Books

Build 24.0.9060

BankTransactionImportedTransaction

Retrieves Imported Transactions.

Table Specific Information

Select

The driver 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 driver.

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 Imported Transaction Id.
TransactionId String

BankTransactions.TransactionId

= The Transaction Id.
AccountId String

BankAccounts.AccountId

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060