Comment by iceporter

I think I will use this approach

but I think I need to use union to make a single table that is combination of accounting journal tables and view of transaction tables