「生產入庫單規劃」:修訂間差異

出自TSK WIKI
跳至導覽 跳至搜尋
Root​(留言 | 貢獻)
新頁面: ==領料是否足夠== <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> ==是否有未確認...
 
Root​(留言 | 貢獻)
第6行: 第6行:
<sql>
<sql>
SELECT TE011,TE012,COUNT(TE012) AS UCKMOCTE
SELECT TE011,TE012,COUNT(TE012) AS UCKMOCTE
FROM MOCTE JOIN MOCTC ON TE001=TC001 AND TE002=TC002 AND TE003='0001' AND TE011='5102' AND TE019='N'
FROM MOCTE WHERE TE003='0001' AND TE011='5102' AND TE019='N'
GROUP BY TE012,TE011
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 MADEAMOUT FROM MOCTA WHERE TA015-TA017<>'0' AND TA001='5102'
</sql>
</sql>

於 2015年11月10日 (二) 10:34 的修訂

領料是否足夠

<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 MADEAMOUT FROM MOCTA WHERE TA015-TA017<>'0' AND TA001='5102' </sql>