iVend Database Database : Loy_GetTransactionHeader Stored Procedure

Creation Date

4/13/2015 12:00 PM

Encrypted

Ansi Nulls

Parameter

Direction

Description

Data Type

Size

@TransactionKey

In

VarWChar

50

@RETURN_VALUE

Return Value

Integer

4

Database Object

Object Type

Description

Dep Level

CusCustomer

Table

Defines the customer details that interact with the enterprise.

1

CusCustomerGroup

Table

Defines the groups in which the customers can be catagorised.

1

TrxTransaction

Table

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

1

-- =============================================

-- Author:  Jitesh Kumar

-- Create date: 08 Jan 2010

-- Description: Get transaction header detail

-- =============================================

CREATE PROCEDURE [dbo].[Loy_GetTransactionHeader]

@TransactionKey nvarchar(50)

AS

BEGIN

SELECT     TransactionKey,TrxTransaction.StoreKey, TrxTransaction.ActualDate, TrxTransaction.BusinessDate, TrxTransaction.CustomerKey, CusCustomer.HasLoyaltyId,

          CusCustomer.LoyalityId, CusCustomerGroup.CustomerGroupKey, TrxTransaction.HasLayaways, TrxTransaction.HasSales,

    TrxTransaction.HasSaleExchanges, TrxTransaction.HasOrders, TrxTransaction.HasRefunds, TrxTransaction.HasDeliveries,TrxTransaction.IsSuspended,

  TrxTransaction.SubTotal,TrxTransaction.Total

FROM       TrxTransaction INNER JOIN

          CusCustomer ON TrxTransaction.CustomerKey = CusCustomer.CustomerKey INNER JOIN

          CusCustomerGroup ON CusCustomer.CustomerGroupKey = CusCustomerGroup.CustomerGroupKey

    WHERE IsSuspended = 0 AND TransactionKey = @TransactionKey

END