UFN_REVENUE_GETORDEREDDETAILS

            CREATE function dbo.UFN_REVENUE_GETORDEREDDETAILS
            (
                @TRANSACTIONID uniqueidentifier
            )
            returns table
            as 
            return
            (
                select 
                    row_number() over (order by FINANCIALTRANSACTION.BASEAMOUNT desc) as ROWNUMBER, 
                    FINANCIALTRANSACTION.ID as DETAILID, 
                    FINANCIALTRANSACTION.BASEAMOUNT as AMOUNT, 
                    REVENUE_EXT.RECEIPTAMOUNT,
                    FINANCIALTRANSACTION.TYPE as TRANSACTIONTYPE,
                    APPEAL.NAME as APPEALNAME,
                    REVENUE_EXT.BENEFITSWAIVED
                from 
                    dbo.FINANCIALTRANSACTION
                inner join
                    dbo.REVENUE_EXT on FINANCIALTRANSACTION.ID = REVENUE_EXT.ID
                left join
                    dbo.APPEAL on REVENUE_EXT.APPEALID = APPEAL.ID
                where 
                    FINANCIALTRANSACTION.ID = @TRANSACTIONID and FINANCIALTRANSACTION.DELETEDON is null
            )