USP_DATALIST_RECURRINGHISTORYBYTRANSACTION2

            create procedure dbo.USP_DATALIST_RECURRINGHISTORYBYTRANSACTION2 @ID uniqueidentifier, @INCLUDEBITMASK int = 255
            as
                set @INCLUDEBITMASK = coalesce(@INCLUDEBITMASK, 255)

                select 
                    RGA.[TYPE] as ACTIVITYTYPE, 
                    RGA.SCHEDULEDATE, 
                    case when RGA.TYPECODE = 0 then sum(RGA.AMOUNT) else null end as AMOUNT, 
                    case when RGA.TYPECODE = 0 then REVENUE.DATE else null end as PAYMENTDATE,
                    REVENUE.ID as PAYMENTID
                from RECURRINGGIFTACTIVITY RGA
                    left outer join REVENUESPLIT
                        on RGA.PAYMENTREVENUEID = REVENUESPLIT.ID
                    left outer join dbo.REVENUE
                        on REVENUESPLIT.REVENUEID = REVENUE.ID
                where RGA.SOURCEREVENUEID = @ID and
                    1 = case RGA.[TYPECODE]
                            when 0 then --PAY

                                case when (@INCLUDEBITMASK & 1 > 0) then 1 else 0 end
                            when 1 then --SKIP

                                case when (@INCLUDEBITMASK & 2 > 0) then 1 else 0 end
                            when 2 then --ROLLBACK

                                case when (@INCLUDEBITMASK & 4 > 0) then 1 else 0 end
                        end
                group by REVENUE.ID, RGA.TYPECODE, RGA.TYPE, RGA.SCHEDULEDATE, REVENUE.DATE
                order by RGA.SCHEDULEDATE