Lists Account Details of Base Currency Adjustment.

Table Specific Information

Select

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

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.