ReleaseUpdateDB60_Trv.updateTrvPBSMaindataEmpPayMethodRecId Upgrade Script [AX 2012]

Updated: March 17, 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_Trv

Method

updateTrvPBSMaindataEmpPayMethodRecId

Description

Populates the EmpPayMethodRecId field in the TrvPBSMaindata table, and a new foreign key field to the TrvEmpPayMethod table.

Affected Modules

Expense management

Affected Tables

TrvPBSMaindata

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.

From Table: TrvEmpPaymethod

To Table: RecId

TrvPBSMainData

EmpPayMethodRecId

Table

Field

Extended Data Type

-or- Base Enum

TrvPBSMainData

EmpPayMethodRecId

RefRecId


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: