iVend Database Database > Tables > InvProductBuildBreakDetail Table

iVend 6.6 Database Help

InvProductBuildBreakDetail Table

Collapse All Expand All

iVend Database Database : InvProductBuildBreakDetail Table

Description

Defines the product details which is being built or break.

Properties

Columns

Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
ProductBuildBreakDetailKey	Primary key	VarWChar	50
ProductBuildBreakKey	Reference Key Product Build Break	VarWChar	50
ProductKey	Reference key of Product which are part of kit	VarWChar	50
Quantity	Quantity of kit product	Numeric	9 (20,5)

Indexes

Index	Description	Primary	Unique
PK_InvProductBuildBreakDetail

Objects that depend on InvProductBuildBreakDetail

Database Object	Object Type	Description	Dep Level
Rpt_ItemWithoutSale	User Defined Function		2
rptClosingBalanceQuantity	User Defined Function		1
rptOpeningBalance	User Defined Function		1
rptOpeningBalance_dailyClosingBal	User Defined Function		1
rptOpeningBalance_Location	User Defined Function		1
rptOpeningBalance_Stock	User Defined Function		1
vw_InventoryMovement	View		1

SQL

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvProductBuildBreakDetail](

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

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

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

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

CONSTRAINT [PK_InvProductBuildBreakDetail] PRIMARY KEY CLUSTERED

(

[ProductBuildBreakDetailKey] ASC

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

) ON [PRIMARY]

Send comments on this topic.