UFN_CREDIT_REFUND_HASADJUSTMENT

CREATE function dbo.UFN_CREDIT_REFUND_HASADJUSTMENT
(
    @CREDITID uniqueidentifier
)
returns bit
as begin
    if exists (
        select
            *
        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
        left outer join
            dbo.SALESORDERITEMFEE on SALESORDERITEMFEE.ID = EXT.SALESORDERITEMID
        where
            FT.ID = @CREDITID
            and FT.TYPECODE = 23  -- Refund

            and (
                SALESORDERITEM.TYPECODE in (4, 5)  -- Tax, Discount

                or SALESORDERITEMFEE.APPLIESTOCODE = 0
            )
    )
        return 1;

    return 0;
end