ReleaseUpdateDB60_Payroll.updatePayrollPayStatementTaxLine Upgrade Script

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

Class

ReleaseUpdateDB60_Payroll

Method

updatePayrollPayStatementTaxLine

Description

Inserts records into the PayrollPayStatementTaxLine table from the PrlEmployeePayElementsTrans table.

Affected Modules and Tables

Affected Modules

Payroll

Affected Tables

PayrollPayStatementTaxLine

PRLEmployeePayElementsTransPosted

PRLEmployeePayElementsTrans

PrlUSTaxTransactionHistory

Remarks

This upgrade will create records in the PayrollPayStatementTaxLine table from the PrlEmployeePayElementsTrans table records of the type withholding tax employer tax.

Data Migration Section

From Table: PRLEmployeePayElementsTransPosted

To Table: PayrollPayStatementTaxLine

PayElementDate

AccountingDate

From Table: PRLEmployeePayElementsTrans

To Table: PayrollPayStatementTaxLine

Amount

AccountingCurrencyAmount

PaymentLineModified

IsPayStatementLineOverridden

From Table: PrlUSTaxTransactionHistory

To Table: PayrollPayStatementTaxLine

TaxCode

TaxCode