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 |