1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| Select
T0.docnum ,
T0.Itemcode ,
T1.ItemName,
T0.Duedate,
T0.U_Datefinof,
T0.U_Machine,
T0.U_personnel ,
sum (T0.U_NbreHeureOF) AS [Nombre d'heure prévue] ,
sum (T0.U_NbreHeurereelle) AS [Nombre d'heure Réel],
(T0.U_NbreHeurereelle - T0.U_NbreHeureOF) AS [Ecart],
T2.Name,
T0.U_Reglage,
(T0.U_tpsreg ),
(T0.U_Reglage - T0.U_tpsreg ) AS [Ecart]
from OWOR T0
inner join OITM T1 on T0.itemcode = T1.Itemcode
full join [@REGLEUR] T2 on T0.U_regleur = T2. Code
full join [@PERSOCCT] T3 on T0.U_personnel = T3.Code
where T0.Status = 'L'
group by
T0.docnum ,
T0.Itemcode ,
T1.ItemName,
T0.Duedate,
T0.U_Datefinof,
T0.U_Machine,
T0.U_personnel ,
T0.U_NbreHeurereelle,
T0.U_NbreHeureOF,
(T2.Name),
T0.U_Reglage,
T0.U_tpsreg |
Partager