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