Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
RepReplicationSendDump Table
Collapse All Expand All
iVend Database Database : RepReplicationSendDump Table |
Description
stores the information that has to be sent using replication service between store and HO.
Properties
Creation Date |
12/9/2015 3:35 PM |
File Group |
PRIMARY |
Text File Group |
PRIMARY |
System Object |
|
Published for Replication |
|
Rows |
0 |
Data Space Used |
0.00 KB |
Index Space Used |
0.00 KB |
Columns
|
Column Name |
Description |
Datatype |
Length |
Allow Nulls |
Default |
Formula |
|
ReplicationSendDumpKey |
Primary key holds the value of the Replication Transaction key prepared for replication. |
VarWChar |
50 |
|
|
|
|
SourceType |
Refers to the Object Id of the prepared record. |
Integer |
4 |
|
|
|
|
SourceKey |
Refers to the Primary Key of the prepared record. |
VarWChar |
50 |
|
|
|
|
BatchKey |
Refers to the Batch Key of the prepared record. |
VarWChar |
50 |
|
|
|
|
OperationType |
Refers to the Operation Type of the prepared record. Add -0, Edit -1, Soft delete - 2, Hard Delete - 3 |
SmallInt |
2 |
|
|
|
|
Flag |
Refers to the flag of the prepared record. |
Boolean |
1 |
|
|
|
|
StoreId |
Refers to the Site Id of the prepared record. |
VarWChar |
50 |
|
|
|
|
FromSBO |
Refers to whether the record originated from SBO . |
Boolean |
1 |
|
|
|
|
Sender |
For future use |
VarWChar |
50 |
|
|
|
|
Receiver |
For future use |
VarWChar |
50 |
|
|
|
|
InsertQuery |
Holds the prepared statement to be executed. |
LongVarWChar |
16 |
|
|
|
|
UpdateQuery |
Holds the prepared statement to be executed. |
LongVarWChar |
16 |
|
|
|
|
DeleteQuery |
Holds the prepared statement to be executed. |
LongVarWChar |
16 |
|
|
|
|
SeqenceNo |
Refers to the Sequence Number in which replication records were prepared for sending. |
BigInt |
8 |
|
|
|
|
TargetSite |
Refers to the Site Id(s) which will pick up the prepared record. |
VarWChar |
4000 |
|
|
|
|
ProcessDate |
Refers to the date time when the record was prepared. |
DBTimeStamp |
4 |
|
(getdate()) |
|
Indexes
Index |
Description |
Primary |
Unique |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Objects that depend on RepReplicationSendDump
|
Database Object |
Object Type |
Description |
Dep Level |
|
Stored Procedure |
|
1 |
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[RepReplicationSendDump]( [ReplicationSendDumpKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [SourceType] [int] NOT NULL, [SourceKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [BatchKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [OperationType] [smallint] NOT NULL, [Flag] [bit] NOT NULL, [StoreId] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [FromSBO] [bit] NULL, [Sender] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Receiver] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [InsertQuery] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [UpdateQuery] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DeleteQuery] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SeqenceNo] [bigint] IDENTITY(1,1) NOT NULL, [TargetSite] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ProcessDate] [datetime] NULL, CONSTRAINT [PK_RepReplicationSendDump_1] PRIMARY KEY CLUSTERED ( [ReplicationSendDumpKey] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] ALTER TABLE [dbo].[RepReplicationSendDump] ADD CONSTRAINT [DF_RepReplicationSendDump_ProcessDate] DEFAULT (getdate()) FOR [ProcessDate] |
See Also
Related Objects
© 2019 All Rights Reserved.
Send comments on this topic.