USP_REVENUE_DELETEPOSTED_PROMPT

            CREATE procedure dbo.USP_REVENUE_DELETEPOSTED_PROMPT
            (
              @ID uniqueidentifier,
              @REVENUETYPE nvarchar(50) output
            )
            as
            set nocount on;

        select @REVENUETYPE = lower(TYPE) from dbo.FINANCIALTRANSACTION where ID = @ID;