ReleaseUpdateDB60_Payroll.updateLedgerJournalTransPayrollDisburse Upgrade Script

  • Article

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

Class

ReleaseUpdateDB60_Payroll

Method

updateLedgerJournalTransPayrollDisburse

Description

Inserts records into the LedgerJournalTransPayrollDisbursement table from the LedgerJournalTrans, PRLEmployeePayElementsTransPosted, and DEL_PRLEmplBankAccount tables.

Affected Modules and Tables

Affected Modules

Payroll

Affected Tables

LedgerJournalTransPayrollDisbursement

LedgerJournalTrans

PRLEmployeePayElementsTransPosted

DEL_PRLEmplBankAccount

Remarks

Inserts records into the LedgerJournalTransPayrollDisbursement table from the LedgerJournalTrans, PRLEmployeePayElementsTransPosted, and DEL_PRLEmplBankAccount tables. The PayStatement field is the record ID of the posted payment, the RecId field is the LedgerJournalTrans record ID of that posted transaction and the WorkerBankAccount value is the bank account record ID where there exists a PRLDDNumber and CustVendBankAccountId value in the LedgerJournalTrans table.

Data Migration Section

From Table: PRLEmployeePayElementsTransPosted

To Table: LedgerJournalTransPayrollDisbursement

del_MappingRecId

PayStatement

From Table: LedgerJournalTrans

To Table: LedgerJournalTransPayrollDisbursement

RecId

RefRecId

From Table: DEL_PRLEmplBankAccount

To Table: LedgerJournalTransPayrollDisbursement

WorkerBankAccount

WorkerBankAccount