ReleaseUpdateTransformDB50_GAB.updateCompanyInfoDelta 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_GAB
Method	updateCompanyInfoDelta
Description	Updates the data in the CompanyInfo table.
Script Type	Preprocessing 60: Delta
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
Email	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	Email
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