Compartir a través de


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