BankTransactionImportedTransaction
Get Imported Transactions.
Table Specific Information
Select
The 本製品 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 本製品.
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 |