Compartilhar via


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