ReleaseUpdateDB60_HRM.updateEmplLimits 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

updateEmplLimits

Description

Migrates the employee limits which are defined on the Employees to the new signing limit model.

Affected Modules and Tables

Affected Modules

SRM

Affected Tables

HRPApprovedLimit

HRPApprovedLimitAmount

Data Migration Section

From Table: DEL_HRPLimitTableRelationship

To Table: HRPApprovedLimit

FromDateTime

ValidFrom

ToDateTime

ValidTo

From Table: DEL_HRPLimitTypeTable

To Table: HRPApprovedLimit

LimitType

SigningLimitType

From Table: DEL_HRPLimitTableRelationship

To Table: HRPApprovedLimitAmount

LimitValue

Amount

CurrencyCode

Currency

DataAreaId

CurrencyDataAreaID

FromDateTime

ValidFrom

ToDateTime

ValidTo

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

HRPApprovedLimit

HRPApprovedLimitAmount

Deleted Tables or Fields

Table

Field

DEL_HRPLimitTableRelationship

DEL_HRPLimitTypeTable