USP_DATALIST_PLEDGEREMINDERSENTBYTRANSACTION

Returns a list of pledge reminder history for a specific pledge by transaction ID.

Parameters

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

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_PLEDGEREMINDERSENTBYTRANSACTION
            (
                @TRANSACTIONID uniqueidentifier = null
            )
            as
                set nocount on;

                select
                    PLEDGEREMINDERSENT.ID,
                    PLEDGEREMINDERSENT.CREATEDON,
                    PLEDGEREMINDERSENT.AMOUNTDUEDATE,
                    PLEDGEREMINDERSENT.AMOUNTDUE,
                    PLEDGEREMINDERSENT.SENTDATE,
                    isnull(REVENUE_EXT.NONPOSTABLEBASECURRENCYID, CURRENCYSET.BASECURRENCYID) BASECURRENCYID,
                    REVENUE.TRANSACTIONCURRENCYID
                from
                    dbo.PLEDGEREMINDERSENT
                    inner join dbo.FINANCIALTRANSACTION REVENUE on REVENUE.ID = PLEDGEREMINDERSENT.REVENUEID
                    inner join dbo.REVENUE_EXT on REVENUE.ID = REVENUE_EXT.ID
                    inner join dbo.PDACCOUNTSYSTEM on REVENUE.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
                    inner join dbo.CURRENCYSET on PDACCOUNTSYSTEM.CURRENCYSETID = CURRENCYSET.ID
                where
                    REVENUE.ID = @TRANSACTIONID
                order by 
                    PLEDGEREMINDERSENT.DATEADDED;