ReleaseUpdateTransformDB50_Basic.updateCompanyInfoPreProcessing 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_Basic |
Method |
updateCompanyInfoPreProcessing |
Description |
Updates the data in the CompanyInfo table. |
Script Type |
Preprocessing 60: Live |
Microsoft Dynamics AX Source |
Microsoft Dynamics AX 4.0 Microsoft Dynamics AX 2009 |
Affected Modules and Tables
Affected Modules |
|---|
Basic |
Affected Tables |
|---|
CompanyInfo |
DirPartyTable |
DirOrganizationBase |
DirOrganizationName |
OMInternalOrganization |
CompanyDefaultLocation |
DirPartyLocation |
LogisticsElectronicAddress |
DirPartyLocation |
DirPartyLocationRole |
LogisticsPostalAddress |
Remarks
This upgrade is required to convert postal address data to the new logistics postal address model for Microsoft Dynamics AX 2012.
Data Migration Section
From Table: CompanyInfo |
To Table: DirPartyTable |
|---|---|
Name |
Name |
Name |
NameAlias |
LanguageId |
LanguageId |
DataAreaId |
DEL_DataAreaId |
From Table: CompanyInfo |
To Table: DirOrganizationBase |
|---|---|
DataAreaId |
Shadow_DataAreaId |
From Table: CompanyInfo |
To Table: DirOrganizationName |
|---|---|
Name |
Name |
From Table: CompanyInfo |
To Table: OmInternalOrganization |
|---|---|
DataAreaId |
Shadow_DataAreaId |
From Table: CompanyInfo |
To Table: LogisticsPostalAddress |
|---|---|
Address |
Address |
CountryRegionId |
CountryRegionId |
State |
State |
County |
County |
ZipCode |
ZipCode |
City |
City |
Street |
Street |
CountryRegionId |
CountryRegionId |
State |
State |
County |
County |
From Table: CompanyInfo |
To Table: LogisticsElectronicAddress |
|---|---|
Phone |
Locator |
PhoneLocal |
LocatorExtension |
TeleFax |
Locator |
Telex |
Locator |
URL |
Locator |
CellularPhone |
Locator |
Locator |
|
Pager |
Locator |
SMS |
Locator |
New Tables or Fields
Table |
Field |
Extended Data Type -or- Base Enum |
|---|---|---|
CompanyInfo |
LogisticsLocationRecId |
|
CompanyInfo |
DirPartyLocationRecId |
|
CompanyInfo |
DirPartyTableRecId |
|
DirOrganizationBase |
||
DirOrganizationName |
||
OMInternalOrganization |
||
LogisticsElectronicAddress |
||
DirPartyTable |
Name |
|
DirPartyTable |
NameAlias |
|
DirPartyTable |
LanguageId |
|
DirPartyTable |
PartyNumber |
|
DirPartyTable |
EntityType |
Deleted Tables or Fields
Table |
Field |
|---|---|
CompanyInfo |
Name |
CompanyInfo |
Address |
CompanyInfo |
Phone |
CompanyInfo |
TeleFax |
CompanyInfo |
CurrencyCode |
CompanyInfo |
ZipCode |
CompanyInfo |
State |
CompanyInfo |
County |
CompanyInfo |
CountryRegionId |
CompanyInfo |
Telex |
CompanyInfo |
URL |
CompanyInfo |
|
CompanyInfo |
CellularPhone |
CompanyInfo |
PhoneLocal |
CompanyInfo |
EuroCurrencyCode |
CompanyInfo |
SecondaryCurrencyCode |
CompanyInfo |
LanguageId |
CompanyInfo |
Street |
CompanyInfo |
City |
CompanyInfo |
Pager |
CompanyInfo |
SMS |
CompanyInfo |
CompanyIdNAF |
CompanyInfo |
PaymInstructionId1 |
CompanyInfo |
PaymInstructionId2 |
CompanyInfo |
PaymInstructionId3 |
CompanyInfo |
PaymInstructionId4 |
DirPartyTable |
GenerationalSuffix |
DirPartyTable |
Salutation |
DirPartyTable |
PersonNameOrder |
DirPartyTable |
Type |
DirPartyTable |
Prefix |
DirPartyTable |
ProfessionalSuffix |
DirPartyTable |
FirstName |
DirPartyTable |
MiddleName |
DirPartyTable |
LastName |
DirPartyTable |
PartyId |