Condividi tramite


ReleaseUpdateTransformDB50_GAB.updateSalesCarrier 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

ReleaseUpdateTransformDB50_GAB

Method

updateSalesCarrier

Description

Updates the location in the SalesCarrier table.

Script Type

Preprocessing 60: Live

Microsoft Dynamics AX Source

Microsoft Dynamics AX 4.0

Microsoft Dynamics AX 2009

Affected Modules and Tables

Affected Modules

Accounts receivable

Affected Tables

SalesCarrier

Shadow_SalesCarrier

LogisticsPostalAddress

Remarks

This upgrade is required to uptake to the new logistics postal address model for Microsoft Dynamics AX 2012. The location in the SalesCarrier will be kept as a reference to the LogisticsLocation record.

Data Migration Section

From Table: LogisticsPostalAddress

To Table: Shadow_SalesCarrier

Location

Location

From Table: SalesCarrier

To Table: Shadow_SalesCarrier

RecId

RefRecId

recVersion

RecVersionId

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

SalesCarrier

Location

LogisticsLocationRecId

Deleted Tables or Fields

Table

Field

SalesCarrier

City

SalesCarrier

State

SalesCarrier

County

SalesCarrier

CountryRegionId

SalesCarrier

ZipCode

SalesCarrier

Address

SalesCarrier

Street