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 |