iVend Database Database : Integration_TransactionAttribute Stored Procedure

Creation Date

4/13/2015 12:00 PM

Encrypted

Ansi Nulls

Parameter

Direction

Description

Data Type

Size

@TransactionKey

In

transaction key for which the various transactions that needs to be pulled FROM iVend

VarWChar

50

@RETURN_VALUE

Return Value

Integer

4

Database Object

Object Type

Description

Dep Level

CfgSaleAttribute

Table

Stores the sales attributes (Added information that can be attached to each transaction at POS) created in the system. Maximum of 10 attributes are allowed to be created.

1

TrxTransactionSaleAttribute

Table

Stores the Sale attribute details for the transaction

1

CREATE PROCEDURE [dbo].[Integration_TransactionAttribute]

@TransactionKey NVARCHAR(50)

AS

BEGIN

SET NOCOUNT ON;

SELECT  A.AttributeValue, B.IntegratedFieldName FROM TrxTransactionSaleAttribute A

INNER JOIN CfgSaleAttribute B ON A.SaleAttributeKey = B.SaleAttributeKey

AND   B.IsIntegrated = 'TRUE'

WHERE A.TransactionKey = @TransactionKey

END

--EXEC [Integration_TransactionAttribute] 10000000000057