ReleaseUpdateTransformDB50_CRM.updateExtCodeValueTableDelta Upgrade Script [AX 2012]
Updated: June 27, 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_CRM |
|
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 |
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 is moved to the LogisticsAddressCountryRegion, LogisticsAddressState, LogisticsAddressCounty, and LogisticsAddressZipCode tables that are newly created respectively. The data in the ExtCodeValueTable table can be updated to refer to the records in the LogisticsAddress 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).