BaseCurrencyAdjustments
To list, add, update and delete base currency adjustment.
Table Specific Information
Select
The 本製品 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 本製品.
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. 使用できる値は次のとおりです。Date.All, Date.Today, Date.ThisWeek, Date.ThisMonth, Date.ThisQuarter, Date.ThisYear |