Power BI Connector for Zoho Books

Build 20.0.7654

ChartOfAccounts

Retrieves list of all chart of accounts.

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 本製品. You can even provide criteria to search for matching uncategorised transactions.

  • LastModifiedTime supports the '=' comparison.
  • ShowBalance supports the '=' comparison.
  • AccountType supports the '=' comparison.
For example:
    SELECT * FROM ChartOfAccounts WHERE AccountType = 'All' AND ShowBalance = true

Columns

Name Type References SupportedOperators Description
ChartAccountId [KEY] String

BankAccounts.AccountId

Id of the Bank Account.
AccountName String Name of the account.
AccountType String Type of the account.

使用できる値は次のとおりです。All, Active, Inactive, Asset, Liability, Equity, Income, Expense

CanShowInZe Boolean Check if it can show in Zero Emission.
ChildCount String Child count in chart of accounts.
CreatedTime Datetime Time at which the Chart of Accounts was created.
CustomFields String Custom Fields defined for the chart of account
Depth Integer Depth of account.
Description String Description of the Chart of Account.
HasAttachment Boolean Check if the chart of account has attachment.
IsActive Boolean Check if chart of account is active.
IsChildPresent Boolean Check if the child is present in chart of account.
IsStandaloneAccount Boolean Check if the account is standalone account.
IsUserCreated Boolean Check if the account is created by the user.
LastModifiedTime Datetime Last Modified time associated with the entity.
ParentAccountName String Account name of parent.
AccountCode String Code of the Account.
ClosingBalance Decimal Closing balance of account. This field will be populated with a value only when the Chart Account Id is specified.
IsInvolvedInTransaction Boolean Check if this account is involved in the transaction.
IsSystemAccount Boolean Check if it is a system account.
IsDebit Boolean Check if this account is debit. This field will be populated with a value only when the Chart Account Id is specified.
ParentAccountId String

BankAccounts.AccountId

Id of a Parent account.

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
ShowBalance Boolean Boolean to get current balance of accounts.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654