BizTalk Adapter for NetSuite

Build 20.0.7606

ConsolidatedExchangeRate

Gets the consolidated exchange rate, by default for each month of the actual year . You can also filter the result by PeriodName (ex. WHERE PeriodName = 'Q2 2008') or by Period_InternalId (ex. WHERE Period_InternalId = '166') .

Columns

Name Type Description
Period_InternalId String
FromSubsidiary_InternalId String
ToSubsidiary_InternalId String
CurrentRate Double Current actual exchange rate
AverageRate Double Average actual exchange rate
HistoricalRate Double Historical actual exchange rate

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
Parent_InternalId String
PeriodName String

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