Excel Add-In for Zoho Books

Build 22.0.8479

ReportsAccountTransactionsDetails

Retrieves the list of inline transactions.

Table Specific Information

Select

The 本製品 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 本製品.

  • TransactionDate supports the '=' comparison.
  • ToDate supports the '=' comparison.
  • FromDate supports the '=' comparison.
  • AccountId supports the '=' comparison.
For example:
    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

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