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 |