ReleaseUpdateTransformDB40_Transptn.salesTablePreUpgradeProcess 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_Transptn

Method

salesTablePreUpgradeProcess

Description

Transforms transportation data from the SalesTable table to the TransportationDocument and TransportationVehicle tables.

Script Type

Preprocessing 60: Live

Ax Version

Microsoft Dynamics AX 4.0

Affected Modules and Tables

Affected Modules

Accounts receivable

Affected Tables

SalesTable

TransportationDocument

TransportationVehicle

Remarks

This method inserts records into the TransportationDocument and TransportationVehicle tables from the SalesTable table. It also updates the SalesTable table to reference the inserted TransportationDocument record.

Data Migration Section

From Table: SalesTable

To Table: TransportationDocument

TrTransportationProperties_LT

DoPrintTransportationDocument

CarrierType_W

CarrierType

CarrierCode_W

CarrierCode

TrResponsible_LT

IssuedBy

TrPackage_LT

PackageDescription

TrDangerDegree_LT

PackageDangerDegree

TrLoadDate_LT

LoadedDateTime

TrLoadTime_LT

LoadedDateTime

TrLoadAddrName_LT

LoadedAddressName

TrLoadAddress_LT

LoadedPostalAddress

TrLoadAddrCountryRegionId_LT

LoadedPostalAddress

TrLoadAddrCounty_LT

LoadedPostalAddress

TrLoadAddrZipCode_LT

LoadedPostalAddress

TrLoadAddrState_LT

LoadedPostalAddress

EconomicActivity_LV

EconomicActivityType

From Table: SalesTable

To Table: TransportationVehicle

Driver_W

Driver

DriverName_W

DriverName

TruckModel_W

Model

TruckPlateNum_W

PlateNumber

TruckTrailerNum_LT

TrailerNumber

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

TransportationDocument

TransportationVehicle

SalesTable

TransportationDocument

TransportationDocumentRecId

Deleted Tables or Fields

Table

Field

SalesTable

TrTransportationProperties_LT

SalesTable

CarrierType_W

SalesTable

CarrierCode_W

SalesTable

Driver_W

SalesTable

DriverName_W

SalesTable

TruckModel_W

SalesTable

TruckPlateNum_W

SalesTable

TruckTrailerNum_LT

SalesTable

TrResponsible_LT

SalesTable

TrPackage_LT

SalesTable

TrDangerDegree_LT

SalesTable

TrLoadDate_LT

SalesTable

TrLoadTime_LT

SalesTable

TrLoadAddrName_LT

SalesTable

TrLoadAddress_LT

SalesTable

TrLoadAddrCountryRegionId_LT

SalesTable

TrLoadAddrCounty_LT

SalesTable

TrLoadAddrZipCode_LT

SalesTable

TrLoadAddrState_LT

SalesTable

EconomicActivity_LV