Navigation: iVend Database Database > Stored Procedures >
iVend 6.6 Database Help
Loy_GetTransactionLineItem Stored Procedure
Collapse All Expand All
iVend Database Database : Loy_GetTransactionLineItem 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 |
@RETURN_VALUE |
Return Value |
|
Integer |
4 |
Objects that Loy_GetTransactionLineItem depends on
|
Database Object |
Object Type |
Description |
Dep Level |
|
Table |
Stores the product related details. |
1 |
|
|
Table |
Stores sale/refund/delivery items attached to a transaction |
1 |
Procedure Source Code
CREATE PROCEDURE [dbo].[Loy_GetTransactionLineItem] @TransactionKey nvarchar(50) AS BEGIN SELECT TransactionItemKey,TransactionKey,[Type],trxTransactionSaleItem.ProductKey,ProductGroupKey,HasDiscounts ,OriginalPrice,Price,PriceSource,Quantity ,DiscountAmount,DiscountPercent,TotalBeforeSaleDiscount,TotalPostSaleDiscount ,IsExchange,IsPromotionApplied,PromotionalQuantity,HasDiscountOverride,OriginalDocumentKey,OriginalDetailKey, (CASE(OriginalPrice-Price) WHEN 0 THEN 0 ELSE OriginalPrice-Price END) AS PriceOverrideAmount,OriginalDocumentKey,OriginalDetailKey FROM trxTransactionSaleItem INNER JOIN InvProduct On trxTransactionSaleItem.ProductKey = InvProduct.ProductKey WHERE TransactionKey = @TransactionKey END |
See Also
Related Objects
© 2019 All Rights Reserved.
Send comments on this topic.