ReleaseUpdateDB60_HRM.updateHRMMedia 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	ReleaseUpdateDB60_HRM
Method	updateHRMMedia
Description	Updates the Location field of the HRMMedia table.

Affected Modules and Tables

Affected Modules
Human Resources

Affected Tables
LogisticsAddressZipCode
LogisticsAddresssCity
HRMMedia
LogisticsLocation
LogisticsPostalAddress

Remarks

Creates a new record in the LogisticsLocation table and the LogisticsPostalAddress table based on address information in the HRMMeida table. Updates the Location field of the HRMMeida table with the corresponding value of the RecId field of the LogisticsLocation table.

Data Migration Section

From Table: HRMMedia	To Table: LogisticsPostalAddress
CountryRegionId	CountryRegionId
StateId	State
CountyId	County
City	City
ZipCodeId	ZipCode
Street	Street
Address	Address

From Table: HRMMedia	To Table: LogisticsLocation
HrmMediaId	Description

Name Changes for Tables or Fields

Old Table Name:	New Table Name:
Old Field Name:	New Field Name:
CountryRegionId	DEL_CountryRegionId
StateId	DEL_StateId
CountyId	DEL_CountyId
City	DEL_City
ZipCodeId	DEL_ZipCodeId
Street	DEL_Street
Address	DEL_Address