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 |