Retrieves account details of Base Currency Adjustment

Table Specific Information

Select

The add-in 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 add-in.

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			The 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