ReleaseUpdateDB60_Bank.updateRCashDimensions_RU 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_Bank

Method

updateRCashDimensions_RU

Description

Transforms data from the SumAccount field to the SumLedgerDimension field in the RCashLedgerAccount table, also transforms the RCashParameters fields.

Affected Modules and Tables

Affected Modules

Bank

Affected Tables

RCashLedgerAccount

RCashParameters

Remarks

This upgrade is required in order to convert account and dimension data to the new accounts and dimension model for Microsoft Dynamics AX 2012.

Data Migration Section

From Table: RCashLedgerAccount

To Table: RCashLedgerAccount

SumLedgerDimension

SumAccount

From Table: RCashParameters

To Table: RCashParameters

PurposeCode

PurposeDimensionAttribute

AnalysisCode

AnalysisDimensionAttribute

DepartmentCode

DepartmentDimensionAttribute

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

RCashLedgerAccount

SumLedgerDimension

LedgerDimensionDefaultAccount

RCashParameters

PurposeDimensionAttribute

RefRecId

RCashParameters

AnalysisDimensionAttribute

RefRecId

RCashParameters

DepartmentDimensionAttribute

RefRecId

Deleted Tables or Fields

Table

Field

RCashLedgerAccount

SumAccount

RCashParameters

PurposeCode

RCashParameters

AnalysisCode

RCashParameters

DepartmentCode