ReleaseUpdateTransformDB50_Transptn.custPackSlipJourPreUpgradeProcess 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 |
custPackSlipJourPreUpgradeProcess |
Description |
Transforms transportation data from the CustPackingSlipJour table to the TransportationDocument and TransportationVehicle tables. |
Script Type |
Preprocessing 60: Live |
Ax Version |
Microsoft Dynamics AX 2009 |
Affected Modules and Tables
Affected Modules |
|---|
Accounts receivable |
Affected Tables |
|---|
CustPackingSlipJour |
TransportationDocument |
TransportationVehicle |
Remarks
Inserts records into the TransportationDocument and TransportationVehicle tables from the CustPackingSlipJour table. 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 |