USP_DATALIST_JOURNALENTRYBATCH

                CREATE procedure dbo.USP_DATALIST_JOURNALENTRYBATCH
                as
                    set nocount on;

                    select
                        B.ID,
                        B.BATCHNUMBER,
                        FT.CALCULATEDUSERDEFINEDID USERDEFINEDID,
                        dbo.[UFN_CHANGEAGENT_GETUSERNAME](B.ADDEDBYID) ADDEDBY,  
                        B.DATEADDED,
                        dbo.[UFN_CHANGEAGENT_GETUSERNAME](B.CHANGEDBYID) CHANGEDBY,
                        B.DATECHANGED,
                        LI.ID
                    from dbo.JOURNALENTRYBATCH B
                    inner join dbo.FINANCIALTRANSACTION FT on B.ID=FT.ID
                    inner join dbo.FINANCIALTRANSACTIONLINEITEM LI on FT.ID=LI.FINANCIALTRANSACTIONID
                    where FT.DELETEDON IS NULL
                    order by B.BATCHNUMBER, FT.USERDEFINEDID