USP_DATALIST_SALESDEPOSITPROCESS_SUMMARYREPORTREFUND

Lists refund summary information related to a run of the sales deposit process.

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_SUMMARYREPORTREFUND
                (
                    @PROCESSSTATUSID uniqueidentifier
                )
                as
                    set nocount on;

                    declare @TABLENAME nvarchar(255);
                    declare @SQL nvarchar(4000);

                    select @TABLENAME = [BUSINESSPROCESSOUTPUT].[TABLENAME]
                    from dbo.[BUSINESSPROCESSSTATUS]
                    inner join dbo.[BUSINESSPROCESSOUTPUT]
                        on [BUSINESSPROCESSSTATUS].[ID] = [BUSINESSPROCESSOUTPUT].[BUSINESSPROCESSSTATUSID]
                    where [BUSINESSPROCESSSTATUS].[ID] = @PROCESSSTATUSID

                    set @SQL = 'select 
                                    [BANKACCOUNTNAME],
                                    [PAYMENTMETHODCODE],
                                    [PAYMENTMETHOD],
                                    [PAYMENTTYPE],
                                    sum([NUMBEROFPAYMENTS]),
                                    sum([AMOUNT])
                                    from dbo.' + @TABLENAME + '
                                    where [ISREFUND] = 1
                                    group by
                                        [BANKACCOUNTNAME],
                                        [PAYMENTMETHODCODE],
                                        [PAYMENTMETHOD],
                                        [PAYMENTTYPE]
                                    order by
                                        [PAYMENTMETHODCODE],
                                        [PAYMENTMETHOD]';

                    exec sp_executesql @SQL;