Compartilhar via


ReleaseUpdateDB60_Payroll.createTaxRegionData Upgrade Script

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 and Tables

Affected Modules

Payroll

Affected Tables

PayrollTaxRegion

PayrollTaxRegionForSymmetry

LogisticsLocation

LogisiticsPostalAddress

PayrollWorkerTaxRegion

PayrollWorkerTaxRegionForSymmetry

PayrollWorkerResidentTaxRegion

PayrollPositionWorkerDefaultTaxRgn

PrePRLEMPLOYEEUSLOCALTAXSETUP

LogisticsAddressCountryRegion

PayrollTaxCodeParameter

PayrollTaxCodeParameterDetail

PayrollTaxEngineTaxCodeForSymmetry

PayrollWorkerTaxCode

PayrollWorkerTaxCodeParameterValue

PayrollPositionDetail

HCMPositionWorkerAssignment

Remarks

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.

Data Migration Section

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