Zack,
I am attaching my most recent iteration of the joins I have put together. I don’t particularly know what left outer join and inner join mean, but this is how I have gotten the least number of duplicates. TFOrdDtl just being attached reduces duplicate records by a great amount. If you have a better suggestions for how to accomplish this I would be glad to give it a shot.