iVend Database Database : InvPlanningScenario 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

PlanningScenarioKey

System generated Primary key of the table.

VarWChar

50

Id

Value is the Id of the Inventory Planning Scenario

VarWChar

40

Description

Refers to the description for the Inventroy Planning Scenario

VarWChar

200

StartDate

Specify the Start Date to get MRP recommendation start from specified date

DBTimeStamp

4

EndDate

Specify the End Date to get MRP recommendation upto specified date

DBTimeStamp

4

BasedOn

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

Integer

4

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

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

VarWChar

50

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

ForecastPlanningKey

Reference of ForecastPlanningKey. See ForecastPlanning

VarWChar

50

RecommendPurchase

Value is the recommended Purchase

Boolean

1

PurchaseRecommendType

Valid values are:

LocalPurchase = 1,

AllPurchase = 2

Integer

4

RecommendStockTransfer

Value is the recommended Stock Transfer

Boolean

1

StoreKey

Reference key of store.

VarWChar

50

TimeRange

Specifies if a inventory is in 'Within Planning Horizon' or 'Include Historical Data' time range in MRP run.

Integer

4

((0))

ConsiderDefaultLocation

Specifies if a inventory from the default location is to be considered in MRP run.

Boolean

1

((0))

ConsiderSaleLocation

Specifies if a inventory from the Sales location is to be considered in MRP run.

Boolean

1

((0))

ConsiderRefundLocation

Specifies if a inventory from the Refund location is to be considered in MRP run.

Boolean

1

((0))

ConsiderFulfilmentLocation

Specifies if a inventory from the Fulfillment location is to be considered in MRP run.

Boolean

1

((0))

ConsiderGoodsReceiveLocation

Specifies if a inventory from the Goods Receive location is to be considered in MRP run.

Boolean

1

((0))

ConsiderStockTransferLocation

Specifies if a inventory from the Stock Tranfer location is to be considered in MRP run.

Boolean

1

((0))

ConsiderGoodsIssueLocation

Specifies if a inventory from the Goods Issue location is to be considered in MRP run.

Boolean

1

((0))

ConsiderGoodsReturnLocation

Specifies if a inventory from the Returns location is to be considered in MRP run.

Boolean

1

((0))

ConsiderGoodsFreezeLocation

Specifies if a inventory from the Freeze location is to be considered in MRP run.

Boolean

1

((0))

ConsiderStorageLocation

Specifies if a inventory from the Storage location is to be considered in MRP run.

Boolean

1

((0))

Index

Description

Primary

Unique

PK_InvPlanningScenario

Database Object

Object Type

Description

Dep Level

MRP

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvPlanningScenario](

[PlanningScenarioKey] [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 NULL,

[StartDate] [datetime] NULL,

[EndDate] [datetime] NULL,

[BasedOn] [int] NOT NULL,

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

[ToKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS 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,

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

[RecommendPurchase] [bit] NULL,

[PurchaseRecommendType] [int] NULL,

[RecommendStockTransfer] [bit] NULL,

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

[TimeRange] [int] NULL,

[ConsiderDefaultLocation] [bit] NULL,

[ConsiderSaleLocation] [bit] NULL,

[ConsiderRefundLocation] [bit] NULL,

[ConsiderFulfilmentLocation] [bit] NULL,

[ConsiderGoodsReceiveLocation] [bit] NULL,

[ConsiderStockTransferLocation] [bit] NULL,

[ConsiderGoodsIssueLocation] [bit] NULL,

[ConsiderGoodsReturnLocation] [bit] NULL,

[ConsiderGoodsFreezeLocation] [bit] NULL,

[ConsiderStorageLocation] [bit] NULL,

CONSTRAINT [PK_InvPlanningScenario] PRIMARY KEY CLUSTERED

(

[PlanningScenarioKey] 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].[InvPlanningScenario] ADD CONSTRAINT [DF__InvPlanni__TimeR__5807F46D] DEFAULT ((0)) FOR [TimeRange]

ALTER TABLE [dbo].[InvPlanningScenario] ADD CONSTRAINT [DF__InvPlanni__Consi__58FC18A6] DEFAULT ((0)) FOR [ConsiderDefaultLocation]

ALTER TABLE [dbo].[InvPlanningScenario] ADD CONSTRAINT [DF__InvPlanni__Consi__59F03CDF] DEFAULT ((0)) FOR [ConsiderSaleLocation]

ALTER TABLE [dbo].[InvPlanningScenario] ADD CONSTRAINT [DF__InvPlanni__Consi__5AE46118] DEFAULT ((0)) FOR [ConsiderRefundLocation]

ALTER TABLE [dbo].[InvPlanningScenario] ADD CONSTRAINT [DF__InvPlanni__Consi__5BD88551] DEFAULT ((0)) FOR [ConsiderFulfilmentLocation]

ALTER TABLE [dbo].[InvPlanningScenario] ADD CONSTRAINT [DF__InvPlanni__Consi__5CCCA98A] DEFAULT ((0)) FOR [ConsiderGoodsReceiveLocation]

ALTER TABLE [dbo].[InvPlanningScenario] ADD CONSTRAINT [DF__InvPlanni__Consi__5DC0CDC3] DEFAULT ((0)) FOR [ConsiderStockTransferLocation]

ALTER TABLE [dbo].[InvPlanningScenario] ADD CONSTRAINT [DF__InvPlanni__Consi__5EB4F1FC] DEFAULT ((0)) FOR [ConsiderGoodsIssueLocation]

ALTER TABLE [dbo].[InvPlanningScenario] ADD CONSTRAINT [DF__InvPlanni__Consi__5FA91635] DEFAULT ((0)) FOR [ConsiderGoodsReturnLocation]

ALTER TABLE [dbo].[InvPlanningScenario] ADD CONSTRAINT [DF__InvPlanni__Consi__609D3A6E] DEFAULT ((0)) FOR [ConsiderGoodsFreezeLocation]

ALTER TABLE [dbo].[InvPlanningScenario] ADD CONSTRAINT [DF__InvPlanni__Consi__24A84BF8] DEFAULT ((0)) FOR [ConsiderStorageLocation]