SSIS Components for Zoho Books

Build 24.0.9060

AccountDetailsBaseCurrencyAdjustment

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

The rest of the filter is executed client-side in the component.

For example:

    SELECT * FROM AccountDetailsBaseCurrencyAdjustment WHERE AdjustmentDate = '2023-03-16' AND CurrencyId = 3255827000000000097 AND ExchangeRate = '80.6719' AND Notes = 'adjustment'
	

Columns

Name Type References SupportedOperators Description
Accounts String Accounts.
CurrencyCode String The Currency Code.
AdjustmentDate Date = The Adjustment Date.
CurrencyId String

Currencies.CurrencyId

= The Currency Id of the customer's currency.
ExchangeRate Decimal = The Exchange rate of the currency.
Notes String = Notes for base currency adjustment.

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