This documentation is archived and is not being maintained.
ReleaseUpdateTransformDB40_Basic.updateProjTable 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
ReleaseUpdateTransformDB40_Basic
Method
updateProjTable
Description
Updates the postal address in the ProjTable table.
Script Type
Preprocessing 60: Live
Microsoft Dynamics AX Source
Microsoft Dynamics AX 4.0
Affected Tables
ProjTable
This upgrade is required in order to convert postal address data to the new logistics postal address model for Microsoft Dynamics AX 2012. The location for the ProjTable table will be kept as a reference to the LogisticsLocation record.
From Table: ProjTable
To Table: LogisticsPostalAddress
DlvAddr
Address
DlvCountryRegionId
CountryRegionId
DlvState
State
DlvCounty
County
DlvZipCode
ZipCode
DeliveryCity
City
DeliveryStreet
Street
From Table: LogisticsPostalAddress
To Table: Shadow_ProjTable_GAB
Location
DeliveryLocation
Table
Field
Extended Data Type
-or- Base Enum
ProjTable
DeliveryLocation
Table
Field
ProjTable
DlvAddr
ProjTable
DlvCountryRegionid
ProjTable
DlvState
ProjTable
DlvCounty
ProjTable
DlvZipCode
ProjTable
DeliveryCity
ProjTable
DeliveryStreet
Announcements: To see known issues and recent fixes, use
Issue search in
Microsoft Dynamics Lifecycle Services (LCS).