ReleaseUpdateTransformDB40_Transptn.custInvoiceTablePreUpgradeProcess 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 |
ReleaseUpdateTransformDB40_Transptn |
|
Method |
custInvoiceTablePreUpgradeProcess |
|
Description |
Transforms transportation data from the CustInvoiceTable table to the TransportationDocument and TransportationVehicle tables. |
|
Script Type |
Preprocessing 60: Live |
|
Ax Version |
Microsoft Dynamics AX 4.0 |
|
From Table: CustInvoiceTable |
To Table: TransportationDocument |
|---|---|
|
TrTransportationProperties_LT |
DoPrintTransportationDocument |
|
TrLoadDate_LT |
LoadedDateTime |
|
TrLoadTime_LT |
LoadedDateTime |
|
TrResponsible_LT |
IssuedBy |
|
CarrierType_W |
CarrierType |
|
CarrierCode_W |
CarrierCode |
|
TrPackage_LT |
PackageDescription |
|
TrDangerDegree_LT |
PackageDangerDegree |
|
TrLoadAddrName_LT |
LoadedAddressName |
|
TrLoadAddress_LT |
LoadedPostalAddress |
|
TrLoadAddrCountry_LT |
LoadedPostalAddress |
|
TrLoadAddrState_LT |
LoadedPostalAddress |
|
TrLoadAddrCountryRegionId_LT |
LoadedPostalAddress |
|
TrLoadAddrZipCode_LT |
LoadedPostalAddress |
|
From Table: CustInvoiceTable |
To Table: TransportationVehicle |
|---|---|
|
Driver_W |
Driver |
|
DriverName_W |
DriverName |
|
TruckPlateNum_W |
PlateNumber |
|
TruckTrailerNum_W |
TrailerNumber |
|
TruckModel_W |
Model |
|
Table |
Field |
|---|---|
|
CustInvoiceTable |
TrTransportationProperties_LT |
|
CustInvoiceTable |
TrLoadDate_LT |
|
CustInvoiceTable |
TrLoadTime_LT |
|
CustInvoiceTable |
TrResponsible_LT |
|
CustInvoiceTable |
CarrierType_W |
|
CustInvoiceTable |
CarrierCode_W |
|
CustInvoiceTable |
TrPackage_LT |
|
CustInvoiceTable |
TrDangerDegree_LT |
|
CustInvoiceTable |
TrLoadAddrName_LT |
|
CustInvoiceTable |
TrLoadAddress_LT |
|
CustInvoiceTable |
TrLoadAddrCountry_LT |
|
CustInvoiceTable |
TrLoadAddrState_LT |
|
CustInvoiceTable |
TrLoadAddrCountryRegionId_LT |
|
CustInvoiceTable |
TrLoadAddrZipCode_LT |
|
CustInvoiceTable |
Driver_W |
|
CustInvoiceTable |
DriverName_W |
|
CustInvoiceTable |
TruckPlateNum_W |
|
CustInvoiceTable |
TruckTrailerNum_W |
|
CustInvoiceTable |
TruckModel_W |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).