UFN_REVENUE_GETPAYMENTFROMREGISTRANT

Returns the REVENUEID of an event registration fee for a REGISTRANTID of a registration and the REVENUEID used to make the payment.

Return

Return Type
uniqueidentifier

Parameters

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

Definition

Copy



            CREATE function dbo.UFN_REVENUE_GETPAYMENTFROMREGISTRANT
            (
                @REGISTRANTID uniqueidentifier,
                @TRANSACTIONID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                declare @r uniqueidentifier;

                select top 1 @r = EVENTREGISTRANTPAYMENT.PAYMENTID
                from dbo.EVENTREGISTRANTPAYMENT
                inner join dbo.REVENUESPLIT on REVENUESPLIT.ID = EVENTREGISTRANTPAYMENT.PAYMENTID 
                inner join dbo.REVENUE on REVENUE.ID = REVENUESPLIT.REVENUEID
                where REVENUE.ID = @TRANSACTIONID and EVENTREGISTRANTPAYMENT.REGISTRANTID = @REGISTRANTID;

                return @r;
            end