iVend Database Database : RtlHandheldDevices Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

0

Data Space Used

0.00 KB

Index Space Used

0.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

InformationKey

System generated Primary key of the table.

VarWChar

50

SiteId

Site id for which this information is applied to. Prefix have to be unique for each site for each Source type

VarWChar

50

MachineId

Machine ID where the Handheld Devices is registered

VarWChar

200

HardwareId

Value is the Hardware Id of the machine to which this device is attached.

VarWChar

200

IsActive

Value is true if the security user is active.

Boolean

1

((1))

RegistrationDate

Specifies the Date on which the Management Console is Registered

DBTimeStamp

4

CurrentVersion

Refers to the Current Version of the Management console at Store with the Hardware id

VarWChar

50

ThermalLabelKey

Stores the Thermal label key

VarWChar

50

((0))

PrinterName

Stores the Printer name

VarWChar

255

LabelPrinterLanguage

Integer

4

((0))

Index

Description

Primary

Unique

PK_RtlHandheldDevicesInfo

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[RtlHandheldDevices](

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

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

[MachineId] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[HardwareId] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[IsActive] [bit] NULL,

[RegistrationDate] [datetime] NULL,

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

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

[PrinterName] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[LabelPrinterLanguage] [int] NULL,

CONSTRAINT [PK_RtlHandheldDevicesInfo] PRIMARY KEY CLUSTERED

(

[InformationKey] 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].[RtlHandheldDevices] ADD CONSTRAINT [DF_RtlHandheldDevicesInfo_IsActive] DEFAULT ((1)) FOR [IsActive]

ALTER TABLE [dbo].[RtlHandheldDevices] ADD CONSTRAINT [DF_RtlHandheldDevices_ThermalLabelKey] DEFAULT ((0)) FOR [ThermalLabelKey]

ALTER TABLE [dbo].[RtlHandheldDevices] ADD CONSTRAINT [DF__RtlHandhe__Label__5753C756] DEFAULT ((0)) FOR [LabelPrinterLanguage]