UFN_CREDIT_GETSALESORDERITEMOTHERADJUSTMENTS

    CREATE function dbo.UFN_CREDIT_GETSALESORDERITEMOTHERADJUSTMENTS
    (
      @SALESORDERID uniqueidentifier

    ) returns table
    as        
                return
                -- Fees

                select
                    [SALESORDERITEM].[ID],
                    [SALESORDERITEM].[DESCRIPTION],
                    [SALESORDERITEM].[TOTAL],
                    [SALESORDERITEM].[TYPE],
          1 as QUANTITYAVAILABLE,
          1 as QUANTITYREFUNDING
                from dbo.[SALESORDERITEM]
                inner join dbo.[SALESORDERITEMFEE] on 
                    [SALESORDERITEM].[ID] = [SALESORDERITEMFEE].[ID]
                where 
                    [SALESORDERITEM].[SALESORDERID] = @SALESORDERID and
                    [SALESORDERITEM].[TYPECODE] = 3 and
                    [SALESORDERITEMFEE].[APPLIESTOCODE] = 0

                -- Taxes

                union all
                select
                    [SALESORDERITEM].[ID],
                    [SALESORDERITEM].[DESCRIPTION],
                    [SALESORDERITEM].[TOTAL],
                    [SALESORDERITEM].[TYPE],
          1 as QUANTITYAVAILABLE,
          1 as QUANTITYREFUNDING
                from dbo.[SALESORDERITEM]
                where 
                    [SALESORDERITEM].[SALESORDERID] = @SALESORDERID and
                    [SALESORDERITEM].[TYPECODE] = 4

                -- Discounts

                union all
                select
                    [SALESORDERITEM].[ID],
                    [SALESORDERITEM].[DESCRIPTION],
                    (-1 * [SALESORDERITEM].[TOTAL]) as [TOTAL],
                    [SALESORDERITEM].[TYPE],
          1 as QUANTITYAVAILABLE,
          1 as QUANTITYREFUNDING
                from dbo.[SALESORDERITEM]
                where 
                    [SALESORDERITEM].[SALESORDERID] = @SALESORDERID and
                    [SALESORDERITEM].[TYPECODE] = 5