Share via


ReleaseUpdateDB60_Trv.updateTrvAppEmplSub 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

updateTrvAppEmplSub

Description

Upgrades the data in the TrvAppEmplSub table, which is the delegate information.

Affected Modules and Tables

Affected Modules

Expense management

Affected Tables

TrvAppEmplSub

DirPersonUser

UserInfo

EmplTable

Remarks

Before this upgrade, the delegation was using the TrvReportDate field in the TrvExpTable table. The TrvReportDate field is removed and, for delegation purposes, we are using the system-supplied Created Date Time. This upgrade converts the DateFrom and DateTo fields to UTC times, into FromDateUTC and ToDateUTC fields, respectively. Since the FromDateUTC field represents the beginning of the day on the given date, the time portion of this UTC field is always 0, which represents 00:00:00 hours. Similarly, since the ToDateUTC field represents the end of the day on the given date, the time portion of this UTC field is 23:59:59 hours.

Data Migration Section

From Table: TrvAppEmplSub

To Table: TrvAppEmplSub

DateFrom

FromDateUTC

DateTo

ToDateUTC

Deleted Tables or Fields

Table

Field

TrvAppEmplSub

DateFrom

TrvAppEmplSub

DateTo