Compartilhar via


ReleaseUpdateDB60_Payroll.updatePayrollPayStatement Upgrade Script

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

Class

ReleaseUpdateDB60_Payroll

Method

updatePayrollPayStatement

Description

Inserts records into the PayrollPayStatement table from the PrlEmployeePayElementsTransPosted table.

Affected Modules and Tables

Affected Modules

Payroll

Affected Tables

PayrollPayStatement

Remarks

This upgrade will create records in the PayrollPayStatement table from the PrlEmployeePayElementsTransPosted table records that are posted and paid. Creates required document numbers based on the number sequence.

Data Migration Section

From Table: PRLEmployeePayElementsTransPosted

To Table: PayrollPayStatement

Worker

Worker

PaymMode

PaymentMethodType

VoidPost

IsReversed

PaymentDate

PaymentDate

RunType

PaymentType

SalaryExpenseJournalId

PaymentJournalBatchNum

From Table: PRLEmployeePayElementsTrans

To Table: PayrollPayStatement

Amount

GrossAccountingCurrencyAmount

Amount

NetAccountingCurrencyAmount

From Table: DEL_PRLPayrollPeriod

To Table: PayrollPayStatement

RecId

PayPeriod

From Table: PRLEmployeePayElementsTransPosted

To Table: DocuRef

txt

Notes

PayElementDate

createdDateTime

From Table: PRLEmployeePayElementsTrans

To Table: DocuRef

DataAreaId

RefCompanyId

From Table: PayrollPayStatement

To Table: DocuRef

RecId

RefRecId

TableId

RefTableId