ReleaseUpdateDB60_smm.updatesmmLeadTableWorker 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_smm
Method	updatesmmLeadTableWorker
Description	Migrates data from the DEL_OwnerId field to the OwnerWorker field, the DEL_OpenedBy field to the OpenedByWorker field, and the DEL_ClosedBy field to the ClosedByWorker field in the smmLeadTable table.

Affected Modules and Tables

Affected Modules
CRM

Affected Tables
smmLeadTable

Remarks

The HCMWorker table and associated tables have replaced the Employee table, that is the EmplTable table, and associated tables in Microsoft Dynamics AX 2012. This transition requires an upgrade.

Data Migration Section

From Table: smmLeadTable	To Table: smmLeadTable
DEL_OwnerId	OwnerWorker
DEL_OpenedBy	OpenedByWorker
DEL_ClosedBy	ClosedByWorker

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
smmLeadTable	OwnerWorker	CrmWorkerRecId
smmLeadTable	OpenedByWorker	CrmWorkerRecId
smmLeadTable	ClosedByWorker	CrmWorkerRecId

Deleted Tables or Fields

Table	Field
smmLeadTable	DEL_OwnerId
smmLeadTable	DEL_OpenedBy
smmLeadTable	DEL_ClosedBy