USP_SIMPLEDATALIST_RESERVATIONSECURITYDEPOSIT_REFUNDMETHOD

Gets available refund methods of security deposit refund.
Parameters

Parameter	Parameter Type	Mode	Description
@RESERVATIONID	uniqueidentifier	IN
Definition

Copy


                create procedure dbo.USP_SIMPLEDATALIST_RESERVATIONSECURITYDEPOSIT_REFUNDMETHOD
                    (
                        @RESERVATIONID uniqueidentifier
                    )
                    as
                        select '00000000-0000-0000-0000-000000000001' as [VALUE], 'Check' as [LABEL]

                        union all

                        select
                            [REVENUE].[ID] as [VALUE],
                            case 
                                when [REVENUE].[AMOUNT] < (select sum(AMOUNT) from dbo.RESERVATIONSECURITYDEPOSITPAYMENT where RESERVATIONID = RESERVATION.ID)
                                then dbo.UFN_CREDITTYPECODE_GETDESCRIPTION([CREDITCARDPAYMENTMETHODDETAIL].[CREDITTYPECODEID]) + ' #' + [CREDITCARDPAYMENTMETHODDETAIL].[CREDITCARDPARTIALNUMBER] +
                            ' ($' + cast([REVENUE].[AMOUNT]  as nvarchar(20)) + ' maximum)'
                                else dbo.UFN_CREDITTYPECODE_GETDESCRIPTION([CREDITCARDPAYMENTMETHODDETAIL].[CREDITTYPECODEID]) + ' #' + [CREDITCARDPAYMENTMETHODDETAIL].[CREDITCARDPARTIALNUMBER]
                            end as [LABEL]

                        from dbo.[RESERVATION]
                        inner join dbo.[RESERVATIONSECURITYDEPOSITPAYMENT] on [RESERVATIONSECURITYDEPOSITPAYMENT].[RESERVATIONID] = [RESERVATION].[ID]
                        inner join dbo.[REVENUE] on [RESERVATIONSECURITYDEPOSITPAYMENT].[PAYMENTID] = [REVENUE].[ID]
                        inner join dbo.[REVENUEPAYMENTMETHOD] on [REVENUE].[ID] = [REVENUEPAYMENTMETHOD].[REVENUEID]
                        inner join dbo.[CREDITCARDPAYMENTMETHODDETAIL] on [CREDITCARDPAYMENTMETHODDETAIL].[ID] = [REVENUEPAYMENTMETHOD].[ID]
                        where [RESERVATION].[ID] = @RESERVATIONID