UFN_PLEDGE_CALCULATECONTRIBUTEDINCOMEAMOUNT

            CREATE function dbo.UFN_PLEDGE_CALCULATECONTRIBUTEDINCOMEAMOUNT
            (
                @PLEDGEID uniqueidentifier
            )
            returns money
            with execute as caller
            as begin
                declare @CONTRIBUTEDAMOUNT money = 0

                select @CONTRIBUTEDAMOUNT = sum(FINANCIALTRANSACTIONLINEITEM.TRANSACTIONAMOUNT)
                from dbo.FINANCIALTRANSACTIONLINEITEM
                inner join dbo.REVENUESPLIT_EXT on REVENUESPLIT_EXT.ID = FINANCIALTRANSACTIONLINEITEM.ID
                where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @PLEDGEID
                    and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null
                    and FINANCIALTRANSACTIONLINEITEM.TYPECODE <> 1
                    and REVENUESPLIT_EXT.DESIGNATIONID is not null

                return @CONTRIBUTEDAMOUNT
            end