ReleaseUpdateDB60_Payroll.createTaxRegionData 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

createTaxRegionData

Description

Inserts records into the following tables: PayrollTaxRegion, PayrollTaxRegionForSymmetry, LogisticsLocation, LogisticsPostalAddress, PayrollWorkerTaxRegion, PayrollWorkerTaxRegionForSymmetry, PayrollWorkerResidentTaxRegion, and PayrollPositionWorkerDefaultTaxRgn.

Affected Modules

Payroll

Affected Tables

PayrollTaxRegion

PayrollTaxRegionForSymmetry

LogisticsLocation

LogisiticsPostalAddress

PayrollWorkerTaxRegion

PayrollWorkerTaxRegionForSymmetry

PayrollWorkerResidentTaxRegion

PayrollPositionWorkerDefaultTaxRgn

PrePRLEMPLOYEEUSLOCALTAXSETUP

LogisticsAddressCountryRegion

PayrollTaxCodeParameter

PayrollTaxCodeParameterDetail

PayrollTaxEngineTaxCodeForSymmetry

PayrollWorkerTaxCode

PayrollWorkerTaxCodeParameterValue

PayrollPositionDetail

HCMPositionWorkerAssignment

For every distinct GNISLocation record in the PRLEmployeeUSLocalTaxSetup table, a new record will be inserted into the following tables: PayrollTaxRegion, PayrollTaxRegionForSymmetry, LogisticsLocation, and LogisticsPostalAddress. For a specified GNISLocation record, the following tables will have new records inserted based on the number of records in the PRLEmployeeUSLocalTaxSetup table: PayrollWorkerTaxRegion, PayrollWorkerTaxRegionForSymmetry, PayrollWorkerResidentTaxRegion. Finally, all PRLEmployeeUSLocalTaxSetup records with the EntryDefault field set to Yes will create a new record in the PayrollPositionWorkerDefaultTaxRgn table for every HcmPositionWorkerAssignment record that is assigned to the specified worker.

From Table: PrlEmployeeUSLocalTaxSetup

To Table: LogisticsLocation

State, County, City

Description

From Table: PrlEmployeeUSLocalTaxSetup

To Table: LogisticsPostalAddress

City

City

County

County

State

State

From Table: PrlEmployeeUSLocalTaxSetup

To Table: PayrollTaxRegionForSymmetry

GNISLocation

GNIS

From Table: PrlEmployeeUSLocalTaxSetup

To Table: PayrollWorkerTaxRegion

EmplId

Worker

From Table: PrlEmployeeUSLocalTaxSetup

To Table: PayrollWorkerTaxRegionForSymmetry

SchoolId

SchoolDistrictId

MunFeatureId

MunicipalityId

From Table: PrlEmployeeUSLocalTaxSetup

To Table: PayrollWorkerResidentTaxRegion

EmplId

Worker

From Table: PrlEmployeeUSLocalTaxSetup

To Table: PayrollPositionWorkerDefaultTaxRegion

Emplid

Worker


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

Community Additions

ADD
Show: