UFN_REVENUE_GETMATCHINGGIFTS

            CREATE function dbo.UFN_REVENUE_GETMATCHINGGIFTS
            (
                @ID uniqueidentifier
            )
            returns @RESULT table
            (
                ID uniqueidentifier,
                ORGANIZATIONID uniqueidentifier, 
                MATCHAMOUNT money,
                MATCHDATE datetime,
                DESIGNATIONS nvarchar(max),
                POSTSTATUSCODE tinyint,
                TRANSACTIONID uniqueidentifier
            )
            as
            begin
                insert into @RESULT 

                select 
                    REVENUE.ID as [ID],
                    REVENUE.CONSTITUENTID,
                    REVENUE.AMOUNT,
                    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,
                    REVENUE.ID
                from 
                    dbo.REVENUE
                left join dbo.REVENUEPOSTED on REVENUEPOSTED.ID = REVENUE.ID
                inner join dbo.REVENUEMATCHINGGIFT RMG on REVENUE.ID = RMG.ID
                where 
                    RMG.MGSOURCEREVENUEID = @ID
                order by
                    REVENUE.DATE;
            return;
        end