iVend Database Database : RtlPOS Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

2

Data Space Used

8.00 KB

Index Space Used

24.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

POSKey

Value is the system generated Primary Key of the table.

VarWChar

50

Id

Value is the Id of the POS.

VarWChar

20

Description

Value is the description of the POS.

VarWChar

100

StoreKey

Value is the key of the store on which the POS being created will be consumed. See also Store

VarWChar

50

DepartmentKey

Value is the key of the department for the POS.See also Department

VarWChar

50

HardwareId

Value is the Hardware Id of the machine to which this POS is attached. POS can be attached and run at a single machine only

VarWChar

200

HardwareProfileKey

Value is the key of the hardware profile already created for the POS, which will define the hardware behaviour of the POS e.g.which are the devices attached to the POS.See also Hardware Profile

VarWChar

50

RetailProfileKey

Value is the key of the retail profile key for the Pos.See also Retail Profile

VarWChar

50

PrintProfileKey

Value is the key of the print profile key for the POS, which defines what will be printed on the reciepts of the POS. See also Print Profile

VarWChar

50

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

IsEnabled

Value is true if the POS is enabled to be used.

Boolean

1

IsVirtualPOS

Value is True if the POS is not setup on any physical machine

Boolean

1

((0))

POSType

Stores the POS type. valid values are PCBased = 0 Mobile = 1

Integer

4

((0))

ApiToken

Stores the ApiToke for the Mobile POS

VarWChar

255

DataSourceType

Data Source for Mobile POS Valid values are Enterprise = 1 Store = 2

Integer

4

((0))

CurrentVersion

Refers to the Current Version of the Point of Sale at Store with the Hardware id

VarWChar

50

PaymentProcessorSetupKey

Reference Key for the Payment processor

VarWChar

50

((0))

IsAddOnUpdated

Value is True if the AddOn has been updated

Boolean

1

((0))

POSSiteId

Value is the Site ID for the POS

Integer

4

IsOfflineEnabled

Value is True if the POS is ready to go for Offline mode at the store.

Boolean

1

PaymentProcessorUniqueIdentifier

Stores the POS specific settings for the Payment Processor

VarWChar

200

CurrentDBVersion

Value is the Current DB version of the Store

VarWChar

50

SaleLocationKey

Stores sale location key.

VarWChar

50

SaleRefundLocationKey

Stores sale refund location key.

VarWChar

50

FulfillmentLocationKey

Stores fulfillment location key.

VarWChar

50

InitializationInProgress

Store is initialization is in progress for mobile POS.

Integer

4

IsCustomerDisplayEnabled

Flag to check whether customer display is enabled.

Boolean

1

CustomerDisplayKey

Stores customer display layout key. See also CfgCustomerDisplayLayout.

VarWChar

50

PatchVersion

Stores updated patch version.

Numeric

9 (20,5)

((0))

IsSelfcheckoutPOS

Boolean

1

((0))

Index

Description

Primary

Unique

IX_RtlPOS

PK_StoPOS

Database Object

Object Type

Description

Dep Level

AssignTill

Stored Procedure

Assigns a Till to the selected POS

1

DataNotification

Stored Procedure

1

GetMobileReplicationData

Stored Procedure

1

GetNextAutoGeneratedCode

Stored Procedure

Generates the next code depending on the Source Type

1

LogAuditInformation

Stored Procedure

1

ReplicationGetMobileSites

Stored Procedure

1

rptSalesData

User Defined Function

1

rptSalesTransactionData

User Defined Function

1

rptSalesTransactionDataWithSalesPerson

User Defined Function

1

SalesAnalysisbySalesPersons

Stored Procedure

2

SalesDetail

User Defined Function

1

Trg_ReplicationTransactionMobile

Trigger

1

TrxCompleteTransactionUpdates

Stored Procedure

1

uspTapeReport

Stored Procedure

1

vw_SalesReportData

View

1

vwAnalytics_MerchandiseSales

View

1

vwAnalytics_NetSales

View

1

vwAnalytics_POS

View

1

vwAnalytics_Sales

View

1

vwAnalytics_SalesPerson

View

1

ZTapeReport

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[RtlPOS](

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

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

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

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

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

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

[PrintProfileKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS 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,

[IsEnabled] [bit] NOT NULL,

[IsVirtualPOS] [bit] NOT NULL,

[POSType] [int] NOT NULL,

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

[DataSourceType] [int] NULL,

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

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

[IsAddOnUpdated] [bit] NULL,

[POSSiteId] [int] NULL,

[IsOfflineEnabled] [bit] NULL,

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

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

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

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

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

[InitializationInProgress] [int] NULL,

[IsCustomerDisplayEnabled] [bit] NULL,

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

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

[IsSelfcheckoutPOS] [bit] NOT NULL,

CONSTRAINT [PK_StoPOS] PRIMARY KEY CLUSTERED

(

[POSKey] 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].[RtlPOS] ADD CONSTRAINT [DF_RtlPOS_IsVirtualPos] DEFAULT ((0)) FOR [IsVirtualPOS]

ALTER TABLE [dbo].[RtlPOS] ADD CONSTRAINT [DF_RtlPOS_POSType] DEFAULT ((0)) FOR [POSType]

ALTER TABLE [dbo].[RtlPOS] ADD CONSTRAINT [DF_RtlPOS_DataSourceType] DEFAULT ((0)) FOR [DataSourceType]

ALTER TABLE [dbo].[RtlPOS] ADD CONSTRAINT [DF_RtlPOS_PaymentProcessorSetupKey] DEFAULT ((0)) FOR [PaymentProcessorSetupKey]

ALTER TABLE [dbo].[RtlPOS] ADD CONSTRAINT [DF_RtlPOS_IsAddOnUpdated] DEFAULT ((0)) FOR [IsAddOnUpdated]

ALTER TABLE [dbo].[RtlPOS] ADD CONSTRAINT [DF__RtlPOS__PatchVer__45F4312A] DEFAULT ((0)) FOR [PatchVersion]

ALTER TABLE [dbo].[RtlPOS] ADD CONSTRAINT [DF_RtlPOS_IsSelfcheckoutPOS] DEFAULT ((0)) FOR [IsSelfcheckoutPOS]