I just realized I was using the term "Vendor Code" when I really meant "Vendor Item Number" which is the field I need in my report for reference next to our own item number. When I had a closer look, neither of the Composite Tables had it available. I was reading Vendor Code and thinking Vendor Item Number.
I'd better learn the proper terminology!