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 |