iVend Database Database > InvForeCastTemp Table : PK_InvForeCastTemp Index

File Group

PRIMARY

Space Used

0.00 KB

Fill Factor

0

Do not Recompute Statistics

Full Text Key

Clustered Index

Primary Key Index

Unique Index

Pad Index

Column

Description

Sort Order

ForecastPlanningKey

Reference Key of Forecast Planning. See also Forecast Planning.

Ascending

ForecastMethod

Refers to the type of Forecasting Method. Valid values are: ExpertSelection = 0, ExponentialSmoothing = 1, BoxJenkins = 2, SimppleMovingAverage = 4, Discrete = 5, IntermittentData = 6, CurveFitting = 12, VerySimpleModels = 14

Ascending

ForecastSubMethod

Refers to the type of Forecasting Sub Method. For Forecasting Method = ExponentialSmoothing Valid values are: Auto = 0, Simple = 1, Holt = 2, Winter = 3 For Forecasting Method = CurveFittingType Valid values are: Auto = 0, StraightLine = 1, Quadratic = 2, Exponential = 3 GrowthCurve = 4

Ascending

ForecastDate

Hold the value of month of the historical sales.

Ascending

WarehouseKey

Reference Key of Warehouse. See also Warehouse.

Ascending

ProductKey

Reference Key of Product. See also Product.

Ascending

Average key length

Density

Rows in the Table

Rows Sampled

Distribution Steps

Updated