ReleaseUpdateTransformDB50_Ledger.exchangeRatePreProcessing Upgrade Script

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Class

ReleaseUpdateTransformDB50_Ledger

Method

exchangeRatePreProcessing

Description

Transforms the ExchRates table to the ExchangeRateType, ExchangeRateCurrencyPair, and ExchangeRate tables.

Script Type

Preprocessing 60: Live

Microsoft Dynamics AX Source

Microsoft Dynamics AX 4.0

Microsoft Dynamics AX 2009

Affected Modules and Tables

Affected Modules

General ledger

Affected Tables

ExchRates

Data Migration Section

From Table: ExchRates

To Table: ExchangeRateCurrencyPair

CurrencyCode

FromCurrencyCode

ToCurrencyCode

ExchangeRateType

From Table: LedgerParameters

To Table: ExchangeRateCurrencyPair

ExpressExchRate

ExchangeRateDisplayFactor

From Table: ExchRates

To Table: ExchangeRate

ExchRate

ExchangeRate

FromDate

ValidFrom

ValidTo

ExchangeRateCurrencyPair

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

ExchangeRateType

ExchangeRateCurrencyPair

ExchangeRate

Deleted Tables or Fields

Table

Field

ExchRates