ReportsAccountTransactionsDetails
Retrieves the list of inline transactions.
Table Specific Information
Select
The connector will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
- TransactionDate supports the '=' comparison.
- ToDate supports the '=' comparison.
- FromDate supports the '=' comparison.
- AccountId supports the '=' comparison.
SELECT * FROM ReportsAccountTransactionsDetails 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
使用できる値は次のとおりです。Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear and CustomDate | |
ToDate | Date | To Date | |
FromDate | Date | From Date |