Compartilhar via


ReleaseUpdateTransformDB50_Transptn.purchTableDeltaPreUpgradeProcess 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

purchTableDeltaPreUpgradeProcess

Description

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

Script Type

Preprocessing 60: Delta

Ax Version

Microsoft Dynamics AX 2009

Affected Modules and Tables

Affected Modules

Accounts payable

Affected Tables

PurchTable

PurchAdditionalProperties_W

TransportationDocument

TransportationVehicle

Remarks

Inserts records into the TransportationDocument and TransportationVehicle tables from the PurchTable and PurchAdditionalProperties_W tables, updates existing records in the TransportationDocument and TransportationVehicle tables, and deletes records from the TransportationDocument and TransportationVehicle tables that no longer have an associated record from the PurchTable or PurchAdditionalProperties_W tables. Updates the PurchTable 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

PurchTable

TransportationDocument

TransportationDocumentRecId

Deleted Tables or Fields

Table

Field

PurchAdditionalProperties_W