This documentation is archived and is not being maintained.
ReleaseUpdateTransformDB50_CRM.updateProjInvoiceTableDelta Upgrade Script [AX 2012]
Updated: June 13, 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
updateProjInvoiceTableDelta
Description
Updates the delivery postal address in the ProjInvoiceTable table.
Script Type
Preprocessing 60: Live
Microsoft Dynamics AX Source
Microsoft Dynamics AX 4.0
Microsoft Dynamics AX 2009
Affected Tables
ProjInvoiceTable
This upgrade is required in order to convert postal address data to the new logistics postal address model for Microsoft Dynamics AX 2012. The delivery postal address for the ProjInvoiceTable table will be kept as a reference to the LogisticsPostalAddress record.
From Table: ProjInvoiceTable
To Table: LogisticsPostalAddress
Addr
Address
CountryRegionId
CountryRegionId
State
State
CountyId
County
ZipCodeId
ZipCode
City
City
Street
Street
From Table: LogisticsPostalAddress
To Table: Shadow_ProjInvoiceTable_GAB
Location
InvoiceLocation
Table
Field
Extended Data Type
-or- Base Enum
ProjInvoiceTable
InvoiceLocation
LogisticsLocationRecId
Table
Field
ProjInvoiceTable
Addr
ProjInvoiceTable
CountryRegionId
ProjInvoiceTable
State
ProjInvoiceTable
County
ProjInvoiceTable
ZipCode
ProjInvoiceTable
City
ProjInvoiceTable
Street
Announcements: To see known issues and recent fixes, use
Issue search in
Microsoft Dynamics Lifecycle Services (LCS).