I am building a query to show the fields and all info. I have the fields table and would like to join on the table that shows what type of field it is. I need to know what table stores the values for the Field Type numbers
They are not stored in a different table. They are listed under the TS_FIELDS table structure in the SBM Schema Doc. You can find that document along with all the other documentation at http://help.serena.com.