USP_REPORT_REVENUEBATCHEXCEPTIONREPORT

            CREATE procedure dbo.USP_REPORT_REVENUEBATCHEXCEPTIONREPORT(@BATCHID uniqueidentifier) with execute as owner
            as

                declare @TABLENAME nvarchar(128);

                set nocount on;

                declare @CURRENCYFIELD nvarchar(100);

                select @TABLENAME = dbo.UFN_BATCH_GETREPORTTABLENAME(@BATCHID, 1)

                if exists(select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = @TABLENAME and COLUMN_NAME = 'CURRENCYID')
                    select @CURRENCYFIELD = 'CURRENCYID';
                else
                    set @CURRENCYFIELD = '''' + cast(coalesce(dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY(), '00000000-0000-0000-0000-000000000000') as nvarchar(36)) + '''';

                declare @SQLTOEXEC nvarchar(max);

                set @SQLTOEXEC = N'set nocount on;            
                    with TBL_CTE as
                    (
                    select 
                        ' + @CURRENCYFIELD + ' as REVENUECURRENCYID,
                        ORIGINALBATCHNUMBER, 
                        BATCHNUMBER, 
                        OWNER, 
                        ISPAYMENT, 
                        ISPLEDGE, 
                        ISRECURRINGGIFT, 
                        PAYMENTAMOUNT,
                        PLEDGEAMOUNT, 
                        RECURRINGGIFTAMOUNT, 
                        ID, 
                        CONSTITUENTNAME, 
                        CONSTITUENTLOOKUPID, 
                        DATE, 
                        TYPE, 
                        AMOUNT, 
                        PAYMENTMETHOD, 
                        REASON,
                        REVENUELOOKUPID
                    from ' + @TABLENAME + '
                    )
                    select 
                        VIEWDATA.ORIGINALBATCHNUMBER, 
                        VIEWDATA.BATCHNUMBER, 
                        VIEWDATA.OWNER, 
                        VIEWDATA.ISPAYMENT, 
                        VIEWDATA.ISPLEDGE, 
                        VIEWDATA.ISRECURRINGGIFT, 
                        VIEWDATA.PAYMENTAMOUNT,
                        VIEWDATA.PLEDGEAMOUNT, 
                        VIEWDATA.RECURRINGGIFTAMOUNT, 
                        VIEWDATA.ID, 
                        VIEWDATA.CONSTITUENTNAME, 
                        VIEWDATA.CONSTITUENTLOOKUPID, 
                        VIEWDATA.DATE, 
                        VIEWDATA.TYPE, 
                        VIEWDATA.AMOUNT, 
                        VIEWDATA.PAYMENTMETHOD, 
                        VIEWDATA.REASON,
                        CURRENCY.ISO4217,
                        CURRENCY.DECIMALDIGITS,
                        CURRENCY.CURRENCYSYMBOL,
                        CURRENCY.SYMBOLDISPLAYSETTINGCODE,
                        VIEWDATA.REVENUELOOKUPID
                    from TBL_CTE VIEWDATA
                    inner join dbo.CURRENCY on CURRENCY.ID = VIEWDATA.REVENUECURRENCYID';

                exec sp_executesql @SQLTOEXEC;