ReleaseUpdateDB60_Payroll.updatePayrollPayCycle Upgrade Script [AX 2012]

Updated: November 9, 2011

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

Class

ReleaseUpdateDB60_Payroll

Method

updatePayrollPayCycle

Description

Inserts records into the PayrollPayCycle table from the DEL_PRLPayPeriodMaster table.

Affected Modules

Payroll

Affected Tables

PAYROLLPAYCYCLE

DEL_PRLPAYROLLPERIODMASTER

This upgrade will retain the data of each company by appending the DataAreaId field to the PayrollPeriodId field of the DEL_PRLPayrollPeriodMaster table to create new, unique identifiers for the PayrollPayCycle table when multiple companies exist. If only one company exists, the DataAreaId field will not be appended. The enum values for the TimePeriod field differ from the values of the PRLPayPeriodEnum enumeration. To correctly map the existing value to the new value, one is added to the TimePeriod field value during the upgrade.

From Table: DEL_PRLPayrollPeriodMaster

To Table: PayrollPayCycle

PayrollPeriodId

PayCycleID

Description

Description

PRLPayPeriodEnum

TimePeriod


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: