ReleaseUpdateTransformDB40_Basic.updateExtCodeValueTableDelta 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 |
ReleaseUpdateTransformDB40_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 |
Affected Modules and Tables
Affected Modules |
|---|
Accounts receivable |
Affected Tables |
|---|
ExtCodeValueTable |
Remarks
This upgrade is required in order to convert the 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 newly-created LogisticsAddressCountryRegion, LogisticsAddressState, LogisticsAddressCounty and LogisticsAddressZipCode tables, respectively.
The data in the ExtCodeValueTable is to be updated to refer to the records in the LogisticsAddressXXX tables.
Data Migration Section
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 |