ReleaseUpdateDB60_HRM.updateHcmLoanItem

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

Class

ReleaseUpdateDB60_HRM

Method

updateHcmLoanItem

Description

Inserts records into the <c>HcmLoanItem</c> table from the <c>HRMLoanTable</c> table.

Affected Modules and Tables

Affected Modules

Human Resources

Affected Tables

EmplTable

HcmLoanItem

HcmWorker

HRMLoanTable

HRMLoanType

Remarks

This upgrade will retain the data of each company by appending the <c>DataAreaId</c> field to the <c>HrmLoanId</c> field of the <c>HRMLoanTable</c> table to create new, unique identifiers for the <c>HcmLoanItem</c> table when multiple companies exist. If only one company exists, the <c>DataAreaId</c> field will not be appended. The <c>Worker</c> field in the <c>HcmLoanItem</c> table is the foreign key to the <c>HcmWorker</c> table. The <c>LoanType</c> field in the <c>HcmLoanItem</c> table is the foreign key to the <c>HcmLoanType</c> table.

Data Migration Section

From Table: HRMLoanTable

To Table: HcmLoanItem

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

HcmLoanItem

Deleted Tables or Fields

Table

Field

HRMLoanTable

*