UFN_CREDIT_REFUND_GETCHECKDETAILS

                create function dbo.UFN_CREDIT_REFUND_GETCHECKDETAILS
                (
                    @CREDITID uniqueidentifier
                )
                returns table
                as return (
                    select
                        [CREDITPAYMENTCHECKPAYMENTMETHODDETAIL].[CHECKNUMBER],
                        [CREDITPAYMENTCHECKPAYMENTMETHODDETAIL].[CHECKDATE],
                        [CREDITPAYMENTCHECKPAYMENTMETHODDETAIL].[NOTES]
                    from
                        dbo.[CREDITPAYMENTCHECKPAYMENTMETHODDETAIL]
                    left join
                        dbo.[CREDITPAYMENT]
                    on
                        [CREDITPAYMENTCHECKPAYMENTMETHODDETAIL].[ID] = [CREDITPAYMENT].[ID]
                    where
                        [CREDITPAYMENT].[CREDITID] = @CREDITID
                )