USP_DATALIST_RECURRINGGIFTWRITEOFFS

This datalist returns a list of write-offs for a recurring gift.

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



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

    select 
        RECURRINGGIFTWRITEOFF.ID,
        RECURRINGGIFTWRITEOFF.DATE,
        (select sum(RECURRINGGIFTINSTALLMENTWRITEOFF.TRANSACTIONAMOUNT) from dbo.RECURRINGGIFTINSTALLMENTWRITEOFF where RECURRINGGIFTINSTALLMENTWRITEOFF.WRITEOFFID = RECURRINGGIFTWRITEOFF.ID) as AMOUNT,
        WRITEOFFREASONCODE.CODE REASONCODE,
        WRITEOFFREASONCODE.DESCRIPTION REASONDESCRIPTION,
        (select top 1 RECURRINGGIFTINSTALLMENTWRITEOFF.TRANSACTIONCURRENCYID from dbo.RECURRINGGIFTINSTALLMENTWRITEOFF where RECURRINGGIFTINSTALLMENTWRITEOFF.WRITEOFFID = RECURRINGGIFTWRITEOFF.ID) as TRANSACTIONCURRENCYID
    from 
        dbo.RECURRINGGIFTWRITEOFF
    left join
        dbo.WRITEOFFREASONCODE on WRITEOFFREASONCODE.ID = RECURRINGGIFTWRITEOFF.REASONCODEID
    where 
        RECURRINGGIFTWRITEOFF.REVENUEID = @REVENUEID
    order by 
        RECURRINGGIFTWRITEOFF.DATE;