ODBC Driver for Zoho Books

Build 24.0.9060

BankAccountLastImportedStatementTransactions

Retrieves the details of transactions related to previously imported statements for the account.

Table Specific Information

Select

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

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

For example:

    SELECT * FROM BankAccountLastImportedStatementTransactions WHERE accountid = '3255827000000101306'

    SELECT * FROM BankAccountLastImportedStatementTransactions WHERE accountid IN ('3255827000000101306', '3255827000000101223')

Columns

Name Type References SupportedOperators Description
TransactionId [KEY] Long The Transaction Id.
AccountId String

BankAccounts.AccountId

= The Id of the Bank/Credit Card account.
TransactionType String The Transaction Type.
Status String Status.
ReferenceNumber String A Reference Number.
Payee String The Payee involved in the transaction.
DebitOrCredit String Indicates if transaction is Debit or Credit.
Date Date The Date of the transaction.
CustomerId Long The Customer Id.
Amount Integer The Amount involved in the transaction.

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