USP_DATALIST_RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY

CREATE procedure dbo.USP_DATALIST_RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY(
    @REVENUEID uniqueidentifier
)
as
    set nocount on;

    select RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY.ID,
         isnull(REVENUEDEVELOPMENTFUNCTIONCODE.DESCRIPTION,'New') DESCRIPTION,
         RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY.TRANSACTIONDATE,
         RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY.TRANSACTIONAMOUNT as AMOUNT,
         RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY.FREQUENCY,
         RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY.TRANSACTIONAMOUNTCHANGE as AMOUNTCHANGE,
         APPEAL.NAME [APPEAL],
         CHANNELCODE.DESCRIPTION [CHANNEL],
         MKTSEGMENTATION.NAME [MAILING],
         RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY.SOURCECODE,
         RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY.TRANSACTIONCURRENCYID as DISPLAYCURRENCYID
    from dbo.RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY
    left join dbo.REVENUEDEVELOPMENTFUNCTION on REVENUEDEVELOPMENTFUNCTION.ID = RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY.REVENUEDEVELOPMENTFUNCTIONID
    left join dbo.REVENUEDEVELOPMENTFUNCTIONCODE on REVENUEDEVELOPMENTFUNCTIONCODE.ID = REVENUEDEVELOPMENTFUNCTION.REVENUEDEVELOPMENTFUNCTIONCODEID
    left join dbo.APPEAL on APPEAL.ID = RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY.APPEALID
    left join dbo.MKTSEGMENTATION on MKTSEGMENTATION.ID = RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY.MAILINGID
    left join dbo.CHANNELCODE on CHANNELCODE.ID = RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY.CHANNELCODEID
    where RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY.REVENUEID = @REVENUEID
    order by RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY.SEQUENCE;