iVend Database Database : Loy_GetLayawayPlanKey Stored Procedure

Creation Date

4/13/2015 12:00 PM

Encrypted

Ansi Nulls

Parameter

Direction

Description

Data Type

Size

@TransactionItemKey

In

VarWChar

50

@RETURN_VALUE

Return Value

Integer

4

Database Object

Object Type

Description

Dep Level

TrxTransactionLayaway

Table

Store layway type of transactions.

1

TrxTransactionSaleItem

Table

Stores sale/refund/delivery items attached to a transaction

1

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

-- Author:  Jitesh Kumar

-- Create date: 08 Jan 2010

-- Description: Get layaway plan key

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

CREATE PROCEDURE [dbo].[Loy_GetLayawayPlanKey]

@TransactionItemKey nvarchar(50)

AS

BEGIN

SELECT      LayawayPlanKey FROM TrxTransactionSaleItem A, TrxTransactionLayaway B

  Where A.OriginalDocumentKey = B.TransactionKey

  And    A.OriginalDetailKey = B.TransactionLayawayKey

  And A.Type = 5

  AND A.TransactionItemKey = @TransactionItemKey

END