UFN_CREDIT_REFUND_GETTICKETTOTAL

CREATE function dbo.UFN_CREDIT_REFUND_GETTICKETTOTAL
(
    @CREDITID uniqueidentifier
)
returns money
as begin
    declare @TICKETTOTAL money;

    select @TICKETTOTAL = coalesce(sum((LI.QUANTITY * LI.UNITVALUE) - EXT.DISCOUNTS + EXT.FEES), 0)
    from dbo.FINANCIALTRANSACTIONLINEITEM as LI
    inner join dbo.CREDITITEM_EXT as EXT on EXT.ID = LI.ID
    where 
        LI.FINANCIALTRANSACTIONID = @CREDITID and
        EXT.TYPECODE = 0  -- Ticket


    return @TICKETTOTAL;
end