ReleaseUpdateDB60_smm.updatesmmOpportunityTableWorker 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	updatesmmOpportunityTableWorker
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 smmOpportunityTable table.

Affected Modules and Tables

Affected Modules
CRM

Affected Tables
smmOpportunityTable

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: smmOpportunityTable	To Table: smmOpportunityTable
DEL_OwnerId	OwnerWorker
DEL_OpenedBy	OpenedByWorker
DEL_ClosedBy	ClosedByWorker

New Tables or Fields

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

Deleted Tables or Fields

Table	Field
smmOpportunityTable	DEL_OwnerId
smmOpportunityTable	DEL_OpenedBy
smmOpportunityTable	DEL_ClosedBy