USP_SIMPLEDATALIST_ORDERPAYMETNS

                CREATE procedure dbo.USP_SIMPLEDATALIST_ORDERPAYMETNS(
                    @SALESORDERID uniqueidentifier
                )

                as
                    set nocount on;

                    select 
                        SELECTIONID as VALUE, 
                        case 
                            when PAYMENTTYPECODE = 0 then
                                (select distinct PAYMENTMETHOD from REVENUEPAYMENTMETHOD where PAYMENTMETHODCODE = 0)
                            when PAYMENTTYPECODE = 2 then
                                (select dbo.UFN_CREDITTYPECODE_GETDESCRIPTION(CREDITCARDPAYMENTMETHODDETAIL.CREDITTYPECODEID) + ' #' + CREDITCARDPAYMENTMETHODDETAIL.CREDITCARDPARTIALNUMBER
                                    from dbo.CREDITCARDPAYMENTMETHODDETAIL
                                    inner join REVENUEPAYMENTMETHOD  on REVENUEPAYMENTMETHOD.ID = CREDITCARDPAYMENTMETHODDETAIL.ID
                                    where REVENUEPAYMENTMETHOD.REVENUEID = SELECTIONID )
                            when PAYMENTTYPECODE = 10 then
                                dbo.UFN_OTHERPAYMENTMETHODCODE_GETDESCRIPTION(SELECTIONID)
                            else  --Should never reach this code--

                                'Other'
                        end LABEL

                    from dbo.UFN_CREDIT_GETORDERPAYMENTS(@SALESORDERID) ORDERPAYMENTS
                    where AMOUNT > 0
                    order by PAYMENTTYPECODE, AMOUNT

                return 0;