ReportsAccountTransactionsDetails
Retrieves the list of inline transactions.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- TransactionDate supports the '=' comparison.
- ToDate supports the '=' comparison.
- FromDate supports the '=' comparison.
- AccountId supports the '=' comparison.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM ReportsAccountTransactionsDetails WHERE TransactionDate = 'Today'
SELECT * FROM ReportsAccountTransactionsDetails WHERE ToDate = '2022-10-31'
SELECT * FROM ReportsAccountTransactionsDetails WHERE FromDate = '2022-10-10' AND ToDate = '2022-10-31'
SELECT * FROM ReportsAccountTransactionsDetails WHERE AccountId = 1055236000000014066
Columns
| Name | Type | References | SupportedOperators | Description |
| AccountGroup | String | Account Group. | ||
| AccountType | String | Account Type. | ||
| AccountId | Long | = | Account Id. | |
| AccountName | String | Account Name. | ||
| Branch | String | Branch. | ||
| ContactId | Long |
Contacts.ContactId | Contact Id. | |
| Credit | Decimal | Credit. | ||
| CurrencyCode | String | Currency Code. | ||
| Date | Date | Date. | ||
| Debit | Decimal | Debit. | ||
| EntityNumber | String | Entity Number. | ||
| NetAmount | String | Net Amount. | ||
| OffsetAccountId | Long | Offset Account Id. | ||
| OffsetAccountType | String | Offset Account Type. | ||
| ProjectIds | Long |
Projects.ProjectId | Project Ids. | |
| ReferenceNumber | String | Reference Number. | ||
| ReferenceTransactionId | Long | Reference Transaction Id. | ||
| TransactionDetails | String | Transaction Details. | ||
| TransactionType | String | Transaction Type. | ||
| TransactionId | Long | Transaction Id. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| TransactionDate | String | Transaction Date.
The allowed values are Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear and CustomDate. | |
| ToDate | Date | To Date. | |
| FromDate | Date | From Date. |