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

updateHRMCompFixedBudget

Description

Updates the Unions field in the HRMCompFixedBudget table with the corresponding value from the record ID field in the HcmUnions table. Updates the Department field in the HRMCompFixedBudget table with the corresponding value from the Party field in the DirPartyInternalOrganizationTable table, which is a foreign key to the OMDepartment table.

Affected Modules and Tables

Affected Modules

Human Resources

Affected Tables

HRMCompFixedBudget

Data Migration Section

From Table: HRMCompFixedBudget

To Table: HRMCompFixedBudget

del_HrmUnionId

Unions

del_LocationId

CompLocation

del_OrganizationUnitId

Department

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

HRMCompFixedBudget

Department

OMDepartmentRecId

CompLocation

Unions

Deleted Tables or Fields

Table

Field

HRMCompFixedBudget

del_HrmUnionId

del_LocationId

del_OrganizationUnitId