iVend Database Database : InvForecastPlanning Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

0

Data Space Used

0.00 KB

Index Space Used

0.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

ForecastPlanningKey

Primary Key

VarWChar

50

Id

Value is the Id of the Inventory Forecast Planning

VarWChar

40

Description

Refers to the description for the Forecast Planning

VarWChar

200

HistoricalSalesYear

Specify the Year to get Historical Sales records from specified year

SmallInt

2

ForecastingYear

Specify the Year to get Forecast data for specified year

SmallInt

2

BasedOn

Refers to the type of Based On. Valid values are: Product = 1, ProductCategory = 2, ProductGroup = 3, MerchandiseHierarchy = 4

SmallInt

2

FromKey

Reference key of Product When Based On is Product. See also Product Reference key of Product Category When Based On is ProductCategory. See also Product Category Reference key of Product Group When Based On is ProductGroup. See also Product Group Reference Key of MerchandiseHierarchy When Based On is MerchandiseHierarchy. See also Merchandise Hierarchy

VarWChar

50

ToKey

Reference key of Product When Based On is Product. See also Product Reference key of Product Category When Based On is ProductCategory. See also Product Category Reference key of Product Group When Based On is ProductGroup. See also Product Group Reference Key of MerchandiseHierarchy selected Node When Based On is MerchandiseHierarchy. See also Merchandise Hierarchy Details

VarWChar

50

UpperConfidenceLimit

Hold the value of Upper Confidence Limit. Default value is 97.5

Numeric

9 (19,5)

((97.5))

LowerConfidenceLimit

Hold the value of Lower Confidence Limit. Default value is 2.5

Numeric

9 (19,5)

((2.5))

AllowNegativeForecast

Default value is false.

Boolean

1

((0))

RoundForecast

Default value is true.

Boolean

1

((1))

ConsiderRefundInForecast

Value is true if the Consider Refund In Forecast is selected.

Boolean

1

((1))

IsDeleted

Value is True if the record has been deleted from the system. Record is always Soft Deleted

Boolean

1

CreatedBy

Reference of user who has created this record. See also Security User

VarWChar

50

Created

Date of creation of this record

DBTimeStamp

4

ModifiedBy

Reference of user who has modified this record. See also Security User

VarWChar

50

Modified

Date of last modification of this record

DBTimeStamp

4

SubsidiaryKey

Reference key of the Subsidiary. See also Subsidiary

VarWChar

50

((0))

Index

Description

Primary

Unique

PK__InvForec__3CB17C2D73C51D7B

Database Object

Object Type

Description

Dep Level

Forecast

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvForecastPlanning](

[ForecastPlanningKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Id] [nvarchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Description] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[HistoricalSalesYear] [smallint] NOT NULL,

[ForecastingYear] [smallint] NOT NULL,

[BasedOn] [smallint] NOT NULL,

[FromKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ToKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[UpperConfidenceLimit] [decimal](19, 5) NOT NULL,

[LowerConfidenceLimit] [decimal](19, 5) NOT NULL,

[AllowNegativeForecast] [bit] NOT NULL,

[RoundForecast] [bit] NOT NULL,

[ConsiderRefundInForecast] [bit] NOT NULL,

[IsDeleted] [bit] NOT NULL,

[CreatedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Created] [datetime] NOT NULL,

[ModifiedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Modified] [datetime] NULL,

[SubsidiaryKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

CONSTRAINT [PK__InvForec__3CB17C2D73C51D7B] PRIMARY KEY CLUSTERED

(

[ForecastPlanningKey] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

ALTER TABLE [dbo].[InvForecastPlanning] ADD CONSTRAINT [DF__InvForeca__Upper__75AD65ED] DEFAULT ((97.5)) FOR [UpperConfidenceLimit]

ALTER TABLE [dbo].[InvForecastPlanning] ADD CONSTRAINT [DF__InvForeca__Lower__76A18A26] DEFAULT ((2.5)) FOR [LowerConfidenceLimit]

ALTER TABLE [dbo].[InvForecastPlanning] ADD CONSTRAINT [DF__InvForeca__Allow__7795AE5F] DEFAULT ((0)) FOR [AllowNegativeForecast]

ALTER TABLE [dbo].[InvForecastPlanning] ADD CONSTRAINT [DF__InvForeca__Round__7889D298] DEFAULT ((1)) FOR [RoundForecast]

ALTER TABLE [dbo].[InvForecastPlanning] ADD CONSTRAINT [DF__InvForeca__Consi__797DF6D1] DEFAULT ((1)) FOR [ConsiderRefundInForecast]

ALTER TABLE [dbo].[InvForecastPlanning] ADD CONSTRAINT [DF__InvForeca__Subsi__6EB64F9B] DEFAULT ((0)) FOR [SubsidiaryKey]