iVend Database Database : CfgSearchGridColumn Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

493

Data Space Used

96.00 KB

Index Space Used

16.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

SearchColumnKey

Primary Key

VarWChar

50

ScreenName

Refers to the screen name

VarWChar

100

SourceTableName

Refers to the source table for the screen

VarWChar

100

FieldName

Refers to the field name

VarWChar

100

ShowInGrid

Flag to check whether it has to be shown in the grid on screen or not

Boolean

1

Sequence

Sequence in which the field would appear in the grid.

Integer

4

IsDeleted

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

Boolean

1

Caption

Stores the Caption for the Search Grid

VarWChar

100

ShowOnStandAloneLoyalty

Value is True, if this search grid will be shown on StandAlone Loyalty.

Boolean

1

((0))

Index

Description

Primary

Unique

PK_CfgSearchGridColumn

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[CfgSearchGridColumn](

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

[ScreenName] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[SourceTableName] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[FieldName] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[ShowInGrid] [bit] NOT NULL,

[Sequence] [int] NOT NULL,

[IsDeleted] [bit] NOT NULL,

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

[ShowOnStandAloneLoyalty] [bit] NULL,

CONSTRAINT [PK_CfgSearchGridColumn] PRIMARY KEY CLUSTERED

(

[SearchColumnKey] 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].[CfgSearchGridColumn] ADD CONSTRAINT [DF_CfgSearchGridColumn_ShowOnStandAloneLoyalty] DEFAULT ((0)) FOR [ShowOnStandAloneLoyalty]