UFN_CREDIT_GETSALESORDERITEMMEMBERSHIPS

    CREATE function dbo.UFN_CREDIT_GETSALESORDERITEMMEMBERSHIPS
    (
      @SALESORDERID uniqueidentifier

    ) returns table
    as

                return
        select
                    [SALESORDERITEM].[ID],
                    [SALESORDERITEM].[DESCRIPTION],
                    [SALESORDERITEM].[PRICE],
                    [SALESORDERITEM].[QUANTITY] as QUANTITYREFUNDING,
          [SALESORDERITEM].[QUANTITY] as QUANTITYAVAILABLE,
                    [SALESORDERITEM].[TOTAL],
                    [MEMBER].[ID] as MEMBERID,
                    SALESORDERITEMMEMBERSHIP.EXPIRATIONDATE,
                    dbo.UFN_MEMBERSHIPLEVELTYPECODE_GETDESCRIPTION(SALESORDERITEMMEMBERSHIP.MEMBERSHIPLEVELTYPECODEID) as MEMBERSHIPLEVELTYPECODE,
          (
                                select dbo.UFN_CONSTITUENT_BUILDNAME(SALESORDERITEMMEMBER.CONSTITUENTID) [MEMBERNAME]
                                from dbo.SALESORDERITEMMEMBER
                                where SALESORDERITEMMEMBERSHIP.ID = SALESORDERITEMMEMBER.SALESORDERITEMMEMBERSHIPID
                            ) as MEMBERSHIPMEMBERS
                from dbo.[SALESORDERITEM]
                inner join dbo.[SALESORDERITEMMEMBERSHIP] 
                    on [SALESORDERITEM].[ID] = [SALESORDERITEMMEMBERSHIP].[ID]
                left join dbo.[MEMBERSHIP]
                    on [SALESORDERITEMMEMBERSHIP].[MEMBERSHIPID] = [MEMBERSHIP].[ID]
                left join dbo.[MEMBER]
                    on [MEMBERSHIP].[ID] = [MEMBER].[MEMBERSHIPID]
                where 
                    [SALESORDERITEM].[SALESORDERID] = @SALESORDERID