UFN_MISCELLANEOUSPAYMENT_GETDESCRIPTION

            CREATE function dbo.UFN_MISCELLANEOUSPAYMENT_GETDESCRIPTION
            (
                @ID uniqueidentifier
            ) 
            returns nvarchar(500) 
            with execute as caller
            as
            begin
                declare @DESCRIPTION nvarchar(500);

                select 
                    @DESCRIPTION = Cast(REVENUE.TRANSACTIONAMOUNT as nvarchar(20)) + ' ' + 
                                    REVENUE.TRANSACTIONTYPE
                from dbo.REVENUE 
                where REVENUE.ID = @ID;

                return @DESCRIPTION;
            end