ReleaseUpdateTransformDB40_Basic.updateCountryRegionParamPreProcessing 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_Basic |
Method |
updateCountryRegionParamPreProcessing |
Description |
Transforms data in the AddressCountryRegion table to the IntrastatCountryRegionParameters, TaxCountryRegionParameters, LogisticsCountryRegionPaymentIdType_NO, and LogisticsAddressCountryRegion tables |
Script Type |
Preprocessing 60: Live |
Microsoft Dynamics AX Source |
Microsoft Dynamics AX 4.0 |
Affected Modules and Tables
Affected Modules |
|---|
CRM |
Affected Tables |
|---|
AddressCountryRegion |
Remarks
This upgrade is required in order to transform the data in AddressCountryRegiontable into the new global address book model for Microsoft Dynamics AX 2012.
Data Migration Section
From Table: AddressCountryRegion |
To Table: IntrastatCountryRegionParameters |
|---|---|
CountryRegionId |
CountryRegionId |
IntrastateCode |
IntrastateCode |
Type |
CountryRegionType |
CurrrencyCode |
CurrencyCode |
From Table: AddressCountryRegion |
To Table: TaxCountryRegionParameters |
|---|---|
CountryRegionId |
CountryRegionId |
TaxCode |
SalesTaxCode |
TaxVatNumFormatCheck |
CheckTaxExemptNumber |
New Tables or Fields
Table |
Field |
Extended Data Type -or- Base Enum |
|---|---|---|
IntrastatCountryRegionParameters |
||
TaxCountryRegionParameters |
Deleted Tables or Fields
Table |
Field |
|---|---|
AddressCountryRegion |
* |