ReleaseUpdateTransformDB40_Transptn.vendInvoiceJourPreUpgradeProcess 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 |
vendInvoiceJourPreUpgradeProcess |
Description |
Transforms transportation data from the VendInvoiceJour and PurchAdditionalProperties_W tables to the TransportationDocument and TransportationVehicle tables. |
Script Type |
Preprocessing 60: Live |
Ax Version |
Microsoft Dynamics AX 4.0 |
Affected Modules and Tables
Affected Modules |
|---|
Accounts payable |
Affected Tables |
|---|
VendInvoiceJour |
PurchAdditionalProperties_W |
TransportationDocument |
TransportationVehicle |
Remarks
This method inserts records into the TransportationDocument and TransportationVehicle tables from the VendInvoiceJour and PurchAdditionalProperties_W tables. It also updates the VendInvoiceJour 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 |
||
VendInvoiceJour |
TransportationDocument |
TransportationDocumentRecId |
Deleted Tables or Fields
Table |
Field |
|---|---|
PurchAdditionalProperties_W |