USP_DATALIST_WRITEOFFGLDISTRIBUTION

                CREATE procedure dbo.USP_DATALIST_WRITEOFFGLDISTRIBUTION (@ID uniqueidentifier)
                as 
                    set nocount on;

             select      
                        FT.ID as WRITEOFFID,
                        FT.PARENTID as REVENUEID,
                        isnull(JEX.DISTRIBUTIONTABLEID,JEX.ID) as WRITEOFFGLDISTRIBUTION,
                        MAP.DESCRIPTION,
                        JE.TRANSACTIONTYPE,                        
                        isnull(GL.ACCOUNTNUMBER,JEX.ACCOUNT) as ACCOUNT,
                        JEX.PROJECT,
                        JE.BASEAMOUNT as AMOUNT,
                        JE.COMMENT as REFERENCE,
                        case FT.POSTSTATUSCODE when 2 then 0 when 3 then 2 else 1 end as POSTSTATUSCODE,

                        LI.POSTSTATUS,
                        JE.TRANSACTIONAMOUNT as TRANSACTIONAMOUNT,
                        JE.BASEAMOUNT as BASEAMOUNT,
                        JE.ORGAMOUNT as ORGANIZATIONAMOUNT,
                        JE.TRANSACTIONCURRENCYID,
                        case when CURRENCYSET.BASECURRENCYID = '00000000-0000-0000-0000-000000000000' then null else CURRENCYSET.BASECURRENCYID end BASECURRENCYID,
                        dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY() ORGANIZATIONCURRENCYID             
                from 
                    dbo.JOURNALENTRY_EXT JEX 
                    inner join dbo.GLPAYMENTMETHODREVENUETYPEMAPPING as MAP on JEX.GLPAYMENTMETHODREVENUETYPEMAPPINGID = MAP.ID
                    inner join dbo.JOURNALENTRY JE on JEX.ID = JE.ID  
                    inner join dbo.FINANCIALTRANSACTIONLINEITEM LI on LI.ID = JE.FINANCIALTRANSACTIONLINEITEMID 
                    inner join dbo.FINANCIALTRANSACTION FT on FT.ID = LI.FINANCIALTRANSACTIONID
                    inner join dbo.PDACCOUNTSYSTEM on FT.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
                    inner join dbo.CURRENCYSET on PDACCOUNTSYSTEM.CURRENCYSETID = CURRENCYSET.ID    
                    left outer join dbo.GLACCOUNT GL on GL.ID = JE.GLACCOUNTID
                    left outer join dbo.WRITEOFFADJUSTMENT ADJ on FT.ID = ADJ.WRITEOFFID and  ADJ.POSTSTATUSCODE != 0
                where  
                       JEX.OUTDATED = 0 and JEX.TABLENAMECODE = 12 and FT.PARENTID= @ID

                    order by
                        FT.ID, LI.ID, JE.TRANSACTIONTYPE desc;