USP_DATALIST_REVENUE_MATCHINGGIFTS

                CREATE procedure dbo.USP_DATALIST_REVENUE_MATCHINGGIFTS 
                (
                    @ID uniqueidentifier
                )
                as 
                set nocount on;

                    select 
                        REVENUE.ID,
                        CONSTITUENT.NAME,
                        REVENUE.TRANSACTIONAMOUNT,
                        REVENUE.DATE,
                        dbo.UFN_REVENUE_DESIGNATIONLIST(REVENUE.ID),
                        case 
                            when REVENUE.DONOTPOST = 1 
                                then 2 
                            when REVENUEPOSTED.ID is not null 
                                then 0 
                            else 1 
                        end POSTSTATUSCODE,
                        MATCHINGGIFTCONDITIONTYPECODE.DESCRIPTION as CONDITION,
                        REVENUE.TRANSACTIONCURRENCYID
                    from dbo.REVENUE
                        left join dbo.REVENUEPOSTED on REVENUEPOSTED.ID = REVENUE.ID
                        inner join dbo.CONSTITUENT on CONSTITUENT.ID = REVENUE.CONSTITUENTID
                        inner join dbo.REVENUEMATCHINGGIFT on REVENUE.ID = REVENUEMATCHINGGIFT.ID
                        left outer join dbo.MATCHINGGIFTCONDITION on MATCHINGGIFTCONDITION.ID = REVENUEMATCHINGGIFT.MATCHINGGIFTCONDITIONID
                        left outer join dbo.MATCHINGGIFTCONDITIONTYPECODE on MATCHINGGIFTCONDITIONTYPECODE.ID = MATCHINGGIFTCONDITION.MATCHINGGIFTCONDITIONTYPECODEID
                    where REVENUEMATCHINGGIFT.MGSOURCEREVENUEID = @ID
                    order by REVENUE.DATE;