ReleaseUpdateDB60_Payroll.updatePayrollWorkerBankAccount Upgrade Script
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
Class |
ReleaseUpdateDB60_Payroll |
Method |
updatePayrollWorkerBankAccount |
Description |
Inserts records into the HcmWorkerBankAccount and the PayrollBankAccountDisbursement table from the DEL_PRLEmplBankAccount table. |
Affected Modules and Tables
Affected Modules |
|---|
Payroll |
Affected Tables |
|---|
DEL_PRLEMPLBANKACCOUNT |
DEL_EMPLTABLE |
COMPANYINFO |
HCMWORKER |
PAYROLLBANKACCOUNTDISBURSEMENT |
HCMWORKERBANKACCOUNT |
Remarks
This upgrade will create records in the HcmWorkerBankAccount table and the PayrollBankAccountDisbursement table from the fields in the DEL_PRLEmplBankAccount table. Records in the HcmWorkerBankAccount table will only be created if one does not already exist for the EmplId and AccountNum value combination. If the AccountNum value does exist, fields that were not previously initialized will be filled in from the DEL_PRLEmplBankAccount table. The record ID of the new or found HcmWorkerBankAccount table will be used to fill in the WorkerBankAccount field of the record added to the PayrollBankAccountDisbursement table.