ReleaseUpdateTransformDB50_Transptn.vendInvoiceJourPreUpgradeProcess 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	vendInvoiceJourPreUpgradeProcess
Description	Transforms transportation data from the VendInvoiceJour 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
Accounts payable

Affected Tables
VendInvoiceJour
PurchAdditionalProperties_W
TransportationDocument
TransportationVehicle

Remarks

This method inserts records into the TransportationDocument and TransportationVehicle tables from the VendInvoiceJour and PurchAdditionalProperties_W tables. Updates the VendInvoiceJour 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
VendInvoiceJour	TransportationDocument	TransportationDocumentRecId

Deleted Tables or Fields

Table	Field
PurchAdditionalProperties_W