ReleaseUpdateDB60_Prod.updateWrkCtrTable 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_Prod

Method

updateWrkCtrTable

Description

Transforms data from the AccountNumber and Dimension fields to the LedgerDimension and DefaultDimension fields, respectively, in the WrkCtrTable table.

Affected Modules and Tables

Affected Modules

Production

Affected Tables

WrkCtrTable

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: WrkCtrTable

To Table: WrkCtrTable

AccountWIPIssue

WIPIssueLedgerDimension

AccountWIPValuation

WIPValuationLedgerDimension

AccountWrkCtrIssueOffset

ResourceIssueOffsetLedgerDimension

AccountWrkCtrIssue

ResourceIssueLedgerDimension

Dimension

DefaultDimension

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

WrkCtrTable

WIPIssueLedgerDimension

LedgerDimensionAccount

WrkCtrTable

WIPValuationLedgerDimension

LedgerDimensionAccount

WrkCtrTable

ResourceIssueOffsetLedgerDimension

LedgerDimensionAccount

WrkCtrTable

ResourceIssueLedgerDimension

LedgerDimensionAccount

WrkCtrTable

DefaultDimension

DimensionDefault

Deleted Tables or Fields

Table

Field

WrkCtrTable

AccountWIPIssue

WrkCtrTable

AccountWIPValuation

WrkCtrTable

AccountWrkCtrIssueOffset

WrkCtrTable

AccountWrkCtrIssue

WrkCtrTable

Dimension