UFN_REVENUE_GETPAYMENTFROMRECURRINGGIFTACTIVITY

Returns the REVENUEID of a recurring gift template for a Recurring Gift Activity ID

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@TEMPLATEID	uniqueidentifier	IN
@TRANSACTIONID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_REVENUE_GETPAYMENTFROMRECURRINGGIFTACTIVITY
            (
                @TEMPLATEID uniqueidentifier, 
                @TRANSACTIONID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                declare @r uniqueidentifier 

                select top 1 @r = PAY.REVENUEID
                from dbo.RECURRINGGIFTACTIVITY
                inner join dbo.REVENUESPLIT PAY
                    on PAYMENTREVENUEID = PAY.ID
                where SOURCEREVENUEID = @TEMPLATEID and PAY.ID = @TRANSACTIONID

                return @r
            end