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

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