ReleaseUpdateTransformDB50_Transptn.vendInvoiceJourPreUpgradeProcess Upgrade Script [AX 2012]
Updated: November 14, 2011
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 |
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 2009 |
|
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 |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).