UFN_REVENUESPLIT_GETDETAILSFORSEARCHXML

CREATE function dbo.UFN_REVENUESPLIT_GETDETAILSFORSEARCHXML
(
  @REVENUESPLITID uniqueidentifier
)
returns xml
as
begin

  return(
    select 
      REVENUESPLIT_EXT.APPLICATION,
      FINANCIALTRANSACTION.TRANSACTIONAMOUNT,
      CURRENCY.ISO4217,
      CURRENCY.DECIMALDIGITS,
      CURRENCY.CURRENCYSYMBOL,
      CURRENCY.SYMBOLDISPLAYSETTINGCODE,
      NF.NAME
    from
      dbo.REVENUESPLIT_EXT
    inner join 
      dbo.FINANCIALTRANSACTIONLINEITEM on REVENUESPLIT_EXT.ID = FINANCIALTRANSACTIONLINEITEM.ID
    inner join 
      dbo.FINANCIALTRANSACTION on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
    inner join
      dbo.CURRENCY on FINANCIALTRANSACTION.TRANSACTIONCURRENCYID = CURRENCY.ID
    outer apply
      dbo.UFN_CONSTITUENT_DISPLAYNAME(FINANCIALTRANSACTION.CONSTITUENTID) NF
    where
      FINANCIALTRANSACTIONLINEITEM.ID = @REVENUESPLITID
    for xml raw('ITEM'),type,elements,root('DETAILS'),BINARY BASE64
  );

end