Booked time for operations/routers Respondida
I am trying to write a query that will display the booked time for an operation/router and the actual time that was logged against it. I don't have a problem getting the time logged for each scan, but can't find where the booked time is located, or if it's a calculated field.
I have attached a picture with the highlighted data I'm looking to find. If anyone can provide me with the table/attribute information it would be appreciated.
Comentarios
5 comentarios
Hi Mark,
it's really simple
http://help.beascloud.com/script202012/index.html?beasv_workorder_routing.htm
regards
Martin
Hi Martin,
Thanks for replying.
I see planned time and reserved time, which are taken from BEAS_FTAPL and BEAS_RESOURCEN respectively. I can't find the planned time in BEAS_FTAPL and the BEAS_RESOURCEN only has 1 row but my example has 3 operations.
Hi Mark,
i don't understand. In the view you can see all 3 rows
Hi Martin,
If I query the view (BEASV_WORKORDER_ROUTING), I get nothing for the work order in question (33780). If I query table BEAS_FTAPL I get the 3 rows for each operation, but none of the values match the planned time in the view. If I query table BEAS_RESOURCEN I only get one of the operations returned (Operation 30), and there is a value that matches the planned time of 115 minutes. See screen shot below:
Hi Martin,
I found it now. I was querying on the wrong attribute (DocNum instead of DocEntry), and it was returning nothing for the view. Now I'm getting all the rows, with the planned time.
Thanks for your help.
Iniciar sesión para dejar un comentario.