UFN_MEMBERSHIPTRANSACTION_RAISEDBYAPPEAL

            CREATE function dbo.UFN_MEMBERSHIPTRANSACTION_RAISEDBYAPPEAL
            (@STARTDATE datetime, @ENDDATE datetime)
            returns @MTREVENUEINFO table
            (
                APPEALID uniqueidentifier NOT NULL,
                MTACTION tinyint NOT NULL,
                MTTOTALRECEIVED money NOT NULL
            )
            as
            begin

                select @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(@STARTDATE),
                        @ENDDATE = dbo.UFN_DATE_GETLATESTTIME(@ENDDATE);

                insert into @MTREVENUEINFO
                    select REVENUE_EXT.APPEALID, MT.ACTIONCODE, coalesce(sum(RS.BASEAMOUNT), 0) MTTOTALRECEIVED
                    from MEMBERSHIPTRANSACTION MT 
                    inner join dbo.FINANCIALTRANSACTIONLINEITEM RS on MT.REVENUESPLITID = RS.ID
                    inner join dbo.FINANCIALTRANSACTION R on R.ID = RS.FINANCIALTRANSACTIONID
                    inner join dbo.REVENUE_EXT on REVENUE_EXT.ID = R.ID
                    where (REVENUE_EXT.APPEALID is not null) and (cast(R.DATE as datetime) >= @STARTDATE or @STARTDATE is null) and
                        (cast(R.DATE as datetime) <= @ENDDATE or @ENDDATE is null)
                        and RS.TYPECODE <> 1
                        and R.DELETEDON is null 
                        and RS.DELETEDON is null
                    group by REVENUE_EXT.APPEALID, MT.ACTIONCODE

                return;

            end