5101製令未完工
已生產未領料
<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>