iVend Database Database : TilTill 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

TillKey

Primary Key

VarWChar

50

StoreKey

Reference Key of Store

VarWChar

50

Id

Unique id for till

VarWChar

50

Description

Description for Till

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

BusinessDate

Date at which the business of the Store starts

DBTimeStamp

4

StartDate

Date of assigning the till

DBTimeStamp

4

EndDate

Date of closing the till

DBTimeStamp

4

FinalizedDate

Date of finalizing the till

DBTimeStamp

4

Status

Current status of the till.

Valid values are:

New = 0

Assigned = 1

DeAssigned = 2

Closed = 3

Finalized = 4

Integer

4

StartingAmount

Opening amount of the till (at Day Start)

Numeric

9 (20,5)

TransactionAmount

Actual transaction amt for the till

Numeric

9 (20,5)

SystemClosingAmount

System closing amt for the till (StartingAmount + TransactionAmount)

Numeric

9 (20,5)

ClosingAmount

Actual closing amt for the till (At the time of closing the till, the till amount counted by the user)

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

ShowSystemCount

Flag for showing the system amount at the Till Count screen

Boolean

1

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)

TippleAmount

Stores the amount against which the warning level is checked. Stores the actual tipple amount of the till

Numeric

9 (20,5)

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

MasterTillKey

Reference key of Master Till. See also Master Till

VarWChar

50

POSKey

Reference Key of POS

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_TilTill

Database Object

Object Type

Description

Dep Level

AssignTill

Stored Procedure

Assigns a Till to the selected POS

1

CreateTillCount

Stored Procedure

1

RemoveTill

Stored Procedure

Removes a Till from the selected POS

1

rptSalesData

User Defined Function

1

rptSalesTransactionData

User Defined Function

1

rptSalesTransactionDataWithSalesPerson

User Defined Function

1

TrxCompleteTransactionUpdates

Stored Procedure

2

UpdateTillAfterPaymentInsert

Stored Procedure

Handles updates to Till once payment against a particular payment type has been taken

1

UpdateTillAmounts

Stored Procedure

Handles updates to Till once payment against a transaction has been taken

1

UseDrawer

Stored Procedure

Creates a valid Till User session depending on the Cash drawer selected by the user

1

uspTapeReport

Stored Procedure

1

vw_SalesReportData

View

1

XTapeReport

Stored Procedure

Generates the XTape report for a particular till

1

ZTapeReport

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[TilTill](

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

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

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

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

[Mode] [int] NOT NULL,

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

[BusinessDate] [datetime] NOT NULL,

[StartDate] [datetime] NULL,

[EndDate] [datetime] NULL,

[FinalizedDate] [datetime] NULL,

[Status] [int] NOT NULL,

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

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

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

[ClosingAmount] [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,

[ShowSystemCount] [bit] NOT NULL,

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

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

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

[TippleAmount] [decimal](20, 5) 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,

[MasterTillKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS 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_TilTill] PRIMARY KEY CLUSTERED

(

[TillKey] 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].[TilTill] ADD CONSTRAINT [DF_TilTill_POSKey] DEFAULT ((0)) FOR [POSKey]

ALTER TABLE [dbo].[TilTill] ADD CONSTRAINT [DF__TilTill__IsVaria__186270A4] DEFAULT ((0)) FOR [IsVariableFloatAmount]

ALTER TABLE [dbo].[TilTill] ADD CONSTRAINT [DF__TilTill__RemoveT__34FEAF52] DEFAULT ((0)) FOR [RemoveTillOnLogout]

ALTER TABLE [dbo].[TilTill] ADD CONSTRAINT [DF_TilTill_AutoCloseOnEndofDay] DEFAULT ((1)) FOR [AutoCloseOnEndofDay]