UFN_CREDIT_REFUND_GETEVENTREGISTRATIONTOTAL

CREATE function dbo.UFN_CREDIT_REFUND_GETEVENTREGISTRATIONTOTAL
(
    @CREDITID uniqueidentifier
)
returns money
as begin
    declare @EVENTREGISTRATIONTOTAL money;

    select @EVENTREGISTRATIONTOTAL = coalesce(sum((REFUNDLI.QUANTITY * REFUNDLI.UNITVALUE) - CREDITITEM_EXT.DISCOUNTS), 0)
    from dbo.FINANCIALTRANSACTIONLINEITEM as REFUNDLI
    inner join dbo.CREDITITEM_EXT on CREDITITEM_EXT.ID = REFUNDLI.ID
    inner join dbo.FINANCIALTRANSACTIONLINEITEM as REVENUELI on REVENUELI.ID = REFUNDLI.SOURCELINEITEMID
    inner join dbo.REVENUESPLIT_EXT on REVENUESPLIT_EXT.ID = REVENUELI.ID
    where 
        REFUNDLI.FINANCIALTRANSACTIONID = @CREDITID and
        CREDITITEM_EXT.TYPECODE = 6 and  -- Event Registration

        REVENUESPLIT_EXT.TYPECODE = 1  -- Event registration


    return @EVENTREGISTRATIONTOTAL;
end