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

InventoryCountDetailKey

Value is the system generated Primary Key of the table.

VarWChar

50

InventoryCountKey

Reference Key of Inventory Count. See also inventory Count.

VarWChar

50

ProductKey

Reference key of Product. See also Product

VarWChar

50

WarehouseKey

Refers to the key of the warehouse from where the Inventory Count has been selected. See also Warehouse.

VarWChar

50

InventoryItemKey

Reference Key of InventoryItem. See also Inventory Item

VarWChar

50

StartingCount

Stores the In-Store count of the product at the time when the Inventory Count was set up.

Numeric

9 (20,5)

InStoreQuantity

Stores the current In-Store quantity of the product.

Numeric

9 (20,5)

CountedQuantity

Stores the Counted quantity of the product.

Numeric

9 (20,5)

DifferenceQuantity

Stores the difference between the In Store Quantity and the counted Quantity.

Numeric

9 (20,5)

Counted

Stores the value 1 when the reconcillation of Inventory count has been done.

Boolean

1

CountedBy

For future use

VarWChar

50

Status

Stores the Status of the Inventroy count. 0 for Open and 1 for Close.

Integer

4

Price

Stores the current price of the product.

Numeric

9 (20,5)

((0))

UOMKey

Refers to the UOM key. See InvUOM

VarWChar

50

UOMQuantity

Refers to the UOM Qunatity of the product

Numeric

9 (20,5)

ProductId

Product id fo the scanned item

VarWChar

50

ProductDescription

Description of the scanned Product

VarWChar

100

AllowFranctionalQuantity

Value is true if the Fractional Qunatity is allowed

Boolean

1

LocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

IsDeleted

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

Boolean

1

((0))

Modified

Date of last modification of this record

DBTimeStamp

4

(getdate())

ModifiedBy

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

VarWChar

50

((1))

Index

Description

Primary

Unique

PK_InvInventoryCountDetail

Database Object

Object Type

Description

Dep Level

InventoryCount_Save

Stored Procedure

1

vwAnalytics_MerchandiseInventoryCount

View

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvInventoryCountDetail](

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

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

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

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

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

[StartingCount] [decimal](20, 5) NOT NULL,

[InStoreQuantity] [decimal](20, 5) NOT NULL,

[CountedQuantity] [decimal](20, 5) NOT NULL,

[DifferenceQuantity] [decimal](20, 5) NOT NULL,

[Counted] [bit] NOT NULL,

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

[Status] [int] NOT NULL,

[Price] [decimal](20, 5) NOT NULL,

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

[UOMQuantity] [decimal](20, 5) NULL,

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

[ProductDescription] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[AllowFranctionalQuantity] [bit] NULL,

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

[IsDeleted] [bit] NOT NULL,

[Modified] [datetime] NOT NULL,

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

CONSTRAINT [PK_InvInventoryCountDetail] PRIMARY KEY CLUSTERED

(

[InventoryCountDetailKey] 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].[InvInventoryCountDetail] ADD CONSTRAINT [DF_InvInventoryCountDetail_Price] DEFAULT ((0)) FOR [Price]

ALTER TABLE [dbo].[InvInventoryCountDetail] ADD CONSTRAINT [DF_InvInventoryCountdetail_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]

ALTER TABLE [dbo].[InvInventoryCountDetail] ADD CONSTRAINT [DF_InvInventoryCountdetail_Modified] DEFAULT (getdate()) FOR [Modified]

ALTER TABLE [dbo].[InvInventoryCountDetail] ADD CONSTRAINT [DF_InvInventoryCountdetail_ModifiedBy] DEFAULT ((1)) FOR [ModifiedBy]