UFN_CREDIT_REFUND_GETADJUSTMENTTOTAL2

CREATE function dbo.UFN_CREDIT_REFUND_GETADJUSTMENTTOTAL2
(
    @CREDITID uniqueidentifier
)
returns money
as begin
return (
    select coalesce(sum(LI.BASEAMOUNT),0)
    from dbo.FINANCIALTRANSACTION as FT
    inner join dbo.FINANCIALTRANSACTIONLINEITEM as LI on LI.FINANCIALTRANSACTIONID = FT.ID
    inner join dbo.CREDITITEM_EXT as EXT on EXT.ID = LI.ID
    inner join dbo.SALESORDERITEM on SALESORDERITEM.ID = EXT.SALESORDERITEMID
    where FT.ID = @CREDITID
        and FT.TYPECODE = 23  -- Refund

        and SALESORDERITEM.TYPECODE in (3,4)  -- fee, tax

)
end