Condividi tramite


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

custInvoiceTableDeltaPreUpgradeProcess

Description

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

Script Type

Preprocessing 60: Delta

Ax Version

Microsoft Dynamics AX 2009

Affected Modules and Tables

Affected Modules

Accounts receivable

Affected Tables

CustInvoiceTable

TransportationDocument

TransportationVehicle

Remarks

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

Data Migration Section

From Table: CustInvoiceTable

To Table: TransportationDocument

TrTransportationProperties_LT

DoPrintTransportationDocument

TrLoadDateTime_LT

LoadedDateTime

TrResponsible_LT

IssuedBy

CarrierType_W

CarrierType

CarrierCode_W

CarrierCode

TrPackage_LT

PackageDescription

TrDangerDegree_LT

PackageDangerDegree

TrLoadAddrName_LT

LoadedAddressName

TrLoadAddress_LT

LoadedPostalAddress

TrLoadAddrCountry_LT

LoadedPostalAddress

TrLoadAddrState_LT

LoadedPostalAddress

TrLoadAddrCountryRegionId_LT

LoadedPostalAddress

TrLoadAddrZipCode_LT

LoadedPostalAddress

From Table: CustInvoiceTable

To Table: TransportationVehicle

Driver_W

Driver

DriverName_W

DriverName

TruckPlateNum_W

PlateNumber

TruckTrailerNum_W

TrailerNumber

TruckModel_W

Model

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

TransportationDocument

TransportationVehicle

CustInvoiceTable

TransportationDocument

TransportationDocumentRecId

Deleted Tables or Fields

Table

Field

CustInvoiceTable

TrTransportationProperties_LT

CustInvoiceTable

TrLoadDateTime_LT

CustInvoiceTable

TrResponsible_LT

CustInvoiceTable

CarrierType_W

CustInvoiceTable

CarrierCode_W

CustInvoiceTable

TrPackage_LT

CustInvoiceTable

TrDangerDegree_LT

CustInvoiceTable

TrLoadAddrName_LT

CustInvoiceTable

TrLoadAddress_LT

CustInvoiceTable

TrLoadAddrCountry_LT

CustInvoiceTable

TrLoadAddrState_LT

CustInvoiceTable

TrLoadAddrCountryRegionId_LT

CustInvoiceTable

TrLoadAddrZipCode_LT

CustInvoiceTable

Driver_W

CustInvoiceTable

DriverName_W

CustInvoiceTable

TruckPlateNum_W

CustInvoiceTable

TruckTrailerNum_W

CustInvoiceTable

TruckModel_W