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 |