ReleaseUpdateDB60_HRM.updateJobLimits 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	updateJobLimits
Description	Migrates the job limits to the new signing limit model.

Affected Modules and Tables

Affected Modules
SRM

Affected Tables
HRPLimitParameters
HRPDefaultLimitRule
HRPDefaultLimitDetail
HRPDefaultLimitJobRule

Remarks

This method sets the authority basis to the Job value and the organization precedence to the Company value. Then, for each company, that is Data Area, which is not a virtual company, the system creates a policy of Signing Limit Policy type and maps to the policy.

For every signing limit policy that is created, the system creates two rules. The first rule will have a valid from date equal to the first date, which is the minimum date, from the HRPLimitDefaultTableRelationship table and the valid to date equal to one day less than the current date. The second rule will have the valid from date equal to current date and the valid to date equal to the maximum date. Every job in a company can have multiple default limit setup for the same limit type and document type during different date intervals. These jobs are copied to the two rules which were created earlier.

Data Migration Section

From Table: DEL_HRPLimitDefaultTableRelationship	To Table: HRPDefaultLimitDetail
DefaultValue	Amount
CurrencyCode	Currency

From Table: DEL_HRPLimitTypeTable	To Table: HRPDefaultLimitDetail
LimitType	LimitType

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
HRPDefaultLimitDetail
HRPDefaultLimitRule
HRPDefaultLimitJobRule
HRPLimitParameters

Deleted Tables or Fields

Table	Field
DEL_HRPLimitTypeTable
DEL_HRPLimitDefaultTableRelationship