UFN_CREDIT_REFUND_GETDONATIONTOTAL

CREATE function dbo.UFN_CREDIT_REFUND_GETDONATIONTOTAL
(
    @CREDITID uniqueidentifier
)
returns money
as begin
    return (
        select
            sum((LI.QUANTITY * LI.UNITVALUE) - EXT.DISCOUNTS)
        from
            dbo.FINANCIALTRANSACTION as FT
        inner join
            dbo.FINANCIALTRANSACTIONLINEITEM as LI on LI.FINANCIALTRANSACTIONID = FT.ID
        inner join
            dbo.CREDITITEM_EXT as EXT on EXT.ID = LI.ID
        where
            FT.ID = @CREDITID
            and FT.TYPECODE = 23  -- Refund

            and EXT.TYPECODE = 2  -- Donation

    )
end