ReleaseUpdateDB60_Ledger.updateCurrency_W 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

ReleaseUpdateDB60_Ledger

Method

updateCurrency_W

Description

Populates the new Currency_W table with the information from the fields in the Currency table that are being deleted.

Affected Modules and Tables

Affected Modules

General ledger

Affected Tables

Currency_W

Remarks

If it is necessary this upgrade converts account and dimension data to the new accounts and dimension model for Microsoft Dynamics AX 2012.

Data Migration Section

From Table: Currency

To Table: Currency

CurrencyCode

CurrencyCode

del_TaxAmountDiffLedgerAccount_RU

TaxAmountDiffLedgerDimension_RU

del_TaxAmountDiffLedgerAccountLoss_RU

TaxAmountDiffLossLedgerDimension_RU

del_TaxAmountDiffLedgerAccountProfit_RU

TaxAmountDiffProfitLedgerDimension_RU

del_LedgerAccountNonrealProfitCust_W

UnrealizedProfitCustLedgerDimension_W

del_LedgerAccountNonrealLossCust_W

UnrealizedLossCustLedgerDimension_W

del_LedgerAccountProfitCust_W

RealizedProfitCustLedgerDimension_W

del_LedgerAccountLossCust_W

RealizedLossCustLedgerDimension_W

del_LedgerAccountNonrealProfitVend_W

UnrealizedProfitVendLedgerDimension_W

del_LedgerAccountNonrealLossVend_W

UnrealizedLossVendLedgerDimension_W

del_LedgerAccountLossVend_W

RealizedLossVendLedgerDimension_W

del_LedgerAccountProfitVend_W

RealizedProfitVendLedgerDimension_W

del_LedgerAccountProfitTaxVend_W

RealizedProfitTaxVendLedgerDimension_W

del_LedgerAccountLossTaxVend_W

RealizedLossTaxVendLedgerDimension_W

del_LedgerAccountLossTaxCust_W

RealizedLossTaxCustLedgerDimension_W

del_LedgerAccountProfitTaxCust_W

RealizedProfitTaxCustLedgerDimension_W

del_LedgerAccountNonrealLossTaxCust_W

UnrealizedLossTaxCustLedgerDimension_W

del_LedgerAccountNonrealProfitTaxCust_W

UnrealizedProfitTaxCustLedgerDimension_W

del_LedgerAccountFinLoss_W

FinLossLedgerDimension_W

del_LedgerAccountFinProfit_W

FinProfitLedgerDimension_W

del_TaxAmountDifference_RU

TaxAmountDifference_RU

del_ExchRateNonrealProfitTaxCust_W

ExchRateNonrealProfitTaxCust_W

del_ExchRateNonrealLossTaxCust_W

ExchRateNonrealLossTaxCust_W

del_ExchRateProfitTaxVend_W

ExchRateProfitTaxVend_W

del_ExchRateLossTaxVend_W

ExchRateLossTaxVend_W

del_CustPostingMode_W

CustPostingMode_W

del_CustPostingModeTax_W

CustPostingModeTax_W

del_VendPostingMode_W

VendPostingMode_W

del_VendPostingModeTax_W

VendPostingModeTax_W

del_ExchRateNeg_RU

ExchRateNeg_RU

del_ExchRatePos_RU

ExchRatePos_RU

del_rTax25ProfitIdProfitVend

del_rTax25ProfitIdProfitVend

del_rTax25ProfitIdProfitCust

del_rTax25ProfitIdProfitCust

del_rTax25ProfitIdLossVend

del_rTax25ProfitIdLossVend

del_rTax25ProfitIdLossCust

del_rTax25ProfitIdLossCust

del_rTax25ProfitIdProfit

del_rTax25ProfitIdProfit

del_rTax25ProfitIdLoss

del_rTax25ProfitIdLoss

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

Currency_W