Tableau Connector for Microsoft Dynamics GP

Build 24.0.9062

MulticurrencySetup

Return a list of: MulticurrencySetup

Columns

Name Type Description
ExtensionsExtensionAggregate String
AllowModifyRates Bool
AllowNewRates Bool
AllowOverrideExchangeRates Bool
AllowOverrideRateVariance Bool
AllowOverrideReportingRate Bool
AverageExchangeRateCalculationMethodDisplay String
DefaultFinancialRateTypeId String
DefaultPurchasingRateTypeId String
DefaultSalesRateTypeId String
KeepGeneralLedgerAccountHistory Bool
KeyCurrencyKeyISOCode [KEY] String
LastFinancialRevaluationDate Datetime
LastPurchasingRevaluationDate Datetime
LastSalesRevaluationDate Datetime
LastSummaryRemovalDate Datetime
LastTransactionRemovalDate Datetime
ReportingCurrencyExchangeRate Decimal
ReportingCurrencyKeyISOCode String
ReportingCurrencyRateCalculationMethod String

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

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