iVend Database Database : ClearOfflinePOSData Stored Procedure

Creation Date

3/13/2019 6:27 PM

Encrypted

Ansi Nulls

Parameter

Direction

Description

Data Type

Size

@RETURN_VALUE

Return Value

Integer

4

Database Object

Object Type

Description

Dep Level

CfgAuditLog

Table

Stores system logs.

1

CfgSiteInformation

Table

Stores the site information. Enterprise always has the site id as 1. System Table Warning : Should not be modified directly

1

RepObjectMapDB

Table

System table. Do not modify

1

RepReplicationSendDump

Table

stores the information that has to be sent using replication service between store and HO.

1

RepReplicationTransaction

Table

Stores the Transaction details for them the data needs to be replicated

1

RepReplicationTransactionDetail

Table

1

CREATE PROCEDURE [dbo].[ClearOfflinePOSData]

AS

BEGIN

SET NOCOUNT ON;

declare @currentPOSSiteId int

select @currentPOSSiteId = ISNULL(POSSiteId,0) from CfgSiteInformation

if @currentPOSSiteId =0

return 0

--Delete the send dump of records which are replicated to HO/Store

Delete A

from RepReplicationSendDump A, RepReplicationTransactionDetail B

Where A.ReplicationSendDumpKey = B.ReplicationTransactionKey

And Status = 1

--This would mean that we are in the offline pos database

Delete from CfgAuditLog

Where AuditKey in

(

Select Distinct B.SourceKey

From RepObjectMapDB A Inner Join RepReplicationTransaction B On A.ObjectID = B.SourceType

And A.TableName = 'CfgAuditLog'

Inner Join RepReplicationTransactionDetail C On B.ReplicationTransactionKey = C.ReplicationTransactionKey

And C.Status = 1

)

END