iVend Database Database > Tables > TrxScannedDataDetail Table

Navigation: iVend Database Database > Tables >

iVend 6.6 Database Help

TrxScannedDataDetail Table

Collapse All Expand All

iVend Database Database : TrxScannedDataDetail Table

Properties

Creation Date	10/8/2018 5:57 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

Columns

Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
ScannedDetailKey		VarWChar	50
ScannedHeaderKey		VarWChar	50
ProductKey		VarWChar	50
Quantity		Numeric	9 (20,5)
ProductDetailKey		VarWChar	50
RecordStatus		Integer	4
ConvertedToDetailKey		VarWChar	50
DataType		Integer	4		((0))
ProductId		VarWChar	50

Indexes

Index	Description	Primary	Unique
PK_TrxScannedDataDetail

Check Constraints

Name	Description	Expression
CK_TrxScannedDataDetail		([DataType]=(2) OR [DataType]=(1) OR [DataType]=(0))
CK_TrxScannedDataDetail_1		([RecordStatus]=(2) OR [RecordStatus]=(1) OR [RecordStatus]=(0))

Triggers

Trigger	Description
Trg_TrxScannedDataDetail

Relationships

Relationship	Description
FK_TrxScannedDataDetail_InvProduct
FK_TrxScannedDataDetail_TrxScannedDataDetail

Objects that depend on TrxScannedDataDetail

Database Object	Object Type	Description	Dep Level
BarCodeResolution	Stored Procedure		1
Trg_TrxScannedDataDetail	Trigger		1

Objects that TrxScannedDataDetail depends on

	Database Object	Object Type	Description	Dep Level
	InvProduct	Table	Stores the product related details.	1

SQL

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[TrxScannedDataDetail](

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

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

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

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

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

[RecordStatus] [int] NOT NULL,

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

[DataType] [int] NOT NULL,

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

CONSTRAINT [PK_TrxScannedDataDetail] PRIMARY KEY CLUSTERED

(

[ScannedDetailKey] 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].[TrxScannedDataDetail] ADD CONSTRAINT [DF_TrxScannedDataDetail_DataType] DEFAULT ((0)) FOR [DataType]

ALTER TABLE [dbo].[TrxScannedDataDetail] WITH CHECK ADD CONSTRAINT [FK_TrxScannedDataDetail_InvProduct] FOREIGN KEY([ProductKey])

REFERENCES [dbo].[InvProduct] ([ProductKey])

ALTER TABLE [dbo].[TrxScannedDataDetail] CHECK CONSTRAINT [FK_TrxScannedDataDetail_InvProduct]

ALTER TABLE [dbo].[TrxScannedDataDetail] WITH CHECK ADD CONSTRAINT [FK_TrxScannedDataDetail_TrxScannedDataDetail] FOREIGN KEY([ScannedDetailKey])

REFERENCES [dbo].[TrxScannedDataDetail] ([ScannedDetailKey])

ALTER TABLE [dbo].[TrxScannedDataDetail] CHECK CONSTRAINT [FK_TrxScannedDataDetail_TrxScannedDataDetail]

ALTER TABLE [dbo].[TrxScannedDataDetail] WITH CHECK ADD CONSTRAINT [CK_TrxScannedDataDetail] CHECK (([DataType]=(2) OR [DataType]=(1) OR [DataType]=(0)))

ALTER TABLE [dbo].[TrxScannedDataDetail] CHECK CONSTRAINT [CK_TrxScannedDataDetail]

ALTER TABLE [dbo].[TrxScannedDataDetail] WITH CHECK ADD CONSTRAINT [CK_TrxScannedDataDetail_1] CHECK (([RecordStatus]=(2) OR [RecordStatus]=(1) OR [RecordStatus]=(0)))

ALTER TABLE [dbo].[TrxScannedDataDetail] CHECK CONSTRAINT [CK_TrxScannedDataDetail_1]

Related Objects

iVend Database Database

Send comments on this topic.