USP_RESERVATIONSECURITYDEPOSITPAYMENT_GETTRANSACTION

            create procedure dbo.USP_RESERVATIONSECURITYDEPOSITPAYMENT_GETTRANSACTION(
                @SECURITYDEPOSITPAYMENTID uniqueidentifier = null,
                @RESERVATIONID uniqueidentifier = null,
                @FILTERTRANSACTIONLESS bit = 1
            )
            as
            begin
                select
                    [RESERVATIONSECURITYDEPOSITPAYMENT].[ID],
                    [REVENUE].[AMOUNT],
                    [CREDITCARDPAYMENTMETHODDETAIL].[TRANSACTIONID],
                    [SALESORDER].[STATUSCODE] as [ORDERSTATUSCODE]
                from dbo.[RESERVATIONSECURITYDEPOSITPAYMENT]
                inner join dbo.[SALESORDER]
                    on [RESERVATIONSECURITYDEPOSITPAYMENT].[RESERVATIONID] = [SALESORDER].[ID]
                inner join dbo.[REVENUE]
                    on [RESERVATIONSECURITYDEPOSITPAYMENT].[PAYMENTID] = [REVENUE].[ID]
                inner join dbo.[REVENUEPAYMENTMETHOD]
                    on [REVENUE].[ID] = [REVENUEPAYMENTMETHOD].[REVENUEID]
                left join dbo.[CREDITCARDPAYMENTMETHODDETAIL]
                    on [REVENUEPAYMENTMETHOD].[ID] = [CREDITCARDPAYMENTMETHODDETAIL].[ID]
                where 
                    (    
                        @SECURITYDEPOSITPAYMENTID is null or 
                        [RESERVATIONSECURITYDEPOSITPAYMENT].[ID] = @SECURITYDEPOSITPAYMENTID
                    ) and
                    (
                        @RESERVATIONID is null or
                        [SALESORDER].[ID] = @RESERVATIONID
                    ) and
                    (
                        @FILTERTRANSACTIONLESS = 0 or
                        [CREDITCARDPAYMENTMETHODDETAIL].[TRANSACTIONID] is not null
                    )
            end