SSIS Components for Zoho Books

Build 22.0.8509

AccountDetailsBaseCurrencyAdjustment

Details of 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:

  • 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 本製品.

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 Currency Code
AdjustmentDate Date = Adjustment Date
CurrencyId String

Currencies.CurrencyId

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8509