USP_DATALIST_SALESRECONCILIATIONREPORT_USERINFORMATION

Returns list of sales made by users.

Parameters

Parameter	Parameter Type	Mode	Description
@RECONCILIATIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@ISSUPERVISOR	bit	IN	Is supervisor

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_SALESRECONCILIATIONREPORT_USERINFORMATION
            (
                @RECONCILIATIONID uniqueidentifier,
        @ISSUPERVISOR bit = 0
            )
            as
                set nocount on;

                select 
                    dbo.UFN_APPUSER_GETNAME([APPUSER].[ID]) as [USERNAME],
                    [RECONCILIATION].[RECONCILIATIONDATE],
                    coalesce([RECONCILIATION].[COMMENT], '') as [COMMENT],
          @ISSUPERVISOR as [ISSUPERVISOR]
                from dbo.[RECONCILIATION]
                inner join dbo.[APPUSER]
                    on [APPUSER].[ID] = [RECONCILIATION].[APPUSERID]
                where [RECONCILIATION].[ID] = @RECONCILIATIONID