UFN_CREDIT_REFUND_HASADJUSTMENT2

create function dbo.UFN_CREDIT_REFUND_HASADJUSTMENT2
(
    @CREDITID uniqueidentifier
)
returns bit
as begin
    if exists (
        select *
        from dbo.FINANCIALTRANSACTIONLINEITEM LI
        inner join dbo.CREDITITEM_EXT EXT on EXT.ID = LI.ID
        inner join dbo.SALESORDERITEM on SALESORDERITEM.ID = EXT.SALESORDERITEMID
        where
            LI.FINANCIALTRANSACTIONID = @CREDITID
            and SALESORDERITEM.TYPECODE in (3, 4, 5)  -- Fee, Tax, Discount

    )
        return 1;

    return 0;
end