MuleSoft Connector for Zoho Books

Build 20.0.7654

BaseCurrencyAdjustments

Retrieves list of base currency adjustment.

Table Specific Information

Select

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.
For example:
    SELECT * FROM BaseCurrencyAdjustments WHERE BaseCurrencyAdjustmentsFilter = 'Date.All'

Columns

Name Type References SupportedOperators Description
BaseCurrencyAdjustmentId [KEY] String Id of a base currency adjustment.
CurrencyCode String Currency code of the customer's currency.
CurrencyId String

Currencies.CurrencyId

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-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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654