A useful tool to use is field helper. This allows you to open a form and click on any field to see where the data is coming from. For example you would open time entry, click help, click field help, it helps to pin the program so it doesnt disappear, click on technical details and click on the field of data you want to pull into a BAQ. It should list the table and the column.
Ok, last thing with my project...First, thank you to everyone who has been helpful at explaining things and helping me along. Each time, I understand Epicor a little bit more and for that I cannot say thank you enough.
I need to find out which jobs are first time build jobs
meaning: where no other job for that part has labor on it
I am guessing this would come from a labor field or table...any direction where to find this?
Currently my BAQ is using JobHead and JobOper to filter all the other requirements. So wherever LABOR comes from needs to be able to link to those.
LaborHed and LaborDtl tables, LaborDtl is linked to the JobOper by the Company, JobNum and OprSeq fields.