UFN_CREDITPAYMENT_TRANSLATIONFUNCTION

CREATE function dbo.UFN_CREDITPAYMENT_TRANSLATIONFUNCTION(@ID uniqueidentifier) returns nvarchar(100) 
as
begin
    declare @s nvarchar(100);
    select @s = isnull(convert(nvarchar(100), SALESORDER.SEQUENCEID), FT.CALCULATEDUSERDEFINEDID)
    from dbo.CREDITPAYMENT
    inner join dbo.CREDIT on CREDIT.ID = CREDITPAYMENT.CREDITID
    left join dbo.SALESORDER on SALESORDER.ID = CREDIT.SALESORDERID
  left join dbo.FINANCIALTRANSACTIONLINEITEM FTLI on FTLI.ID = CREDITPAYMENT.REVENUESPLITID
  left join dbo.FINANCIALTRANSACTION FT on FT.ID = FTLI.FINANCIALTRANSACTIONID
  where FT.TYPECODE in (0,1,2,3,4,5,6,7,8,9) and FT.DELETEDON is null
  and FTLI.DELETEDON is null and FTLI.TYPECODE != 1
    and CREDITPAYMENT.ID = @ID
    return @s;
end