ReleaseUpdateTransformDB50_Transptn.projProposalJourPreUpgradeProcess 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 |
projProposalJourPreUpgradeProcess |
Description |
Transforms transportation data from the ProjProposalJour and PurchAdditionalProperties_W tables to the TransportationDocument and TransportationVehicle tables. |
Script Type |
Preprocessing 60: Live |
Ax Version |
Microsoft Dynamics AX 2009 |
Affected Modules and Tables
Affected Modules |
---|
Project |
Affected Tables |
---|
ProjProposalJour |
PurchAdditionalProperties_W |
TransportationDocument |
TransportationVehicle |
Remarks
Inserts records into the TransportationDocument and TransportationVehicle tables from the ProjProposalJour and PurchAdditionalProperties_W tables. Updates the ProjProposalJour table to reference the inserted TransportationDocument record.
Data Migration Section
From Table: PurchAdditionalProperties_W |
To Table: TransportationDocument |
---|---|
TrTransportationProperties_LT |
DoPrintTransportationDocument |
CarrierCode |
CarrierCode |
CarrierType |
CarrierType |
TrResponsible_LT |
IssuedBy |
TrPackage_LT |
PackageDescription |
TrDangerDegree_LT |
PackageDangerDegree |
TrLoadDate_LT |
LoadedDateTime |
TrLoadTime_LT |
LoadedDateTime |
TrLoadAddrName_LT |
LoadedAddressName |
TrLoadAddress_LT |
LoadedPostalAddress |
TrLoadAddrCountryRegionId_LT |
LoadedPostalAddress |
TrLoadAddrCounty_LT |
LoadedPostalAddress |
TrLoadAddrZipCode_LT |
LoadedPostalAddress |
TrLoadAddrState_LT |
LoadedPostalAddress |
From Table: PurchAdditionalProperties_W |
To Table: TransportationVehicle |
---|---|
Driver |
Driver |
DriverName |
DriverName |
TruckModel |
Model |
TruckPlateNum |
PlateNumber |
TruckTrailerNum |
TrailerNumber |
New Tables or Fields
Table |
Field |
Extended Data Type -or- Base Enum |
---|---|---|
TransportationDocument |
||
TransportationVehicle |
||
ProjProposalJour |
TransportationDocument |
TransportationDocumentRecId |
Deleted Tables or Fields
Table |
Field |
---|---|
PurchAdditionalProperties_W |