USP_DATALIST_ORDERCREDITCARDPAYMENTS

Lists credit card payments for an order.
Parameters

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

Copy


                CREATE procedure dbo.USP_DATALIST_ORDERCREDITCARDPAYMENTS(@SALESORDERID uniqueidentifier, @SALESORDERPAYMENTID uniqueidentifier=null)
                as
                    begin
                        set nocount on;

                        select
                            CREDITCARDPAYMENTMETHODDETAIL.ID CREDITCARDPAYMENTMETHODDETAILID
                        from
                            dbo.SALESORDER inner join dbo.SALESORDERPAYMENT 
                                on SALESORDER.ID = SALESORDERPAYMENT.SALESORDERID and
                                (SALESORDERPAYMENT.PAYMENTID = @SALESORDERPAYMENTID or
                                @SALESORDERPAYMENTID is null)
                            inner join dbo.REVENUE
                                on SALESORDERPAYMENT.PAYMENTID = REVENUE.ID
                            inner join dbo.REVENUEPAYMENTMETHOD 
                                on REVENUE.ID = REVENUEPAYMENTMETHOD.REVENUEID
                            inner join dbo.CREDITCARDPAYMENTMETHODDETAIL on
                                                    REVENUEPAYMENTMETHOD.PAYMENTMETHODCODE = 2 and
                                                    CREDITCARDPAYMENTMETHODDETAIL.ID = REVENUEPAYMENTMETHOD.ID
                        where 
                            SALESORDER.ID = @SALESORDERID                            

            union all

                        select
                            CREDITCARDPAYMENTMETHODDETAIL.ID CREDITCARDPAYMENTMETHODDETAILID
                        from
                            dbo.SALESORDER inner join dbo.RESERVATIONSECURITYDEPOSITPAYMENT 
                                on SALESORDER.ID = RESERVATIONSECURITYDEPOSITPAYMENT.RESERVATIONID and
                                (RESERVATIONSECURITYDEPOSITPAYMENT.PAYMENTID = @SALESORDERPAYMENTID or
                                @SALESORDERPAYMENTID is null)
                            inner join dbo.REVENUE
                                on RESERVATIONSECURITYDEPOSITPAYMENT.PAYMENTID = REVENUE.ID
                            inner join dbo.REVENUEPAYMENTMETHOD 
                                on REVENUE.ID = REVENUEPAYMENTMETHOD.REVENUEID
                            inner join dbo.CREDITCARDPAYMENTMETHODDETAIL on
                                                    REVENUEPAYMENTMETHOD.PAYMENTMETHODCODE = 2 and
                                                    CREDITCARDPAYMENTMETHODDETAIL.ID = REVENUEPAYMENTMETHOD.ID
                        where 
                            SALESORDER.ID = @SALESORDERID                            

                    end