USP_REVENUEUPDATEBATCH_VALIDATIONREPORT_SUMMARY

            CREATE procedure dbo.USP_REVENUEUPDATEBATCH_VALIDATIONREPORT_SUMMARY
            (
                @BATCHID nvarchar(255)
            )
            as
            set nocount on;

            declare @MULTICURRENCYENABLED bit = dbo.UFN_CONDITIONSETTING_EVALUATEEXISTSCONDITION('Multicurrency');
            declare 
                @ORGANIZATIONISO4217 nvarchar(3),
                @ORGANIZATIONDECIMALDIGITS tinyint,
                @ORGANIZATIONCURRENCYSYMBOL nvarchar(5),
                @ORGANIZATIONSYMBOLDISPLAYSETTINGCODE tinyint;

            select
                @ORGANIZATIONISO4217 = ISO4217,
                @ORGANIZATIONDECIMALDIGITS = DECIMALDIGITS,
                @ORGANIZATIONCURRENCYSYMBOL  = CURRENCYSYMBOL,
                @ORGANIZATIONSYMBOLDISPLAYSETTINGCODE = SYMBOLDISPLAYSETTINGCODE
            from dbo.CURRENCY
            where ISORGANIZATIONCURRENCY = 1

            select
                BATCH.BATCHNUMBER,
                BATCH.STATUS,
                (select APPUSER.USERNAME from dbo.APPUSER where ID = BATCH.APPUSERID) as [OWNER],
                BATCH.PROJECTEDNUMBEROFRECORDS,
                BATCH.PROJECTEDTOTALAMOUNT,
                coalesce((select count(ID) from dbo.BATCHREVENUE where BATCHID = @BATCHID),0) as [CURRENTNUMBEROFRECORDS],
                coalesce((select sum(AMOUNT) from dbo.BATCHREVENUE where BATCHID = @BATCHID),0) as [CURRENTTOTALAMOUNT],
                @MULTICURRENCYENABLED MULTICURRENCYENABLED,
                @ORGANIZATIONISO4217 ORGANIZATIONISO4217,
                @ORGANIZATIONDECIMALDIGITS ORGANIZATIONDECIMALDIGITS,
                @ORGANIZATIONCURRENCYSYMBOL ORGANIZATIONCURRENCYSYMBOL,
                @ORGANIZATIONSYMBOLDISPLAYSETTINGCODE ORGANIZATIONSYMBOLDISPLAYSETTINGCODE
            from dbo.BATCH
            where BATCH.ID = @BATCHID