BizTalk Adapter for NetSuite

Build 20.0.7606


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


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