UFN_PLEDGEWRITEOFFBATCH_GETRECOGNITIONCREDITS

            CREATE function dbo.UFN_PLEDGEWRITEOFFBATCH_GETRECOGNITIONCREDITS
            (
                @BATCHROWID uniqueidentifier,
        @REVENUEID uniqueidentifier
            )
            returns table
            as
            return (

select REVENUERECOGNITION.ID
                ,FINANCIALTRANSACTIONLINEITEM.ID as REVENUESPLITID
                ,dbo.UFN_DESIGNATION_BUILDNAME(REVENUESPLIT_EXT.DESIGNATIONID) as DESIGNATIONNAME
                ,CONSTITUENT.name as CONSTITUENTNAME
                ,REVENUERECOGNITIONTYPECODE.DESCRIPTION as RECOGNITIONCREDITTYPE
                ,REVENUERECOGNITION.EFFECTIVEDATE
                ,REVENUERECOGNITION.AMOUNT as ORIGINALAMOUNT
                ,COALESCE(B.AMOUNT,REVENUERECOGNITION.AMOUNT) as ADJUSTEDAMOUNT
                ,REVENUERECOGNITION.BASECURRENCYID
            from dbo.FINANCIALTRANSACTION
            inner join dbo.REVENUE_EXT on FINANCIALTRANSACTION.ID = REVENUE_EXT.ID
            inner join dbo.FINANCIALTRANSACTIONLINEITEM on FINANCIALTRANSACTION.ID = FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID
            inner join dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
            inner join dbo.REVENUERECOGNITION on FINANCIALTRANSACTIONLINEITEM.ID = REVENUERECOGNITION.REVENUESPLITID
            inner join dbo.CONSTITUENT on REVENUERECOGNITION.CONSTITUENTID = CONSTITUENT.ID      
            left join dbo.REVENUERECOGNITIONTYPECODE on REVENUERECOGNITION.REVENUERECOGNITIONTYPECODEID = REVENUERECOGNITIONTYPECODE.ID
      left join dbo.BATCHPLEDGEWRITEOFFRECOGNITIONCREDITS B on REVENUESPLIT_EXT.ID=B.REVENUESPLITID and B.BATCHPLEDGEWRITEOFFID = @BATCHROWID
            where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @REVENUEID
                and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null
                and FINANCIALTRANSACTIONLINEITEM.TYPECODE <> 1
            )