USP_SIMPLEDATALIST_ORDERCREDITCARDPAYMENTS

Lists credit card payments for an order.
Parameters

Parameter	Parameter Type	Mode	Description
@ORDERID	uniqueidentifier	IN	ORDERID
Definition

Copy


                create procedure dbo.USP_SIMPLEDATALIST_ORDERCREDITCARDPAYMENTS(@ORDERID uniqueidentifier) as

                select
                    CREDITCARDPAYMENTMETHODDETAIL.ID as VALUE,
                    CREDITTYPECODE.DESCRIPTION + '     ' + '****' + 
                    CREDITCARDPAYMENTMETHODDETAIL.CREDITCARDPARTIALNUMBER + '     ' + 
                    SALESORDERPAYMENT.AMOUNT as LABEL
                from
                    dbo.SALESORDER inner join dbo.SALESORDERPAYMENT 
                        on SALESORDER.ID = SALESORDERPAYMENT.SALESORDERID
                    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
                    inner join dbo.CREDITTYPECODE
                        on CREDITCARDPAYMENTMETHODDETAIL.CREDITTYPECODEID = CREDITTYPECODE.ID
                where 
                    SALESORDER.ID = @ORDERID
                order by
                    SALESORDERPAYMENT.AMOUNT desc