UFN_QUERY_PLEDGEREMINDERPROCESSEMAILOUTPUTDETAILS

      CREATE function [dbo].[UFN_QUERY_PLEDGEREMINDERPROCESSEMAILOUTPUTDETAILS]
            (
                @PARAMETERSETID uniqueidentifier = null
            )
        returns table
        as
        return
                (
            select TOP(100) PERCENT
          CONSTITUENTLOOKUPID,
                    REVENUEID,  
                    TOTALPLEDGEAMOUNT,
                    GIVENANONYMOUSLY,
                    PLEDGEDATE,
                    PLEDGEBALANCE,
                    AMOUNTPAID,
                    APPEALNAME,
                    DESIGNATION1NAME,
                    DESIGNATION1PUBLICNAME,
                    DESIGNATION1AMOUNT,
                    DESIGNATION2NAME,
                    DESIGNATION2PUBLICNAME,
                    DESIGNATION2AMOUNT,
                    REVENUELOOKUPID,
                    TRANSACTIONCURRENCYID,
                    TRANSACTIONCURRENCY
      from dbo.UFN_QUERY_PLEDGEREMINDERPROCESSEMAILOUTPUT(@PARAMETERSETID)
      order by CONSTITUENTLOOKUPID
            )