Hello, I am trying to write a sql query for our users to generate a vendor address list across our different companies. They only want active vendors and I do not see a field in the vendor master table for active status. I see a field called VENDSTTS which I thought was is but when I tested that theory it didn't seem to be right. Anyone know the right field? Or am in in the wrong table?
It is in PM00200. From http://victoriayudin.com/gp-tables/pm-tables/
VENDSTTS (Vendor Status):1 – Active2 – Inactive3 – Temporary
Hope that helps.