MES "end activity" operator notes BAQ

[JakeM (Jake Morrill)]

Hello,

I have a scenario I am trying to identify in which I want to view all the operator left notes under the “end activity” window during an MES transaction. I want to pull via BAQ but have not been able to find the correct data table to do so.

can anyone point me in the right direction?

[NateS (Nate Schoonover)]

Hi Jake. Welcome to the group!
I don’t really use MES, but I think you want labor transactions. The LaborHed, and LaborDtl tables have this information.
In LaborDtl there is a LaborNote field. Try to search for operations that are marked complete, and have a note.

I hope this helps! Good luck!
Nate

[JakeM (Jake Morrill)]

Thanks Nate, LaborHed and Dtl where both my starting point however I did not see anything, I will give a second look, both list are long and I may have simply missed it.

[hackaphreaka (Garret Travers)]

As a side note, you can, (almost anywhere) click into the field you want to know about, go to ‘Help’ → ‘Field Help’

Clicking on the ‘Technical Details’ in Field Help will tell you what table.field the data lives in: