ReleaseUpdateTransformDB50_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 |
ReleaseUpdateTransformDB50_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 2009 |
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 |
|---|---|
TrLoadDateTime_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 |
TrLoadDateTime_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 |