USP_REVENUEBATCH_VALIDATIONREPORT

            CREATE procedure dbo.USP_REVENUEBATCH_VALIDATIONREPORT
            (
                @BATCHID uniqueidentifier
            )
            as
            set nocount on;

            select
                coalesce(CONSTITUENT_NF.NAME, BATCHREVENUECONSTITUENT.NAME) NAME,
                coalesce(CONSTITUENT.LOOKUPID, '') LOOKUPID,
                BATCHREVENUE.DATE DATE,
                BATCHREVENUE.TYPE,
                BATCHREVENUE.AMOUNT,
                BATCHREVENUE.PAYMENTMETHOD,
                coalesce((select NAME from dbo.APPEAL where ID = BATCHREVENUE.APPEALID), '') as [APPEAL],
                dbo.UFN_REVENUE_BUILDSPLITLIST_FORBATCHREVENUEID(BATCHREVENUE.ID) as [DESIGNATION],
                coalesce(CONSTITUENT.KEYNAME, BATCHREVENUECONSTITUENT.KEYNAME) KEYNAME,
                coalesce(CONSTITUENT.FIRSTNAME, BATCHREVENUECONSTITUENT.FIRSTNAME) FIRSTNAME,
                coalesce(CONSTITUENT.MIDDLENAME, BATCHREVENUECONSTITUENT.MIDDLENAME) MIDDLENAME,
                CURRENCY.ISO4217,
                CURRENCY.DECIMALDIGITS,
                CURRENCY.CURRENCYSYMBOL,
                CURRENCY.SYMBOLDISPLAYSETTINGCODE
            from dbo.BATCHREVENUE
                inner join dbo.CURRENCY on CURRENCY.ID = BATCHREVENUE.TRANSACTIONCURRENCYID
                left join dbo.CONSTITUENT on CONSTITUENT.ID = BATCHREVENUE.CONSTITUENTID
                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) CONSTITUENT_NF
                left join dbo.BATCHREVENUECONSTITUENT on BATCHREVENUECONSTITUENT.ID = BATCHREVENUE.CONSTITUENTID
            where BATCHREVENUE.BATCHID = @BATCHID
            order by
                BATCHREVENUE.SEQUENCE