UFN_DONORCHALLENGE_MATCHEDAMOUNT

            create function dbo.UFN_DONORCHALLENGE_MATCHEDAMOUNT(@ID uniqueidentifier) returns money 
            as
            begin

              declare @AMOUNT money;

              set @AMOUNT = coalesce((select coalesce(sum(DONORCHALLENGEENCUMBERED.AMOUNT),0) from dbo.DONORCHALLENGEENCUMBERED 
                                    inner join dbo.REVENUESPLIT on DONORCHALLENGEENCUMBERED.REVENUESPLITID = REVENUESPLIT.ID
                                    inner join dbo.REVENUE on REVENUESPLIT.REVENUEID = REVENUE.ID
                                    where DONORCHALLENGEENCUMBERED.DONORCHALLENGEID = @ID and DONORCHALLENGEENCUMBERED.STATUSTYPECODE = 1 and REVENUE.TRANSACTIONTYPECODE <> 1), 0);
              return @AMOUNT;
            end