iVend Database Database : RepReplicationTransaction Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

217

Data Space Used

32.00 KB

Index Space Used

120.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

ReplicationTransactionKey

System Generated Primary key of the Table.

VarWChar

50

SourceType

Refers to the Object Id of the record to be replicated.

Integer

4

SourceKey

Refers to the Primary Key of the record to be replicated.

VarWChar

50

BatchKey

Refers to the Batch Key of the record to be replicated.

VarWChar

50

OperationType

Refers to the Operation Type of the record to be replicated. Add -0, Edit -1, Soft delete - 2, Hard Delete - 3

SmallInt

2

Flag

Refers to the flag of the record to be replicated.

Boolean

1

StoreId

Refers to the Site Id of the record to be replicated.

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

SeqenceNo

Refers to the Sequence in which replication record was created.

BigInt

8

ProcessDate

Refers to the date time when the record was created.

DBTimeStamp

4

([dbo].[GetCompanyDateTime]())

SendDumpSequenceNumber

Sequence number for the Replication. Do not update or modify.

BigInt

8

Index

Description

Primary

Unique

IX_RepReplicationTransaction

IX_RepReplicationTransaction_1

IX_RepReplicationTransaction_2

PK_ReplicationTransaction

Trigger

Description

Trg_ReplicationTransactionMobile

Database Object

Object Type

Description

Dep Level

AssignTill

Stored Procedure

Assigns a Till to the selected POS

1

CancelStockTransfer

Stored Procedure

1

ClearOfflinePOSData

Stored Procedure

1

DataNotification

Stored Procedure

1

DeleteSuspendedTransactionDetails

Stored Procedure

1

GetNextDocumentNumberForPOS

Stored Procedure

Generates the next Transaction Number depending on the Parameters provided

1

Integration_InventoryItemPrice

Stored Procedure

1

InvWarehouseInventoryLocation

Stored Procedure

1

LogAuditInformation

Stored Procedure

1

RemoveTill

Stored Procedure

Removes a Till from the selected POS

1

ReplicationRecordsToSend

Stored Procedure

1

Trg_RepNotification

Trigger

1

TrgSBOBatchUpdate

Trigger

Handles updates made to Batch table from ERP system (Business One in this case)

1

TrgSBOInventoryUpdate

Trigger

Handles updates made to item inventory in the ERP system (Business One in this case)

1

TrgSBOSerialUpdate

Trigger

Handles updates made to Serial table from ERP system (Business One in this case)

1

TrxCompleteTransactionUpdates

Stored Procedure

1

TrxGenerateLayawayInstallments

Stored Procedure

Generates Layaway installments for the Layaway transaction

1

TrxGenerateLayawayInstallmentsForSaleLevel

Stored Procedure

Generates Layaway installments for the Layaway transaction

1

TrxHandleARPayments

Stored Procedure

Handles updates related to On Account payments

1

TrxInventoryUpdateLaybyCancellationItem

Stored Procedure

1

TrxInventoryUpdateLaybyItem

Stored Procedure

2

TrxInventoryUpdateOrder

Stored Procedure

Handles updates related to Order item

1

TrxInventoryUpdateQuotation

Stored Procedure

Handles updates related to Quotation item

1

TrxInventoryUpdateSaleDelivery

Stored Procedure

Handles updates related to delivery of a Sale item

1

TrxInventoryUpdatesSaleRefund

Stored Procedure

Handles updates related to On Account payments

1

TrxUpdateCustomerBalance

Stored Procedure

1

UpdateTillAmounts

Stored Procedure

Handles updates to Till once payment against a transaction has been taken

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[RepReplicationTransaction](

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

[SeqenceNo] [bigint] IDENTITY(1,1) NOT NULL,

[ProcessDate] [datetime] NULL,

[SendDumpSequenceNumber] [bigint] NULL,

CONSTRAINT [PK_ReplicationTransaction] PRIMARY KEY CLUSTERED

(

[ReplicationTransactionKey] 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].[RepReplicationTransaction] ADD CONSTRAINT [DF_RepReplicationTransaction_ProcessDate] DEFAULT ([dbo].[GetCompanyDateTime]()) FOR [ProcessDate]