UFN_FINANCIALTRANSACTIONLINEITEM_GETJOURNALENTRIES

create function dbo.UFN_FINANCIALTRANSACTIONLINEITEM_GETJOURNALENTRIES(@LINEITEMID uniqueidentifier)
returns table
as
return(
    select
        JE.ID,
        JE.TRANSACTIONTYPECODE,
        JE.TRANSACTIONTYPE,
        JE.TRANSACTIONAMOUNT,
        JE.GLACCOUNTID,
        JE.COMMENT as REFERENCE,
        JE.TRANSACTIONCURRENCYID,
        JEX.PROJECT,
        JEX.GLPAYMENTMETHODREVENUETYPEMAPPINGID,
        GLACCOUNT.ACCOUNTNUMBER as ACCOUNT
    from
        dbo.JOURNALENTRY JE
        inner join dbo.JOURNALENTRY_EXT JEX on JEX.ID = JE.ID
        inner join dbo.GLACCOUNT on GLACCOUNT.ID = JE.GLACCOUNTID
        inner join dbo.FINANCIALTRANSACTIONLINEITEM LI on LI.ID = JE.FINANCIALTRANSACTIONLINEITEMID
    where
        JE.FINANCIALTRANSACTIONLINEITEMID = @LINEITEMID
        and LI.DELETEDON is null
)