ReleaseUpdateDB60_Payroll.updatePayrollPayStatementEarningLine Upgrade Script [AX 2012]

Updated: June 15, 2012

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

Class

ReleaseUpdateDB60_Payroll

Method

updatePayrollPayStatementEarningLine

Description

Inserts records into the PayrollPayStatementEarningLine table from the PrlEmployeePayElementsTrans table.

Affected Modules

Payroll

Affected Tables

PayrollPayStatementEarningLine

PayrollTaxRegion

PayrollTaxRegionForSymmetry

PayrollWorkerTaxRegion

PRLEmployeePayElementsTransPosted

PRLEmployeePayElementsTrans

PrlPayElements

PrlGeneralLiabilityInsurance

DEL_PRLWorkerCompensation

This upgrade will create records in the PayrollPayStatementEarningLine table from the PrlEmployeePayElementsTrans table records of the type earnings.

From Table: PRLEmployeePayElementsTransPosted

To Table: PayrollPayStatementEarningLine

PayElementDate

AccountingDate

From Table: PRLEmployeePayElementsTrans

To Table: PayrollPayStatementEarningLine

Amount

AccountingCurrencyAmount

PaymentLineModified

IsPayStatementLineOverridden

NormalHours

Quantity

HourlyRate

EarningRate

From Table: PayrollWorkerTaxRegion

To Table: PayrollPayStatementEarningLine

RecId

WorkerTaxRegion


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

Community Additions

ADD
Show: