UFN_WORKSTATION_GETCASHDRAWERPAYMENTMETHODS

            create function dbo.UFN_WORKSTATION_GETCASHDRAWERPAYMENTMETHODS (
                @WORKSTATIONID uniqueidentifier
            )
            returns table
            as 
                return
                    select
                        WORKSTATIONCASHDRAWERPAYMENTMETHOD.PAYMENTTYPECODE,
                        case WORKSTATIONCASHDRAWERPAYMENTMETHOD.PAYMENTTYPECODE
                            when 0 then 'CF693144-0204-4FFD-90EF-335E509F9C69'
                            when 1 then '49BCEDF6-213C-4734-896B-BB183B487D22'
                            when 2 then '3D8F2B59-3647-48F0-831A-ABC527C3B7AB'
                            when 10 then WORKSTATIONCASHDRAWERPAYMENTMETHOD.OTHERPAYMENTMETHODCODEID
                        end as [PAYMENTMETHODID]
                    from dbo.WORKSTATIONCASHDRAWERPAYMENTMETHOD
                    where WORKSTATIONCASHDRAWERPAYMENTMETHOD.WORKSTATIONID = @WORKSTATIONID