UFN_POSTTOGLPROCESS_GETUNPOSTEDADJUSTMENTTRANSACTIONS_2

CREATE function dbo.UFN_POSTTOGLPROCESS_GETUNPOSTEDADJUSTMENTTRANSACTIONS_2(@POSTTOGLPROCESSID uniqueidentifier)
            returns table
            as
            return
    (select distinct
        FINANCIALTRANSACTION.ID as ADJUSTMENTID
        ,JOURNALENTRY.ID as GLTRANSACTIONID
        ,JOURNALENTRY.TRANSACTIONTYPE
        ,GLACCOUNT.ACCOUNTNUMBER as ACCOUNT
        ,JOURNALENTRY_EXT.PROJECT
        ,JOURNALENTRY.TRANSACTIONAMOUNT as AMOUNT
        ,JOURNALENTRY.COMMENT as REFERENCE

    from dbo.JOURNALENTRY 
    inner join dbo.FINANCIALTRANSACTIONLINEITEM on FINANCIALTRANSACTIONLINEITEM.ID = JOURNALENTRY.FINANCIALTRANSACTIONLINEITEMID
    inner join dbo.FINANCIALTRANSACTION on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID 
    inner join dbo.JOURNALENTRY_EXT on JOURNALENTRY.ID = JOURNALENTRY_EXT.ID and JOURNALENTRY_EXT.TABLENAMECODE = 4        
    inner join dbo.GLACCOUNT on JOURNALENTRY.GLACCOUNTID = GLACCOUNT.ID        
    inner join dbo.POSTTOGLPROCESS on GLACCOUNT.PDACCOUNTSYSTEMID = POSTTOGLPROCESS.PDACCOUNTSYSTEMID         
    where
        FINANCIALTRANSACTION.POSTSTATUSCODE = 1
    and
        FINANCIALTRANSACTIONLINEITEM.POSTSTATUSCODE = 1
    and 
        POSTTOGLPROCESS.ID = @POSTTOGLPROCESSID);