This documentation is archived and is not being maintained.
ReleaseUpdateDB60_HRM.updateHRMMedia Upgrade Script [AX 2012]
Updated: July 20, 2010
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
Human Resources
Affected Tables
LogisticsAddressZipCode
LogisticsAddresssCity
HRMMedia
LogisticsLocation
LogisticsPostalAddress
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.
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
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
Announcements: To see known issues and recent fixes, use
Issue search in
Microsoft Dynamics Lifecycle Services (LCS).