AccountDetailsBaseCurrencyAdjustmentAccounts
Account Details of Base Currency Adjustment
Table Specific Information
Select
The component 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 component.
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 | ID of the Bank/Credit Card account | |
| AccountName | String | Account Name | ||
| AdjustedBalance | Decimal | Adjusted Balance | ||
| BCYBalance | Decimal | Balance in Base Currency | ||
| FCYBalance | Integer | Balance in Foreign Currency | ||
| GAINORLOSS | Integer | Gain Or Loss | ||
| GLSpecificType | Integer | GL Specific Type | ||
| AdjustmentDate | Date | = | Adjustment Date | |
| CurrencyId | String |
Currencies.CurrencyId | = | Currency Id |
| ExchangeRate | Decimal | = | Exchange Rate | |
| Notes | String | = | Notes |