Retrieves list of base currency adjustment.
Table Specific Information
The connector will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector. By default, response will be showing the base currency adjustments of current month only.
- BaseCurrencyAdjustmentId supports the '=' comparison.
- BaseCurrencyAdjustmentsFilter supports the '=' comparison.
SELECT * FROM BaseCurrencyAdjustments WHERE BaseCurrencyAdjustmentsFilter = 'Date.All'
|BaseCurrencyAdjustmentId [KEY]||String||Id of a base currency adjustment.|
|CurrencyCode||String||Currency code of the customer's currency.|
|Currency ID of the customer's currency.|
|AdjustmentDate||Date||Date of currency adjustment.|
|ExchangeRate||Decimal||Exchange rate of currency adjustment.|
|GainOrLoss||Decimal||Check the amount if gain or loss.|
|Notes||String||Notes of Base cuurrency adjustments.|
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
|BaseCurrencyAdjustmentsFilter||String||Filter base currency adjustment list.
The allowed values are Date.All, Date.Today, Date.ThisWeek, Date.ThisMonth, Date.ThisQuarter, Date.ThisYear.