UFN_CREDIT_REFUND_GETMEMBERSHIPANDADDONTOTAL

CREATE function dbo.UFN_CREDIT_REFUND_GETMEMBERSHIPANDADDONTOTAL
(
    @CREDITID uniqueidentifier
)
returns money
as begin
    declare @MEMBERSHIPTOTAL money;

    select @MEMBERSHIPTOTAL = coalesce(sum((LI.QUANTITY * LI.UNITVALUE) - EXT.DISCOUNTS), 0)
    from dbo.FINANCIALTRANSACTIONLINEITEM as LI
    inner join dbo.CREDITITEM_EXT as EXT on EXT.ID = LI.ID
    where 
        LI.FINANCIALTRANSACTIONID = @CREDITID and
        EXT.TYPECODE in (1, 16)  -- Membership, Membership add-on


    return @MEMBERSHIPTOTAL;
end