「生產入庫單規劃」:修訂間差異
跳至導覽
跳至搜尋
| 第17行: | 第17行: | ||
==是否已有入庫數及需領套數是否足夠== | ==是否已有入庫數及需領套數是否足夠== | ||
<sql> | <sql> | ||
SELECT TA001,TA002,TA015-TA017 AS | SELECT TA001,TA002,TA015-TA017 AS MADEAMOUNT,TA015-TA016 AS SETS,TA013,TA011 FROM MOCTA WHERE TA015-TA017<>'0' AND TA001='5102' | ||
</sql> | </sql> | ||
於 2015年11月10日 (二) 10:43 的修訂
領料是否足夠
<sql> SELECT TB001,TB002,COUNT(TB002) AS UNUSE FROM MOCTB WHERE TB004-TB005<>'0' AND TB011='1' AND TB001='5102' GROUP BY TB002,TB001 </sql>
是否有未確認的領料單
<sql> SELECT TE011,TE012,COUNT(TE012) AS UCKMOCTE FROM MOCTE WHERE TE003='0001' AND TE011='5102' AND TE019='N' GROUP BY TE012,TE011 </sql>
是否有未確認的生產入庫單
<sql> SELECT TG014,TG015,COUNT(TG015) AS UCKMOCTG FROM MOCTG WHERE TG014='5102' AND TG022='N' GROUP BY TG014,TG015 </sql>
是否已有入庫數及需領套數是否足夠
<sql> SELECT TA001,TA002,TA015-TA017 AS MADEAMOUNT,TA015-TA016 AS SETS,TA013,TA011 FROM MOCTA WHERE TA015-TA017<>'0' AND TA001='5102' </sql>