UFN_FINANCIALTRANSACTION_LINEITEMS_TOITEMLISTXML

CREATE function dbo.UFN_FINANCIALTRANSACTION_LINEITEMS_TOITEMLISTXML(@FINANCIALTRANSACTIONID uniqueidentifier)
returns xml
with execute as caller
as begin
    return (
        select SEQUENCE, ID, FINANCIALTRANSACTIONID, TRANSACTIONAMOUNT as AMOUNT, BASEAMOUNT, ORGAMOUNT,DESCRIPTION, TYPECODE, 
    case when DELETEDON is null then 0 else 1 end, 
    REVERSEDLINEITEMID
    ,POSTSTATUSCODE
    ,POSTDATE
    ,dbo.[UFN_FINANCIALTRANSACTION_LINEITEM_GL_TOITEMLISTXML](ID)
    ,VISIBLE
        from dbo.FINANCIALTRANSACTIONLINEITEM
        where FINANCIALTRANSACTIONID = @FINANCIALTRANSACTIONID and VISIBLE=1
        order by SEQUENCE
        for xml raw('ITEM'),type,elements,root('LINEITEMS'),BINARY BASE64);
end