Compartir a través de


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

updateTrvExpGuest

Description

Populates data in the DEL_Type field in the TrvExpGuest table from the Type field in TrvExpTransGuest table. Also, migrates data from the DEL_EmplId field to the CreatingWorker field and the GuestId field to the InternalGuest field in TrvExpGuest table.

Affected Modules and Tables

Affected Modules

Expense management

Affected Tables

TrvExpGuest

Remarks

This upgrade script is needed to convert the employee ID to the new worker for Microsoft Dynamics AX 2012 as part of HCM uptake for Expense Management. Also, to move the guest type field from the TrvExpTransGuest table to the TrvExpGuest table.

Data Migration Section

From Table: TrvExpTransGuest

To Table: TrvExpGuest

Type

Type

From Table: TrvExpGuest

To Table: TrvExpGuest

GuestId

InternalGuest

DEL_EmplId

CreatingWorker

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

TrvExpGuest

InternalGuest

TrvHcmWorkerRecId

TrvExpGuest

CreatingWorker

TrvHcmWorkerRecId

Deleted Tables or Fields

Table

Field

TrvExpGuest

DEL_EmplId