USP_BBNC_CONSTITGIFTDATA

            CREATE procedure dbo.USP_BBNC_CONSTITGIFTDATA(@ID int, @SOFTCREDIT bit)
            as

                set nocount on;

                if @SOFTCREDIT = 0
                    select
                        BBNCREVENUESPLITIDMAP.ID, 
                        REVENUE.DATE,
                        REVENUESPLIT.AMOUNT,
                        REVENUE.TRANSACTIONTYPE,
                        REVENUEPAYMENTMETHOD.PAYMENTMETHOD,
                        REVENUEBBNC.NETCOMMUNITYTRANSACTIONID
                    from
                        dbo.REVENUESPLIT
                        inner join dbo.REVENUE on REVENUESPLIT.REVENUEID = REVENUE.ID
                        inner join dbo.REVENUEPAYMENTMETHOD on REVENUE.ID = REVENUEPAYMENTMETHOD.REVENUEID
                        inner join dbo.BBNCREVENUESPLITIDMAP on REVENUESPLIT.ID = BBNCREVENUESPLITIDMAP.REVENUESPLITID
                        left join dbo.REVENUEBBNC on REVENUE.ID = REVENUEBBNC.ID
                    where
                        BBNCREVENUESPLITIDMAP.ID = @ID
                else
                    select
                        BBNCREVENUERECOGNITIONIDMAP.ID, 
                        REVENUERECOGNITION.EFFECTIVEDATE,
                        REVENUERECOGNITION.AMOUNT, /*JamesWill CR272361-041007 2007/04/11 Return the soft credit amount and not the gift amount*/
                        REVENUE.TRANSACTIONTYPE,
                        REVENUEPAYMENTMETHOD.PAYMENTMETHOD,
                        REVENUEBBNC.NETCOMMUNITYTRANSACTIONID
                    from
                        dbo.REVENUERECOGNITION
                        inner join dbo.REVENUESPLIT on REVENUERECOGNITION.REVENUESPLITID = REVENUESPLIT.ID
                        inner join dbo.REVENUE on REVENUESPLIT.REVENUEID = REVENUE.ID
                        inner join dbo.REVENUEPAYMENTMETHOD on REVENUE.ID = REVENUEPAYMENTMETHOD.REVENUEID
                        inner join dbo.BBNCREVENUERECOGNITIONIDMAP on REVENUERECOGNITION.ID = BBNCREVENUERECOGNITIONIDMAP.REVENUERECOGNITIONID
                        left join dbo.REVENUEBBNC on REVENUE.ID = REVENUEBBNC.ID
                    where
                        -- Gift, Pledge or Recurring Gift Payments

                        BBNCREVENUERECOGNITIONIDMAP.ID = @ID;