USP_DATALIST_BANKACCOUNTDEPOSITCREDITPAYMENT

This lists bank account deposit refund payments.
Parameters

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

Copy


                CREATE procedure dbo.USP_DATALIST_BANKACCOUNTDEPOSITCREDITPAYMENT
                (
                    @DEPOSITID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        [CREDIT].[ID],
                        [CREDIT].[TRANSACTIONDATE] as [DATE],
                        [CREDITPAYMENT].[AMOUNT],
                        [CREDITPAYMENT].[PAYMENTMETHOD],
                        case [CREDITPAYMENT].[PAYMENTMETHODCODE]
                            when 2 then (
                                select dbo.UFN_CREDITTYPECODE_GETDESCRIPTION([CREDITCARDPAYMENTMETHODDETAIL].[CREDITTYPECODEID])  + ' #' + [CREDITCARDPAYMENTMETHODDETAIL].[CREDITCARDPARTIALNUMBER]
                                from dbo.[CREDITCARDPAYMENTMETHODDETAIL] 
                                inner join dbo.[REVENUEPAYMENTMETHOD]
                                    on [CREDITCARDPAYMENTMETHODDETAIL].[ID] = [REVENUEPAYMENTMETHOD].[ID]
                                where [REVENUEPAYMENTMETHOD].[REVENUEID] = [CREDITPAYMENT].[REVENUEID]
                            )
                            else ''
                        end as [REFERENCE]
                        ,CREDITPAYMENT.ID [CREDITPAYMENTID]
                    from dbo.[CREDITPAYMENT]
                    inner join dbo.[BANKACCOUNTDEPOSITCREDITPAYMENT] 
                        on [BANKACCOUNTDEPOSITCREDITPAYMENT].[ID] = [CREDITPAYMENT].[ID]
                    inner join dbo.[CREDIT]
                        on [CREDITPAYMENT].[CREDITID] = [CREDIT].[ID]
                    where [BANKACCOUNTDEPOSITCREDITPAYMENT].[DEPOSITID] = @DEPOSITID
                    order by [CREDIT].[TRANSACTIONDATE] desc