USP_REVENUE_GETDETAILSFORCREDITCARDREFUND

Returns revenue details used to issue a credit card refund.

Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@TRANSACTIONID	uniqueidentifier	INOUT
@AMOUNT	money	INOUT

Definition

Copy



            CREATE procedure dbo.USP_REVENUE_GETDETAILSFORCREDITCARDREFUND
            (
                @REVENUEID uniqueidentifier,
                @TRANSACTIONID uniqueidentifier output,
                @AMOUNT money output
            )
            as
            begin
                set nocount on

                select
                    @AMOUNT = REVENUE.TRANSACTIONAMOUNT,
                    @TRANSACTIONID = CREDITCARDPAYMENTMETHODDETAIL.TRANSACTIONID
                from dbo.REVENUE
                inner join dbo.REVENUEPAYMENTMETHOD on REVENUE.ID = REVENUEPAYMENTMETHOD.REVENUEID
                inner join dbo.CREDITCARDPAYMENTMETHODDETAIL on REVENUEPAYMENTMETHOD.ID = CREDITCARDPAYMENTMETHODDETAIL.ID
                where
                    REVENUE.ID = @REVENUEID
            end