UFN_PLEDGE_CALCULATEEARNEDINCOMEAMOUNT

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

                select @EARNEDAMOUNT = 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.TYPECODE in (2,18) 
                    and REVENUESPLIT_EXT.APPLICATIONCODE in (5, 18)

                return @EARNEDAMOUNT
            end