ReleaseUpdateDB60_Payroll.updatePayrollTaxCodeDetail 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 |
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 and Tables
Affected Modules |
|---|
Payroll |
Affected Tables |
|---|
PAYROLLTAXCODEDETAIL |
PAYROLLTAXCODE |
DEL_ADDRESSSTATE |
LOGISTICSADDRESSCOUNTRYREGION |
PRLLOCALWITHHOLDING |
Remarks
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.
Data Migration Section
From Table: PRLLocalwithholding |
To Table: PayrollTaxCodeDetail |
|---|---|
OverrideRate |
Rate |
dataAreaId |
LegalEntity |
From Table: AddressState |
To Table: PayrollTaxCodeDetail |
|---|---|
PRLEmployersStateId |
AccountNumber |
PRLSUTAExperienceRate |
Rate |
dataAreaId |
LegalEntity |