5101製令未完工

出自TSK WIKI
於 2018年7月16日 (一) 10:17 由 Root​(留言 | 貢獻) 所做的修訂 (→已生產未領料)
(差異) ←上個修訂 | 最新修訂 (差異) | 下個修訂→ (差異)
跳至導覽 跳至搜尋

已生產未領料

<SQL> SELECT TA001,TA002,TA006,TA015,TA017,TA013,TA011,TB004,TB005,TB003,MB002 FROM MOCTA JOIN MOCTB ON TB001=TA001 AND TB002=TA002 JOIN INVMB ON TB003=MB001 WHERE TA013='Y' AND TA001='5101' AND TA011<='3' AND TA017>0 AND TB005=0 AND TB003 LIKE '20%' ORDER BY TA002 </SQL>

已生產達10%誤差量未完工製令

<SQL> SELECT TA001,RTRIM(TA002) TA002,TA006,TA034,TA011,CAST(TA015 as float ) AS 預計產量, CAST(TA017 as float) AS 已生產量,CAST((TA017-TA015)*(-1)as float) AS 未生數量, abs((TA017-TA015))/TA017*100 as 生產差比 FROM MOCTA WHERE (TA001='5101') AND TA011<='3' AND TA017>0 AND TA013='Y' AND abs((TA017-TA015))/TA017*100 <10 </SQL>

已生產未完工製令

<SQL> SELECT TA001,RTRIM(TA002) TA002,TA006,TA034,TA011,CAST(TA015 as float ) AS 預計產量, CAST(TA017 as float) AS 已生產量,CAST((TA017-TA015)*(-1)as float) AS 未生數量 FROM MOCTA WHERE (TA001='5101') AND TA011<='3' AND TA017>0 AND TA013='Y' </SQL>