SSIS Components for Zoho Books

Build 22.0.8509

BankAccountLastImportedStatementTransactions

Get the details of transaction related to previously imported statement for the account.

Table Specific Information

Select

The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:

  • AccountId supports the '=,IN' comparison.

The rest of the filter is executed client-side in the 本製品.

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 Transaction Id
AccountId String

BankAccounts.AccountId

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8509