Compartilhar via


ReleaseUpdateTransformDB40_Transptn.custPackSlipJouDeltaPreUpgradeProcess 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

custPackSlipJouDeltaPreUpgradeProcess

Description

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

Script Type

Preprocessing 60: Delta

Ax Version

Microsoft Dynamics AX 4.0

Affected Modules and Tables

Affected Modules

Accounts receivable

Affected Tables

CustPackingSlipJour

TransportationDocument

TransportationVehicle

Remarks

This method inserts records into the TransportationDocument and TransportationVehicle tables from the CustPackingSlipJour table, 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 CustPackingSlipJour table. It also updates the CustPackingSlipJour table to reference the inserted TransportationDocument record.

Data Migration Section

From Table: CustPackingSlipJour

To Table: TransportationDocument

TrLoadDate_LT

LoadedDateTime

TrLoadTime_LT

LoadedDateTime

TrResponsible_LT

IssuedBy

TrCarrierType_LT

CarrierType

TrCarrierCode_LT

CarrierCode

TrPackage_LT

PackageDescription

TrDangerDegree_LT

PackageDangerDegree

TrLoadAddrName_LT

LoadedAddressName

TrLoadAddress_LT

LoadedPostalAddress

TrLoadAddrCountry_LT

LoadedPostalAddress

TrLoadAddrState_LT

LoadedPostalAddress

From Table: CustPackingSlipJour

To Table: TransportationVehicle

TrDriverName_LT

DriverName

TrTruckPlateNr_LT

PlateNumber

TruckTrailerNum_LT

TrailerNumber

TruckModel_LT

Model

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

TransportationDocument

TransportationVehicle

CustPackingSlipJour

TransportationDocument

TransportationDocumentRecId

Deleted Tables or Fields

Table

Field

CustPackingSlipJour

TrLoadDate_LT

CustPackingSlipJour

TrLoadTime_LT

CustPackingSlipJour

TrResponsible_LT

CustPackingSlipJour

TrCarrierType_LT

CustPackingSlipJour

TrCarrierCode_LT

CustPackingSlipJour

TrPackage_LT

CustPackingSlipJour

TrDangerDegree_LT

CustPackingSlipJour

TrLoadAddrName_LT

CustPackingSlipJour

TrLoadAddress_LT

CustPackingSlipJour

TrLoadAddrCountry_LT

CustPackingSlipJour

TrLoadAddrState_LT

CustPackingSlipJour

ContactPersonId_LT

CustPackingSlipJour

TrDriverName_LT

CustPackingSlipJour

TrTruckPlateNr_LT

CustPackingSlipJour

TruckTrailerNum_LT

CustPackingSlipJour

TruckModel_LT

Name Changes for Tables or Fields

Old Table Name: CustPackingSlipJour

New Table Name: CustPackingSlipJour

Old Field Name:

New Field Name:

ContactPersonId_LT

ContactPersonId