ReleaseUpdateDB60_Trv.updateTrvPBSMaindataEmpPayMethodRecId 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_Trv |
Method |
updateTrvPBSMaindataEmpPayMethodRecId |
Description |
Populates the EmpPayMethodRecId field in the TrvPBSMaindata table, and a new foreign key field to the TrvEmpPayMethod table. |
Affected Modules and Tables
Affected Modules |
|---|
Expense management |
Affected Tables |
|---|
TrvPBSMaindata |
Remarks
The TrvEmpPaymethod record is retrieved by using the worker and payment method combination. Then the EmpPayMethodRecId field is set by the last record ID from the TevEmpPaymethod table. The last record is selected because it is the most recent credit card for the employee.
Data Migration Section
From Table: TrvEmpPaymethod |
To Table: RecId |
|---|---|
TrvPBSMainData |
EmpPayMethodRecId |
New Tables or Fields
Table |
Field |
Extended Data Type -or- Base Enum |
|---|---|---|
TrvPBSMainData |
EmpPayMethodRecId |
RefRecId |