UFN_CREDIT_GETSALESORDERITEMDONATIONS

    create function dbo.UFN_CREDIT_GETSALESORDERITEMDONATIONS
    (
      @SALESORDERID uniqueidentifier

    ) returns table
    as
                return
                select
                    [SALESORDERITEM].[ID],
                    [SALESORDERITEM].[DESCRIPTION],
                    [SALESORDERITEM].[PRICE],
          [SALESORDERITEM].[QUANTITY] as QUANTITYREFUNDING,
                    [SALESORDERITEM].[QUANTITY] as QUANTITYAVAILABLE,
                    [SALESORDERITEM].[TOTAL]
                from dbo.[SALESORDERITEM]
                inner join dbo.[SALESORDERITEMDONATION]
                    on [SALESORDERITEM].[ID] = [SALESORDERITEMDONATION].[ID]
                where 
                    [SALESORDERITEM].[SALESORDERID] = @SALESORDERID