BaseCurrencyAdjustments
List, add, update and delete 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:
- BaseCurrencyAdjustmentId supports the '=' comparison.
- BaseCurrencyAdjustmentsFilter supports the '=' comparison.
By default, response shows the base currency adjustments of the current month only.
The rest of the filter is executed client-side in the add-in.
For example:
SELECT * FROM BaseCurrencyAdjustments WHERE BaseCurrencyAdjustmentsFilter = 'Date.All'
Columns
| Name | Type | ReadOnly | References | SupportedOperators | Description |
| BaseCurrencyAdjustmentId [KEY] | String | True |
Id of a base currency adjustment. | ||
| CurrencyCode | String | True |
Currency code of the customer's currency. | ||
| CurrencyId | String | False |
Currencies.CurrencyId |
Currency Id of the customer's currency. | |
| AdjustmentDate | Date | False |
Date of currency adjustment. | ||
| ExchangeRate | Decimal | False |
Exchange rate of currency adjustment. | ||
| GainOrLoss | Decimal | True |
Check the amount if gain or loss. | ||
| Notes | String | False |
Notes of Base cuurrency adjustments. | ||
| AccountIds | String | False |
BankAccounts.AccountId |
Id of the accounts for which base currency adjustments need to be posted. |
Pseudo-Columns
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.
| Name | Type | Description |
| BaseCurrencyAdjustmentsFilter | String |
Filter base currency adjustment list. The allowed values are Date.All, Date.Today, Date.ThisWeek, Date.ThisMonth, Date.ThisQuarter, Date.ThisYear. |