Approved / primary suppliers

Epicor 9.05.701

I need a list of primary / approved vendors by part.
What tables should be used?..I looked in supplier price list but there was no database field behind “primary supplier”.

Many thanks in advance.

Oh, i think primary vendor is behind part plant.

Mark,
Yes the Primary Vendor is stored on PartPlant, but all approved vendors are stored in AprvVend