ReleaseUpdateTransformDB40_GAB.updateIntrastatServicePoint_FI 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_GAB
Method	updateIntrastatServicePoint_FI
Description	Updates the postal address in the IntrastatServicePoint_FI table.
Script Type	Preprocessing 60: Live
Microsoft Dynamics AX Source	Microsoft Dynamics AX 4.0

Affected Modules and Tables

Affected Modules
Basic

Affected Tables
IntrastatServicePoint_FI

Remarks

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 IntrastatServicePoint_FI record will be kept as a reference to the LogisticsLocation record.

Data Migration Section

From Table: IntrastatServicePoint_FI	To Table: LogisticsPostalAddress
Address	Address
Country	CountryRegionId
State	State
County	County
ZipCode	ZipCode
City	City
Street	Street

From Table: LogisticsPostalAddress	To Table: Shadow_IntrastatServicePoint_FI
Location	Location

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
IntrastatServicePoint_FI	Location

Deleted Tables or Fields

Table	Field
IntrastatServicePoint_FI	Address
IntrastatServicePoint_FI	Country
IntrastatServicePoint_FI	State
IntrastatServicePoint_FI	County
IntrastatServicePoint_FI	ZipCode
IntrastatServicePoint_FI	City
IntrastatServicePoint_FI	Street