Power BI Connector for Zoho Books

Build 20.0.7654

OpeningBalanceAccounts

Retrieves list of accounts of opening balance.

Table Specific Information

Select

No filters are supported server side for this table. All criteria will be handled client side within the {i.

Columns

Name Type References SupportedOperators Description
AccountId [KEY] String

BankAccounts.AccountId

ID of an account.
AccountName String Name of an account.
AccountSplitId String Split ID of an account.
AccountType String Type of the account.
BcyAmount Decimal Base currency of the amount.
CurrencyCode String Code of currency.
CurrencyId String

Currencies.CurrencyId

ID of a currency.
DebitOrCredit String Type of mode the opening balance is.
ExchangeRate Decimal Exchange rate of the currency.
ProductId String ID of the product.
ProductName String Name of the product.
ProductStock Integer Stock of the product.
ProductStockRate Integer Stock rate of the product.

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