iVend Database Database : RepIntegrationLog 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

IntegrationKey

Value is the system generated Primary Key of the table.

VarWChar

50

SourceType

It contains the Unique Value Based on the Masters and Transaction which are integrate from iVend To SBO (eg. Item - 46,Transaction - 143)

Integer

4

SourceKey

Value is Primary Key of the iVend table for which event is raised.

VarWChar

50

BatchKey

Refers to Batchkey which is used to combined more than one record

VarWChar

50

OperationType

It contains the Value (0,1,2,3) 0- Add, 1- Update, 2-Soft Delete, 3- Hard Delete in iVend.

SmallInt

2

StoreId

Reference Key for the Store. See Store

VarWChar

50

Flag

If Integration from iVend To SBO Succeed , the value of this field is True otherwise False

Boolean

1

Status

If Integration from iVend To SBO Failed ,the value of this field True otherwise False

Boolean

1

ErrorMessage

If Integration from iVend To SBO failed, This field contains Error Message.

VarChar

5000

LogDatetime

Date of creation of this record

DBTimeStamp

4

(getdate())

ApplicationKey

Reference key of Application ID. See cfgRegisteredApplication

VarWChar

50

((1))

Index

Description

Primary

Unique

IntegrationTransactionId_PK

IX_RepIntegrationLog

Database Object

Object Type

Description

Dep Level

DataNotification

Stored Procedure

1

EnableRollup

Stored Procedure

1

Integration_DisplayNegativeInventory

Stored Procedure

1

TrxConsolidateTransaction

Stored Procedure

1

TrxConsolidateTransactionForCreditCustomers

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[RepIntegrationLog](

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

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

[Flag] [bit] NOT NULL,

[Status] [bit] NULL,

[ErrorMessage] [varchar](5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[LogDatetime] [datetime] NULL,

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

CONSTRAINT [IntegrationTransactionId_PK] PRIMARY KEY CLUSTERED

(

[IntegrationKey] 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].[RepIntegrationLog] ADD CONSTRAINT [DF_RepIntegrationLog_LogDatetime] DEFAULT (getdate()) FOR [LogDatetime]

ALTER TABLE [dbo].[RepIntegrationLog] ADD CONSTRAINT [DF_RepIntegrationLog_ApplicationKey] DEFAULT ((1)) FOR [ApplicationKey]