ODBC Driver for Zoho Books

Build 24.0.9062

AccountDetailsBaseCurrencyAdjustmentAccounts

Lists Account Details of Base Currency Adjustment.

Table Specific Information

Select

The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:

  • CurrencyId supports the '=' comparison.
  • AdjustmentDate supports the '=' comparison.
  • ExchangeRate supports the '=' comparison.
  • Notes supports the '=' comparison.

NOTE: CurrencyId, AdjustmentDate, ExchangeRate, Notes are required to query AccountDetailsBaseCurrencyAdjustmentAccounts.

The rest of the filter is executed client-side in the 本製品.

For example:

    SELECT * FROM AccountDetailsBaseCurrencyAdjustmentAccounts WHERE AdjustmentDate = '2023-03-16' AND CurrencyId = 3255827000000000097 AND ExchangeRate = '80.6719' AND Notes = 'adjustment'
	

Columns

Name Type References SupportedOperators Description
AccountId String

BankAccounts.AccountId

The Id of the Bank/Credit Card account.
AccountName String The Account Name.
AdjustedBalance Decimal The Adjusted Balance.
BCYBalance Decimal The Balance in Base Currency.
FCYBalance Integer The Balance in Foreign Currency.
GAINORLOSS Integer Gain Or Loss.
GLSpecificType Integer The GL Specific Type.
AdjustmentDate Date = The Adjustment Date.
CurrencyId String

Currencies.CurrencyId

= THe Currency Id.
ExchangeRate Decimal = The Exchange Rate.
Notes String = Notes.

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