UFN_SALESORDERITEM_REFUNDTOTALS

CREATE function dbo.UFN_SALESORDERITEM_REFUNDTOTALS(@ID uniqueidentifier)
returns table
as return (
    select
        isnull(sum(LI.QUANTITY), 0) as QUANTITY,
        isnull(sum((LI.QUANTITY * LI.UNITVALUE) - EXT.DISCOUNTS), 0) as AMOUNT
    from
        dbo.CREDITITEM_EXT as EXT
    inner join
        dbo.FINANCIALTRANSACTIONLINEITEM as LI on LI.ID = EXT.ID
    where
        EXT.SALESORDERITEMID = @ID
)