ReleaseUpdateDB60_smm.updatesmmSalesTargetWorker 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 |
updatesmmSalesTargetWorker |
Description |
Migrates data from the DEL_SalesManId field to the SalesManagerWorker field and the DEL_SalesUnitManagerId field to the SalesPersonWorker field in the smmSalesTarget table. |
Affected Modules and Tables
Affected Modules |
|---|
CRM |
Affected Tables |
|---|
smmSalesTarget |
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: smmSalesTarget |
To Table: smmSalesTarget |
|---|---|
DEL_SalesManId |
SalesManagerWorker |
DEL_SalesUnitManagerId |
SalesPersonWorker |
New Tables or Fields
Table |
Field |
Extended Data Type -or- Base Enum |
|---|---|---|
smmSalesTarget |
SalesManagerWorker |
CrmWorkerRecId |
smmSalesTarget |
SalesPersonWorker |
CrmWorkerRecId |
Deleted Tables or Fields
Table |
Field |
|---|---|
smmSalesTarget |
DEL_SalesManId |
smmSalesTarget |
DEL_SalesUnitManagerId |