Navigation: iVend Database Database > Stored Procedures >
iVend 6.6 Database Help
Loy_GetTransactionPayment Stored Procedure
Collapse All Expand All
iVend Database Database : Loy_GetTransactionPayment 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_GetTransactionPayment depends on
|
Database Object |
Object Type |
Description |
Dep Level |
|
Table |
Stores all the payment details for each transaction. |
1 |
Procedure Source Code
CREATE PROCEDURE [dbo].[Loy_GetTransactionPayment] @TransactionKey nvarchar(50) AS BEGIN SELECT TransactionPaymentKey,TransactionKey,TenderType, (Amount-ChangeAmount-CashBackAmount-RoundingAmount) as Amount,AccountType FROM trxtransactionpayment WHERE IsVoided=0 and TransactionKey = @TransactionKey END |
See Also
Related Objects
© 2019 All Rights Reserved.
Send comments on this topic.