Power BI Connector for Zoho Books

Build 22.0.8479

JournalReport

Generated schema file.

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.
  • CashBased supports the '=' comparison.
For example:
    SELECT * FROM JournalReport

    SELECT * FROM JournalReport WHERE TransactionDate = 'Today'

    SELECT * FROM JournalReport WHERE ToDate = '2022-10-31'

    SELECT * FROM JournalReport WHERE FromDate = '2022-10-10' and ToDate = '2022-10-31'

    SELECT * FROM JournalReport WHERE CashBased = True

Columns

Name Type References SupportedOperators Description
AccountTransactionsAccountId String Account Transactions Account Id
AccountTransactionsAccountName String Account Transactions Account Name
AccountTransactionsDebitAmount String Account Transactions Debit Amount
AccountTransactionsCreditAmount String Account Transactions Credit Amount
ContactId String Contact Id
ContactName String Contact Name
CreditFcyTotal Integer CreditFcyTotal
CreditTotal Integer CreditTotal
Date String Date
DebitFcyTotal Integer Debit FcyTotal
DebitTotal Integer Debit Total
EntityId String Entity Id
TransactionId String Transaction Id
TransactionNumber String Transaction Number
TransactionType String Transaction Type

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
CashBased Boolean Balance Type Total
TransactionDate String Filter transaction by any 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