Compartir a través de


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

custInvoiceJourDeltaPreUpgradeProcess

Description

Transforms transportation data from the CustInvoiceJour 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

CustInvoiceJour

TransportationDocument

TransportationVehicle

Remarks

Inserts records into the TransportationDocument and TransportationVehicle tables from the CustInvoiceJour 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 CustInvoiceJour table. Updates the CustInvoiceJour table to reference the inserted TransportationDocument record.

Data Migration Section

From Table: CustInvoiceJour

To Table: TransportationDocument

TrTransportationProperties_LT

DoPrintTransportationDocument

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

EconomicActivity_LV

EconomicActivityType

From Table: CustInvoiceJour

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

CustInvoiceJour

TransportationDocument

TransportationDocumentRecId

Deleted Tables or Fields

Table

Field

CustInvoiceJour

TrTransportationProperties_LT

CustInvoiceJour

TrLoadDate_LT

CustInvoiceJour

TrLoadTime_LT

CustInvoiceJour

TrResponsible_LT

CustInvoiceJour

TrCarrierType_LT

CustInvoiceJour

TrCarrierCode_LT

CustInvoiceJour

TrPackage_LT

CustInvoiceJour

TrDangerDegree_LT

CustInvoiceJour

TrLoadAddrName_LT

CustInvoiceJour

TrLoadAddress_LT

CustInvoiceJour

TrLoadAddrCountry_LT

CustInvoiceJour

TrLoadAddrState_LT

CustInvoiceJour

EconomicActivity_LV

CustInvoiceJour

DriverName

CustInvoiceJour

PlateNumber

CustInvoiceJour

TrailerNumber

CustInvoiceJour

Model