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

UserKey

Primary Key

VarWChar

50

Id

Id for labor user

VarWChar

50

FirstName

First Name of user

VarWChar

50

MiddleName

Middle Name of user

VarWChar

50

LastName

Last Name of user

VarWChar

40

JobTitle

Job profile of the user

VarWChar

40

TeamKey

Reference key of the Team. See also Team

VarWChar

50

DepartmentKey

Reference key of the Department. See also Department

VarWChar

50

CommissionPlanKey

Reference key for the commission plan

VarWChar

50

((0))

PositionKey

Reference Key of the Employee Position. See also Employee Position

VarWChar

50

RetailProfileKey

Reference Key of Retail Profile. See also Retail Profile

VarWChar

50

IsActive

Flag for checking the user is active or not

Boolean

1

OrderEntry

User is allowed to do the transactions at POS

Boolean

1

UsesTimeClock

Flag for enabling the user to use Time Clock at POS

Boolean

1

AddressKey

Reference Key of Address. See also Address

VarWChar

50

IsTeamBanking

Flag for specfying whether the user can use a Team banking till or not

Boolean

1

IsManager

Flag to identify the user as a manager. This user will be able to login as a manager with the ManagerOverride option

Boolean

1

CreatedBy

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

VarWChar

50

Created

Date of creation of this record

DBTimeStamp

4

ModifiedBy

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

VarWChar

50

Modified

Date of last modification of this record

DBTimeStamp

4

IsDeleted

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

Boolean

1

IsSalesPerson

Specifies whether the Employee is a Sales person type of employee

Boolean

1

CultureInfo

Descriptive information about culture

VarWChar

20

StoreKey

Reference Key of Store at which the USER is connected. See also Store

VarWChar

50

((0))

Email

Defines the Email for the user (will be used while sending email)

VarWChar

100

AllowDashboardDesigning

If true, allows the user to design the Dashboard.

Boolean

1

AllowDashboardWebViewer

If true, allows the user to view the ReportWebViewer (in Web Browser).

Boolean

1

MobilePhone

Defines mobile phone number for the user.

VarWChar

100

IsEODAllowedAtPOS

Value is True, if the user is allowed to perform End Of Day at POS.

Boolean

1

((0))

AllowPosUnlock

Flag to check if user can unlock POS.

Boolean

1

((0))

AllowTransctionApproval

Flag to check whether user can approve/reject transaction.

Boolean

1

Index

Description

Primary

Unique

PK_LbrUser

Database Object

Object Type

Description

Dep Level

BarCodeResolution

Stored Procedure

1

GetMobileReplicationData

Stored Procedure

1

GoodsIssueReport

Stored Procedure

1

GoodsReceiptPOReport

Stored Procedure

1

GoodsReceiptReport

Stored Procedure

1

PurchaseOrderReport

Stored Procedure

1

rpt_LayAway

Stored Procedure

1

rptSalesData

User Defined Function

1

rptSalesTransactionData

User Defined Function

1

rptSalesTransactionDataWithSalesPerson

User Defined Function

1

SalesAnalysisbySalesPersons

Stored Procedure

1

StockTransferReport

Stored Procedure

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

vwAnalytics_Sales

View

1

vwAnalytics_SalesPerson

View

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[LbrUser](

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

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

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

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

[LastName] [nvarchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[JobTitle] [nvarchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

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

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

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

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

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

[IsActive] [bit] NOT NULL,

[OrderEntry] [bit] NOT NULL,

[UsesTimeClock] [bit] NOT NULL,

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

[IsTeamBanking] [bit] NOT NULL,

[IsManager] [bit] NOT NULL,

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

[Created] [datetime] NOT NULL,

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

[Modified] [datetime] NOT NULL,

[IsDeleted] [bit] NOT NULL,

[IsSalesPerson] [bit] NOT NULL,

[CultureInfo] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

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

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

[AllowDashboardDesigning] [bit] NULL,

[AllowDashboardWebViewer] [bit] NULL,

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

[IsEODAllowedAtPOS] [bit] NULL,

[AllowPosUnlock] [bit] NULL,

[AllowTransctionApproval] [bit] NULL,

CONSTRAINT [PK_LbrUser] PRIMARY KEY CLUSTERED

(

[UserKey] 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].[LbrUser] ADD CONSTRAINT [DF__LbrUser__Commiss__36C6FC33] DEFAULT ((0)) FOR [CommissionPlanKey]

ALTER TABLE [dbo].[LbrUser] ADD CONSTRAINT [DF_LbrUser_StoreKey] DEFAULT ((0)) FOR [StoreKey]

ALTER TABLE [dbo].[LbrUser] ADD CONSTRAINT [DF__LbrUser__IsEODAl__10C14EDC] DEFAULT ((0)) FOR [IsEODAllowedAtPOS]

ALTER TABLE [dbo].[LbrUser] ADD CONSTRAINT [DF__LbrUser__AllowPo__50A6C9C7] DEFAULT ((0)) FOR [AllowPosUnlock]