USP_DATALIST_SALESDEPOSITPROCESS_SUMMARYREPORTPROCESSSTATUS

Lists information related to a sales deposit process run.

Parameters

Parameter	Parameter Type	Mode	Description
@PROCESSSTATUSID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_SALESDEPOSITPROCESS_SUMMARYREPORTPROCESSSTATUS 
                (
                    @PROCESSSTATUSID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        dbo.UFN_SALESDEPOSITPROCESS_GETNAME([BUSINESSPROCESSPARAMETERSETID]) as PROCESSNAME,
                        dbo.UFN_APPUSER_GETNAME([STARTEDBYUSERID]) as STARTEDBY,
                        [STARTEDON],
                        [ENDEDON]
                    from dbo.[BUSINESSPROCESSSTATUS]
                    where [ID] = @PROCESSSTATUSID