iVend Database Database : RepReplicationReceivedPayload Table

Creation Date

7/5/2019 6:02 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

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

ReplicationReceivedPayloadKey

VarWChar

50

(newid())

Payload

LongVarChar

16

RecordCount

BigInt

8

SiteId

Integer

4

ReceivedDate

DBTimeStamp

4

(getdate())

AppliedDate

DBTimeStamp

4

Status

Integer

4

Index

Description

Primary

Unique

PK_RepReceivedPayload

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[RepReplicationReceivedPayload](

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

[Payload] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[RecordCount] [bigint] NULL,

[SiteId] [int] NULL,

[ReceivedDate] [datetime] NULL,

[AppliedDate] [datetime] NULL,

[Status] [int] NULL,

CONSTRAINT [PK_RepReceivedPayload] PRIMARY KEY CLUSTERED

(

[ReplicationReceivedPayloadKey] 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].[RepReplicationReceivedPayload] ADD CONSTRAINT [DF_RepReplicationReceivedPayload_RepReplicationReceivedPayloadKey] DEFAULT (newid()) FOR [ReplicationReceivedPayloadKey]

ALTER TABLE [dbo].[RepReplicationReceivedPayload] ADD CONSTRAINT [DF_RepReceivedPayload_ReceivedDate] DEFAULT (getdate()) FOR [ReceivedDate]