ReleaseUpdateDB60_Payroll.updatePayrollTaxCodeDetail Upgrade Script [AX 2012]

Updated: November 9, 2011

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

Class

ReleaseUpdateDB60_Payroll

Method

updatePayrollTaxCodeDetail

Description

Inserts records into the PayrollTaxCodeDetail table using values from either the PRLLocalWithholding table or the DEL_AddressState table depending on the type of tax code.

Affected Modules

Payroll

Affected Tables

PAYROLLTAXCODEDETAIL

PAYROLLTAXCODE

DEL_ADDRESSSTATE

LOGISTICSADDRESSCOUNTRYREGION

PRLLOCALWITHHOLDING

If the tax code is not an ER_SUTA value, then the Rate field is set by using the OverrideRate field from the PRLLocalWithholding table. Otherwise, the Rate field is set by using the PRLSUTAExperienceRate field from the DEL_AddressState table.

From Table: PRLLocalwithholding

To Table: PayrollTaxCodeDetail

OverrideRate

Rate

dataAreaId

LegalEntity

From Table: AddressState

To Table: PayrollTaxCodeDetail

PRLEmployersStateId

AccountNumber

PRLSUTAExperienceRate

Rate

dataAreaId

LegalEntity


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

Community Additions

ADD
Show: