ReleaseUpdateTransformDB50_Basic.updateExtCodeValueTableDelta Upgrade Script [AX 2012]

Updated: June 10, 2011

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Class

ReleaseUpdateTransformDB50_Basic

Method

updateExtCodeValueTableDelta

Description

Updates the references in the ExtCodeValueTable table to the logistics address codes.

Script Type

Preprocessing 60: Delta

Microsoft Dynamics AX Source

Microsoft Dynamics AX 4.0

Microsoft Dynamics AX 2009

Affected Modules

Accounts receivable

Affected Tables

ExtCodeValueTable

This upgrade is required in order to convert postal address codes to the new logistics postal address model for Microsoft Dynamics AX 2012. The AddressCountryRegion, AddressState, AddressCounty, and AddressZipCode tables are deleted in Microsoft Dynamics AX 2012. The data from these tables are moved to the LogisticsAddressCountryRegion, LogisticsAddressState, LogisticsAddressCounty, and LogisticsAddressZipCode tables. The data in the ExtCodeValueTable table can be updated to refer to the records in the LogisticsAddressXXX tables.

From Table: LogisticsAddressCountryRegion

To Table: Shadow_ExtCodeValueTable

TableId

ExtCodeRelationTableId

RecId

ExtCodeRelationRecId

From Table: LogisticsAddressState

To Table: Shadow_ExtCodeValueTable

TableId

ExtCodeRelationTableId

RecId

ExtCodeRelationRecId

From Table: LogisticsAddressCounty

To Table: Shadow_ExtCodeValueTable

TableId

ExtCodeRelationTableId

RecId

ExtCodeRelationRecId

From Table: LogisticsAddressZipCode

To Table: Shadow_ExtCodeValueTable

TableId

ExtCodeRelationTableId

RecId

ExtCodeRelationRecId


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: