BankTransactionImportedTransaction
Get Imported Transactions.
Table Specific Information
Select
The component uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- TransactionId supports the '=,IN' comparison.
The rest of the filter is executed client-side in the component.
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 | = | Transaction Id |
| AccountId | String |
BankAccounts.AccountId | ID of the Bank/Credit Card account | |
| Amount | Integer | Amount | ||
| Date | Date | Date of the transaction | ||
| Description | String | Description | ||
| Payee | String | Payee involved in the transaction | ||
| ReferenceNumber | String | Reference Number | ||
| Status | String | Status |