iVend Database Database : RepObjectMapDB Table

Creation Date

9/13/2016 5:28 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

375

Data Space Used

56.00 KB

Index Space Used

64.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

ObjectID

Primary key of the table

Double

9

TableName

Name of a table to be replicated

VarWChar

255

TablePrimaryColumn

Name of the Primary key field for the table.

VarWChar

255

TableType

Defines if the table being replicated is a master or not. Transaction - 0, Master -1

Boolean

1

UseForInterStore

Value is true is user for the inter store

Boolean

1

UseForeStore

Value is true is user for the store

Boolean

1

((0))

UseForMobile

Value is true is user for mobile

Boolean

1

((0))

AddEditViewName

Value is the View name

VarWChar

100

UseForSettingsPackage

System Field

Integer

4

((0))

PackageSettingName

System Field

VarWChar

100

UseForClearingData

System Field

Boolean

1

Priority

Value is the Priority for the Object to be replicated

SmallInt

2

((0))

IsMasterObject

The value is 1 if it is a master object. Only master objects will be shown in RegisterApplicationScreen.

Boolean

1

((0))

MasterObjectDescription

The value is the Description for an object that will be shown on RegisterApplication Screen.

VarWChar

100

IgnoreForOfflinePOS

Boolean

1

CanUpdate

Boolean

1

((1))

TableIdFieldName

VarWChar

500

ExcludeInStoreBackup

Boolean

1

((0))

ExcludeInOfflinePOSBackup

Boolean

1

((0))

Index

Description

Primary

Unique

IX_RepObjectMapDB

PK_RepObjectMapDB

Database Object

Object Type

Description

Dep Level

ClearOfflinePOSData

Stored Procedure

1

DataNotification

Stored Procedure

1

ReplicationRecordsToSend

Stored Procedure

1

Trg_ReplicationTransactionMobile

Trigger

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[RepObjectMapDB](

[ObjectID] [float] NOT NULL,

[TableName] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[TablePrimaryColumn] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[TableType] [bit] NOT NULL,

[UseForInterStore] [bit] NULL,

[UseForeStore] [bit] NULL,

[UseForMobile] [bit] NULL,

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

[UseForSettingsPackage] [int] NULL,

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

[UseForClearingData] [bit] NULL,

[Priority] [smallint] NOT NULL,

[IsMasterObject] [bit] NULL,

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

[IgnoreForOfflinePOS] [bit] NULL,

[CanUpdate] [bit] NULL,

[TableIdFieldName] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ExcludeInStoreBackup] [bit] NULL,

[ExcludeInOfflinePOSBackup] [bit] NULL,

CONSTRAINT [PK_RepObjectMapDB] PRIMARY KEY CLUSTERED

(

[ObjectID] 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].[RepObjectMapDB] ADD CONSTRAINT [DF_RepObjectMapDB_UseForeStore] DEFAULT ((0)) FOR [UseForeStore]

ALTER TABLE [dbo].[RepObjectMapDB] ADD CONSTRAINT [DF_RepObjectMapDB_UseForMobile] DEFAULT ((0)) FOR [UseForMobile]

ALTER TABLE [dbo].[RepObjectMapDB] ADD CONSTRAINT [DF_RepObjectMapDB_UseForSettingsPackage] DEFAULT ((0)) FOR [UseForSettingsPackage]

ALTER TABLE [dbo].[RepObjectMapDB] ADD CONSTRAINT [DF__RepObject__Prior__22F50DB0] DEFAULT ((0)) FOR [Priority]

ALTER TABLE [dbo].[RepObjectMapDB] ADD CONSTRAINT [DF_RepObjectMapDB_IsMasterObject] DEFAULT ((0)) FOR [IsMasterObject]

ALTER TABLE [dbo].[RepObjectMapDB] ADD CONSTRAINT [DF_RepObjectMapDB_CanUpdate] DEFAULT ((1)) FOR [CanUpdate]

ALTER TABLE [dbo].[RepObjectMapDB] ADD CONSTRAINT [DF_RepObjectMapDB_ExcludeInStoreBackup] DEFAULT ((0)) FOR [ExcludeInStoreBackup]

ALTER TABLE [dbo].[RepObjectMapDB] ADD CONSTRAINT [DF_RepObjectMapDB_ExcludeInOfflinePOSBackup] DEFAULT ((0)) FOR [ExcludeInOfflinePOSBackup]