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 |