Excel Add-In for Zoho Books

Build 24.0.9060

BaseCurrencyAdjustmentAccounts

Retrieves lists of base currency adjustment accounts.

Table Specific Information

Select

The add-in uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:

  • BaseCurrencyAdjustmentId supports the '=' comparison.

The rest of the filter is executed client-side in the add-in.

For example:

    SELECT * FROM BaseCurrencyAdjustmentAccounts WHERE BaseCurrencyAdjustmentId = '1894553000000000065'

Columns

Name Type References SupportedOperators Description
BaseCurrencyAdjustmentId [KEY] String Id of base currency adjustment account.
AccountId String

BankAccounts.AccountId

Id of the Bank Account.
AccountName String Name of the account.
BcyBalance Decimal Balance of Base Currency.
FcyBalance Decimal Balance of Foreign Currency.
AdjustedBalance Decimal Balance adjusted for base currency.
GainOrLoss Decimal Check the amount if gain or loss.
GlSpecificType String Specific type of gain or loss.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060