Prophet 21 has over 2300 tables and 2700 views. It can be daunting to find certain fields or information in this haystack of database objects. But, once you learn the database structure and how the Epicor developers think, you can figure out how to find things on your own. We will cover the available tools to help with finding what tables and fields are available and how they are mapped to the Prophet 21 GUI. We will also look at where basic Prophet 21 transactional data is stored and how the various tables relate to each other. The presentation will include multiple TSQL code snippets and working examples that you can use in your own organization.