ReleaseUpdateDB60_Payroll.updatePayStatementEarningLine Upgrade Script

  • Article

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

Class

ReleaseUpdateDB60_Payroll

Method

updatePayStatementEarningLine

Description

Inserts records into the PayrollPayStatementEarningLine table from the PrlEmployeePayElementsTrans table.

Affected Modules and Tables

Affected Modules

Payroll

Affected Tables

PayrollPayStatementEarningLine

PayrollTaxRegion

PayrollTaxRegionForSymmetry

PayrollWorkerTaxRegion

PRLEmployeePayElementsTransPosted

PRLEmployeePayElementsTrans

PrlPayElements

PrlGeneralLiabilityInsurance

DEL_PRLWorkerCompensation

Remarks

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

Data Migration Section

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