Booked time for operations/routers

Answered

Mark Alexander

• November 30, 2020 21:11

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.

Vote

0

• Official comment

  

  Martin Heigl

  • December 01, 2020 05:18

  Hi Mark,

  it's really simple

  http://help.beascloud.com/script202012/index.html?beasv_workorder_routing.htm

  regards

  Martin 

   
• 

  Mark Alexander

  • December 03, 2020 21:51

  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.
• 

  Martin Heigl

  • December 04, 2020 04:57

  Hi Mark,

  i don't understand. In the view you can see all 3 rows

   
• 

  Mark Alexander

  • December 04, 2020 13:47

  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:
• 

  Mark Alexander

  • December 04, 2020 14:02

  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.

Please sign in to leave a comment.