ReleaseUpdateTransformDB50_Transptn.projProposalJourPreUpgradeProcess 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_Transptn

Method

projProposalJourPreUpgradeProcess

Description

Transforms transportation data from the ProjProposalJour and PurchAdditionalProperties_W tables to the TransportationDocument and TransportationVehicle tables.

Script Type

Preprocessing 60: Live

Ax Version

Microsoft Dynamics AX 2009

Affected Modules and Tables

Affected Modules

Project

Affected Tables

ProjProposalJour

PurchAdditionalProperties_W

TransportationDocument

TransportationVehicle

Remarks

Inserts records into the TransportationDocument and TransportationVehicle tables from the ProjProposalJour and PurchAdditionalProperties_W tables. Updates the ProjProposalJour table to reference the inserted TransportationDocument record.

Data Migration Section

From Table: PurchAdditionalProperties_W

To Table: TransportationDocument

TrTransportationProperties_LT

DoPrintTransportationDocument

CarrierCode

CarrierCode

CarrierType

CarrierType

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

From Table: PurchAdditionalProperties_W

To Table: TransportationVehicle

Driver

Driver

DriverName

DriverName

TruckModel

Model

TruckPlateNum

PlateNumber

TruckTrailerNum

TrailerNumber

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

TransportationDocument

TransportationVehicle

ProjProposalJour

TransportationDocument

TransportationDocumentRecId

Deleted Tables or Fields

Table

Field

PurchAdditionalProperties_W