「5101製令未完工」:修訂間差異

出自TSK WIKI
跳至導覽 跳至搜尋
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 WH...
 
Root​(留言 | 貢獻)
 
第7行: 第7行:
AND TB005=0 AND TB003 LIKE '20%'
AND TB005=0 AND TB003 LIKE '20%'
ORDER BY TA002
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>
</SQL>

於 2018年7月16日 (一) 10:17 的最新修訂

已生產未領料

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