iVend Database Database : GetDeliveryPackages Stored Procedure

Creation Date

4/13/2015 12:00 PM

Encrypted

Ansi Nulls

Parameter

Direction

Description

Data Type

Size

@RETURN_VALUE

Return Value

Integer

4

Database Object

Object Type

Description

Dep Level

InvProduct

Table

Stores the product related details.

1

RtlStore

Table

Contains the details of Stores defined in the system.

1

TrxDeliveryPackage

Table

Stores the Delivery package information

1

TrxDeliveryPackageDetail

Table

Captures the delivery details of the package that is to be delivered from iVend Mobile POS.

1

TrxTransaction

Table

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

1

Create PROCEDURE [dbo].[GetDeliveryPackages]

AS

BEGIN

SET NOCOUNT ON

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

  /*Package*/

  Select A.*,B.TransactionId, C.Id AS 'StoreId', CAST(0 as bit) AS 'IsSelected' from TrxDeliveryPackage A

  INNER JOIN TrxTransaction B ON A.TransactionKey = B.TransactionKey

  INNER JOIN RtlStore C ON C.StoreKey = B.StoreKey

  WHERE A.Status = 0

  /*Package Details*/

SELECT A.*,B.Id AS 'ProductId' from TrxDeliveryPackageDetail A

INNER JOIN InvProduct B On A.ProductKey = B.ProductKey

INNER JOIN TrxDeliveryPackage C On C.DeliveryPackageKey = A.DeliveryPackageKey

WHERE C.Status = 0

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

RETURN

END