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).