Consider joining the TransactionAccountingLine with the TransactionLine table. These tables should be joined on 2 keys (I’m not in front of computer, else I’d give you the join keys). You will find that there is a one-for-one between these tables, and the TransactionLine table may hold some of the information you are looking for (experimentation recommended).