USP_DATALIST_REVENUERECOGNITIONCREDITS

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

                select 
                    REVENUERECOGNITION.[ID],
                    REVENUERECOGNITION.[CONSTITUENTID],
                    NF.NAME,
                    REVENUERECOGNITION.[AMOUNT],
                    -- If this is a recurring gift, just use the revenue date as the effective date.  If the actual

                    -- recognition effective date were used then the sorting could be off since the effective date isn't displayed

                    -- for that revenue type.

                    case when FINANCIALTRANSACTION.TYPECODE <> 2 then [EFFECTIVEDATE] else cast(FINANCIALTRANSACTION.DATE as datetime) end 'EFFECTIVEDATE',
                    REVENUERECOGNITIONTYPECODE.DESCRIPTION as RECOGNITIONTYPE,
                    REVENUERECOGNITION.BASECURRENCYID,
                    case when FINANCIALTRANSACTIONLINEITEM.BASEAMOUNT > 0  then
                        case when FINANCIALTRANSACTION.TYPECODE = 0 then
                            case when REVENUERECOGNITION.AMOUNT > FINANCIALTRANSACTIONLINEITEM.BASEAMOUNT
                                then dbo.UFN_GIFTAIDREVENUESPLIT_GETSPLITTAXCLAIMAMOUNT_INCURRENCY(FINANCIALTRANSACTIONLINEITEM.ID, 1, isnull(REVENUE_EXT.NONPOSTABLEBASECURRENCYID, CURRENCYSET.BASECURRENCYID)) + REVENUERECOGNITION.AMOUNT 
                            else REVENUERECOGNITION.AMOUNT/FINANCIALTRANSACTIONLINEITEM.BASEAMOUNT * dbo.UFN_GIFTAIDREVENUESPLIT_GETSPLITTAXCLAIMAMOUNT_INCURRENCY(FINANCIALTRANSACTIONLINEITEM.ID, 1, isnull(REVENUE_EXT.NONPOSTABLEBASECURRENCYID, CURRENCYSET.BASECURRENCYID)) + REVENUERECOGNITION.AMOUNT end
                        else REVENUERECOGNITION.AMOUNT end
                    else FINANCIALTRANSACTIONLINEITEM.BASEAMOUNT end as GROSSAMOUNT
                from 
                    dbo.REVENUERECOGNITION
                    inner join dbo.CONSTITUENT on CONSTITUENT.ID = REVENUERECOGNITION.CONSTITUENTID
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF
                    inner join dbo.FINANCIALTRANSACTIONLINEITEM on FINANCIALTRANSACTIONLINEITEM.ID = REVENUERECOGNITION.REVENUESPLITID
                    inner join dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
                    inner join dbo.FINANCIALTRANSACTION on FINANCIALTRANSACTION.ID = FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID
                    inner join dbo.REVENUE_EXT on FINANCIALTRANSACTION.ID = REVENUE_EXT.ID
                    inner join dbo.PDACCOUNTSYSTEM on FINANCIALTRANSACTION.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
                    inner join dbo.CURRENCYSET on PDACCOUNTSYSTEM.CURRENCYSETID = CURRENCYSET.ID
                    left join dbo.REVENUERECOGNITIONTYPECODE on REVENUERECOGNITION.REVENUERECOGNITIONTYPECODEID = REVENUERECOGNITIONTYPECODE.ID
                where 
                    REVENUERECOGNITION.REVENUESPLITID = @ID
                    and FINANCIALTRANSACTION.DELETEDON is null
                    and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null
                    and FINANCIALTRANSACTIONLINEITEM.TYPECODE <> 1
                order by
                    CONSTITUENT.NAME asc, EFFECTIVEDATE asc