iVend Database Database : GetTransactionLinkDocument Stored Procedure

Creation Date

6/20/2017 11:07 AM

Encrypted

Ansi Nulls

Parameter

Direction

Description

Data Type

Size

@TransactionKey

In

VarChar

50

@RETURN_VALUE

Return Value

Integer

4

Database Object

Object Type

Description

Dep Level

PmtCurrency

Table

Define a list of all currecies defined in the system.

1

RtlStore

Table

Contains the details of Stores defined in the system.

1

TrxTransaction

Table

The main table which defined the primary details concerned with every type of transaction.

1

TrxTransactionSaleItem

Table

Stores sale/refund/delivery items attached to a transaction

1

Create PROCEDURE [dbo].[GetTransactionLinkDocument]

@TransactionKey varchar(50)

AS

BEGIN

Select Distinct TrxTransaction.TransactionKey,TransactionId,TransactionCustomerName as FirstName

,TrxTransaction.BusinessDate,ActualDate,RtlStore.Id,TrxTransaction.Total ,PmtCurrency.CultureInfo

from TrxTransaction join TrxTransactionSaleItem

on TrxTransaction.TransactionKey = TrxTransactionSaleItem.TransactionKey

join RtlStore on TrxTransaction.StoreKey = RtlStore.StoreKey

LEFT OUTER JOIN PmtCurrency On TrxTransaction.CurrencyKey = PmtCurrency.CurrencyKey

where TrxTransactionSaleItem.OriginalDocumentKey = @TransactionKey

END