Active Vendor Status in PM00200 table?

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?