iVend Database Database : CfgPOSButtonInfo Table

Creation Date

7/20/2016 11:39 AM

File Group

PRIMARY

Text File Group

PRIMARY

System Object

Published for Replication

Rows

442

Data Space Used

1,440.00 KB

Index Space Used

16.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

POSButtonInfoKey

System generated Primary key of the table.

VarWChar

50

SequenceNo

Sequence in which the button would appear.

Integer

4

Caption

Specifies the Caption for the Button

VarWChar

100

POSOperationTypeKey

Contains The unique key POSOperationType.

VarWChar

50

Transparent

Sets the Button Style to Transparent

Boolean

1

POSButtonStyleKey

Contains The unique key POSButtonStyle.

VarWChar

50

Created

Date of creation of this record

DBTimeStamp

4

Modified

Date of last modification of this record

DBTimeStamp

4

CreatedBy

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

VarWChar

50

ModifiedBy

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

VarWChar

50

IsDeleted

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

Boolean

1

POSButtonGridKey

Contains The unique key POSButtonGrid.

VarWChar

50

IsCustomStyle

Value is True if Button Style is Custom

Boolean

1

IsVisible

Value is True if the Button is visible in the Layout

Boolean

1

((1))

Margin

Specify the margin to be set for buttons.

Integer

4

IsHeaderMarginOverride

Value is True if header's margin value is overriddeen with User's margin value

Boolean

1

((0))

FontName

Refers to the name of the font to be set for style.

VarWChar

100

FontSize

Refers to the size of the font to be set for style.

Integer

4

FontBold

Flag to check whether Font would be bold or not.

Boolean

1

ForeColor

Refers to the Fore Color to be set for style.

Integer

4

BackColor

Specifies the back color to be set for style.

Integer

4

FontItalic

Flag to check whether Font would be italic or not.

Boolean

1

BackColor2

Specifies the back color2 to be set for style.

Integer

4

GradientMode

Specifies the Gradient Mode to be set for style.

Integer

4

FontUnderline

Flag to check whether Font would be underline or not.

Boolean

1

FontStrikethrough

Flag to check whether Font would be strikethrough or not.

Boolean

1

HasGradient

Flag to check whether Style would have gradient or not.

Boolean

1

Image

Refers to the Image for the button

LongVarBinary

16

ImageLocation

Refers to the Image location on the button

Integer

4

Parameter1

Refers to the Parameter of the Button Grid

VarWChar

100

Parameter2

Refers to the Parameter of the Button Grid

VarWChar

100

Parameter3

Refers to the Parameter of the Button Grid

VarWChar

100

Parameter4

Refers to the Parameter of the Button Grid

VarWChar

100

Parameter5

Refers to the Parameter of the Button Grid

VarWChar

100

ShortcutKey

Refers to the Keyboard shortcut key for specific operation

VarWChar

200

Index

Description

Primary

Unique

PK__CfgCusto__C0969537F92F7E36

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[CfgPOSButtonInfo](

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

[SequenceNo] [int] NOT NULL,

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

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

[Transparent] [bit] NOT NULL,

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

[Created] [datetime] NOT NULL,

[Modified] [datetime] NOT NULL,

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

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

[IsDeleted] [bit] NOT NULL,

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

[IsCustomStyle] [bit] NOT NULL,

[IsVisible] [bit] NOT NULL,

[Margin] [int] NOT NULL,

[IsHeaderMarginOverride] [bit] NOT NULL,

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

[FontSize] [int] NULL,

[FontBold] [bit] NULL,

[ForeColor] [int] NULL,

[BackColor] [int] NULL,

[FontItalic] [bit] NULL,

[BackColor2] [int] NULL,

[GradientMode] [int] NULL,

[FontUnderline] [bit] NULL,

[FontStrikethrough] [bit] NULL,

[HasGradient] [bit] NULL,

[Image] [image] NULL,

[ImageLocation] [int] NULL,

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

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

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

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

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

[ShortcutKey] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

CONSTRAINT [PK__CfgCusto__C0969537F92F7E36] PRIMARY KEY CLUSTERED

(

[POSButtonInfoKey] ASC

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

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

ALTER TABLE [dbo].[CfgPOSButtonInfo] ADD CONSTRAINT [DF__CfgButton__IsVis__7B1C2680] DEFAULT ((1)) FOR [IsVisible]

ALTER TABLE [dbo].[CfgPOSButtonInfo] ADD CONSTRAINT [DF__CfgButton__IsHea__53633AE1] DEFAULT ((0)) FOR [IsHeaderMarginOverride]