Navigation: iVend Database Database > Stored Procedures >
iVend 6.6 Database Help
Loy_GetTransactionPromotionDetail Stored Procedure
Collapse All Expand All
iVend Database Database : Loy_GetTransactionPromotionDetail Stored Procedure |
Properties
Creation Date |
4/13/2015 12:00 PM |
Encrypted |
|
Ansi Nulls |
|
Parameters
Parameter |
Direction |
Description |
Data Type |
Size |
@TransactionKey |
In |
|
VarWChar |
50 |
@TransactionItemKey |
In |
|
VarWChar |
50 |
@RETURN_VALUE |
Return Value |
|
Integer |
4 |
Objects that Loy_GetTransactionPromotionDetail depends on
|
Database Object |
Object Type |
Description |
Dep Level |
|
Table |
Stores the promotion applied details on the transaction |
1 |
Procedure Source Code
CREATE PROCEDURE [dbo].[Loy_GetTransactionPromotionDetail] @TransactionKey nvarchar(50), @TransactionItemKey nvarchar(50) AS BEGIN SELECT TransactionPromotionDetailKey,TransactionKey,[Type],TransactionItemKey, PromotionKey,Quantity,DiscountAmount,ItemType, Sets,PromotionNumber FROM TrxTransactionPromotionDetail WHERE TransactionItemKey=@TransactionItemKey and TransactionKey = @TransactionKey END |
See Also
Related Objects
© 2019 All Rights Reserved.
Send comments on this topic.