Cmdlets for Zoho Books

Build 24.0.8963

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963