USP_SIMPLEDATALIST_SALESMETHODPAYMENTMETHOD

        create procedure dbo.USP_SIMPLEDATALIST_SALESMETHODPAYMENTMETHOD as

            with PAYMENTTYPES_CTE as (
                select 0 as PAYMENTTYPECODE, 
                    null as OTHERPAYMENTMETHODCODEID
                union all
                select 1 as PAYMENTTYPECODE, 
                    null as OTHERPAYMENTMETHODCODEID
                union all
                select 2 as PAYMENTTYPECODE, 
                    null as OTHERPAYMENTMETHODCODEID
                union all
                select 10 as PAYMENTTYPECODE,
                    ID as OTHERPAYMENTMETHODCODEID
                from dbo.OTHERPAYMENTMETHODCODE
                where ACTIVE = 1)

            select 
                case 
                    when PAYMENTTYPECODE = 0 then
                        'CF693144-0204-4FFD-90EF-335E509F9C69'
                    when PAYMENTTYPECODE = 1 then
                        '49BCEDF6-213C-4734-896B-BB183B487D22'
                    when PAYMENTTYPECODE = 2 then
                        '3D8F2B59-3647-48F0-831A-ABC527C3B7AB'
                    else
                        OTHERPAYMENTMETHODCODEID
                    end as [VALUE],
                case when PAYMENTTYPECODE = 0 then 'Cash'
                    when PAYMENTTYPECODE = 1 then 'Check'
                    when PAYMENTTYPECODE = 2 then 'Credit card'
                    else dbo.UFN_OTHERPAYMENTMETHODCODE_GETDESCRIPTION(OTHERPAYMENTMETHODCODEID)
                end as [LABEL]            
            from PAYMENTTYPES_CTE
            order by PAYMENTTYPECODE