UFN_SALESDEPOSITPROCESS_GETNAME

This function returns the name of the sales deposit process given the process ID.

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SALESDEPOSITPROCESS_GETNAME
            (
                @ID uniqueidentifier
            )
            returns nvarchar(100)
            with execute as caller
            as begin            
                declare @SALESDEPOSITPROCESSNAME nvarchar(100)
                select @SALESDEPOSITPROCESSNAME = [NAME]
                from dbo.[SALESDEPOSITPROCESS]
                where [ID] = @ID;

                return @SALESDEPOSITPROCESSNAME;
            end