Mes system - cycle analysis

mitjap — Wed, 22 Sep 2021 11:37:38 GMT

Hello.

i would like to build app for production control. in future i hope to integrete this with sql so i get real time control over machines

this is my problem

Table one: i get this times form Mes cycle data

data from ERP. gives time when part needs to be finished

extra table with status i need for control

status

Late

In time

first cycle

result

If timedifference is less or more as normative for part, correct ststaus shows

Any help is very welcomed

topic Mes system - cycle analysis in App Development