AccountDetailsBaseCurrencyAdjustment
Retrieves 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 AccountDetailsBaseCurrencyAdjustment.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM AccountDetailsBaseCurrencyAdjustment WHERE AdjustmentDate = '2023-03-16' AND CurrencyId = 3255827000000000097 AND ExchangeRate = '80.6719' AND Notes = 'adjustment'
Columns
Name | Type | References | SupportedOperators | Description |
Accounts | String | Accounts. | ||
CurrencyCode | String | The Currency Code. | ||
AdjustmentDate | Date | = | The Adjustment Date. | |
CurrencyId | String |
Currencies.CurrencyId | = | The Currency Id of the customer's currency. |
ExchangeRate | Decimal | = | The Exchange rate of the currency. | |
Notes | String | = | Notes for base currency adjustment. |