ReleaseUpdateDB60_Payroll.updatePayrollPayStatementBenefitLine Upgrade Script [AX 2012]

Updated: June 15, 2012

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

Class

ReleaseUpdateDB60_Payroll

Method

updatePayrollPayStatementBenefitLine

Description

Inserts records into the PayrollPayStatementBenefitLine table from the PrlEmployeePayElementsTrans table.

Affected Modules

Payroll

Affected Tables

PayrollPayStatementBenefitLine

PRLEmployeePayElementsTransPosted

HcmBenefitType

HcmBenefitOption

HcmBenefitPlan

HcmBenefit

PRLEmployeePayElementsTrans

PRLDeductionCodeTable

This upgrade will create records in the PayrollPayStatementBenefitLine table from the PrlEmployeePayElementsTrans table records of the type deduction, contribution, worker's compensation, GLI and fringe.

From Table: PRLEmployeePayElementsTransPosted

To Table: PayrollPayStatementBenefitLine

PayElementDate

AccountingDate

From Table: PRLEmployeePayElementsTrans

To Table: PayrollPayStatementBenefitLine

Amount

AccountingCurrencyAmount

PaymentLineModified

IsPayStatementLineOverridden

From Table: HcmBenefit

To Table: PayrollPayStatementBenefitLine

RecId

Benefit


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

Community Additions

ADD
Show: