Condividi tramite


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