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