Share via

ReleaseUpdateDB60_Payroll.updatePrlUSTaxTransactionHistory Upgrade Script

  • Article

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

Class

ReleaseUpdateDB60_Payroll

Method

updatePrlUSTaxTransactionHistory

Description

Updates records in the PrlUSTaxTransactionHistory table replacing the following relationships PRLEmployeePayElementsTransPosted table with a relationship to the PayrollPayStatement and DEL_EmplTable table with a relationship to the HcmWorker table.

Affected Modules and Tables

Affected Modules

Payroll

Affected Tables

PrlUSTaxTransactionHistory

PRLEmployeePayElementsTransPosted

DEL_EmplTable

PayrollTaxEngineTaxCodeForSymmetry

LogisticsAddressCountryRegion

HcmWorker

Remarks

Replaces the following fields of the PrlUSTaxTransactionHistory table: The PayStatement field with the corresponding value from the DEL_MappingRecId field of the PRLEmployeePayElementsTransPosted table, The DEL_EmplId field with the corresponding value from the record ID of the HcmWorker table.

Data Migration Section

From Table: HcmWorker

To Table: PrlUSTaxTransactionHistory

RecId

Worker

From Table: PRLEmployeePayElementsTransPosted

To Table: PrlUSTaxTransactionHistory

del_MappingRec

PayStatement

From Table: PayrollTaxEngineTaxCodeForSymmetry

To Table: PrlUSTaxTransactionHistory

PayrollTaxCode

TaxCode