USP_DATALIST_PLEDGEREMINDERSENT

Returns a list of pledge reminder history for a specific pledge.

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_PLEDGEREMINDERSENT
            (
                @REVENUEID uniqueidentifier = null
            )
            as
                set nocount on;

                select
                    PLEDGEREMINDERSENT.ID,
                    PLEDGEREMINDERSENT.CREATEDON,
                    PLEDGEREMINDERSENT.AMOUNTDUEDATE,
                    PLEDGEREMINDERSENT.AMOUNTDUE,
                    PLEDGEREMINDERSENT.SENTDATE
                from
                    dbo.PLEDGEREMINDERSENT
                    inner join dbo.REVENUE on REVENUE.ID = PLEDGEREMINDERSENT.REVENUEID
                where
                    REVENUE.ID = @REVENUEID
                order by 
                    PLEDGEREMINDERSENT.DATEADDED;