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