ReleaseUpdateDB60_Req.updateReqPlan 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_Req
Method	updateReqPlan
Description	Updates four new fields that are related to forecast on the ReqPlan table.

Affected Modules and Tables

Affected Modules
Master planning

Affected Tables
ReqPlan

Remarks

Four new fields for including inventory forecast has been introduced for all types of master plans, that is, forecast plans and master plans. This removes the requirement to execute a forecast plan before a master plan in order to include inventory forecast. Settings from existing forecast plans are copied to the new fields on the ReqPlan table. Settings from existing master plans are merged with related forecast plan settings and copied to the new fields on the ReqPlan table.

Data Migration Section

From Table: reqPlanForecast	To Table: reqPlan
del_UsePurchForecast	UseForecastSupply
del_UseSalesForecast	UseForecastDemand
del_ForecastModelId	ForecastModelId

From Table: reqPlanSched	To Table: reqPlan
del_ReduceType	ForecastReduceType

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
ReqPlan	UseForecastDemand	ReqUseForecastDemand
ReqPlan	UseForecastSupply	ReqUseForecastSupply
ReqPlan	ForecastModelId	ForecastModelId
ReqPlan	ForecastReduceType	ReqReduceType

Name Changes for Tables or Fields

Old Table Name: reqPlanForecast	New Table Name:
Old Field Name:	New Field Name:
ForecastModelId	DEL_ForecastModelId
UsePurchForecast	DEL_UsePurchForecast
UseSalesForecast	DEL_UseSalesForecast

Old Table Name: reqPlanSched	New Table Name:
Old Field Name:	New Field Name:
ReqPlanIdForecast	DEL_ReqPlanIdForecast
UseForecastPlan	DEL_UseForecastPlan
ReduceType	DEL_ReduceType