iVend Database Database : TilTillMaster Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

1

Data Space Used

8.00 KB

Index Space Used

8.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

MasterTillKey

Primary Key

VarWChar

50

Id

Value is the Id of the Till Master

VarWChar

20

Description

Refers to the description for the Till Master

VarWChar

100

Mode

Mode of the till.

Valid values are:

User = 0

Team = 1

Integer

4

SourceKey

Reference key of user/team according to the selection of mode

VarWChar

50

StoreKey

Reference Key of Store

VarWChar

50

IsAssigned

Current status of the till.

Valid values are:

New = 0

Assigned = 1

DeAssigned = 2

Closed = 3

Finalized = 4

Boolean

1

FloatAmount

Opening amount of the till (at Day Start)

Numeric

9 (20,5)

VarianceRateType

Type of variance rate.

Valid values are:

Percentage = 0

Amount = 1

Integer

4

VarianceRate

Variance allowed in system and counted amount

Numeric

9 (20,5)

CountRequiredOnCreate

Check to enable the count of the amount at Till creation

Integer

4

CountRequiredOnAssign

Check to enable the count of the amount at the time of assigning the till to the cash drawer

Integer

4

CountRequiredOnRemove

Select this option to allow count when the till is taken away from the cash drawer.

Integer

4

CountRequiredOnClose

Select this option to enable count of the amount when the cashier closes the till and it cannot be used for any more transactions.

Integer

4

CountRequiredOnFinalize

Select this option to allow count when the manager closes the till and finalizes it.

Integer

4

WarningLevel

Amount which is the upper limit of the cash for the particular till. This is the tipple point beyond which the system starts giving a warning message.

Numeric

9 (20,5)

WarningInterval

Amount for the warning interval. If the interval is set to $100 for a warning level of $1000, system will warn the user for every $100 being added to $1000.

Numeric

9 (20,5)

LockoutLevel

Amount for lock out level. This field specifies the amount beyond which the POS gets locked and no transaction can be done. If the user wants to that there should no upper limit then the value should be set to 0.

Numeric

9 (20,5)

ShowSystemCount

Flag for showing the system amount at the Till Count screen

Boolean

1

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

IsActive

Check for current Master Till is active or not.

Boolean

1

AllowMultiCurrencyFloat

Value is true if the Multi Currency Float is allowed

Boolean

1

((0))

POSKey

Stores the Reference key of POS to whic this till is by default attached.

VarWChar

50

((0))

IsVariableFloatAmount

Stores the value of flag which indicates if variable float amount is applicable or not .

Boolean

1

((0))

RemoveTillOnLogout

Boolean

1

((0))

AutoCloseOnEndofDay

Boolean

1

((1))

Index

Description

Primary

Unique

PK_TilTillMaster

Database Object

Object Type

Description

Dep Level

vw_SalesReportData

View

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[TilTillMaster](

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

[Id] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

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

[Mode] [int] NOT NULL,

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

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

[IsAssigned] [bit] NOT NULL,

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

[VarianceRateType] [int] NOT NULL,

[VarianceRate] [numeric](20, 5) NOT NULL,

[CountRequiredOnCreate] [int] NOT NULL,

[CountRequiredOnAssign] [int] NOT NULL,

[CountRequiredOnRemove] [int] NOT NULL,

[CountRequiredOnClose] [int] NOT NULL,

[CountRequiredOnFinalize] [int] NOT NULL,

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

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

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

[ShowSystemCount] [bit] NOT 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,

[IsActive] [bit] NOT NULL,

[AllowMultiCurrencyFloat] [bit] NOT NULL,

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

[IsVariableFloatAmount] [bit] NULL,

[RemoveTillOnLogout] [bit] NOT NULL,

[AutoCloseOnEndofDay] [bit] NULL,

CONSTRAINT [PK_TilTillMaster] PRIMARY KEY CLUSTERED

(

[MasterTillKey] 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].[TilTillMaster] ADD CONSTRAINT [DF_TilTillMaster_AllowMultiCurrencyFloat] DEFAULT ((0)) FOR [AllowMultiCurrencyFloat]

ALTER TABLE [dbo].[TilTillMaster] ADD CONSTRAINT [DF_TilTillMaster_POSKey] DEFAULT ((0)) FOR [POSKey]

ALTER TABLE [dbo].[TilTillMaster] ADD CONSTRAINT [DF__TilTillMa__IsVar__176E4C6B] DEFAULT ((0)) FOR [IsVariableFloatAmount]

ALTER TABLE [dbo].[TilTillMaster] ADD CONSTRAINT [DF__TilTillMa__Remov__340A8B19] DEFAULT ((0)) FOR [RemoveTillOnLogout]

ALTER TABLE [dbo].[TilTillMaster] ADD CONSTRAINT [DF_TilTillMaster_AutoCloseOnEndofDay] DEFAULT ((1)) FOR [AutoCloseOnEndofDay]