「銷貨單確認」:修訂間差異
新頁面: ==主程式碼== <sql> SELECT TH001,TH002,TH003,TH004,TH005,TH006,TH007,TH008,UDF01,TH014,TH015,TH016 FROM COPTH WHERE TH020='N' AND TH004 LIKE '5%' </sql> ==銷貨數量是否足夠=... |
|||
| 第19行: | 第19行: | ||
</sql> | </sql> | ||
*DMC007若小於0則數量不足 | *DMC007若小於0則數量不足 | ||
==品號異動資訊== | |||
*生產入庫單 | |||
<sql> | |||
SELECT TG001,TG002,TG003,TG004,TG005,TG006,TG007,TG010,TG011,TG014,TG015,TG022 FROM MOCTG WHERE TG004 LIKE'5%' | |||
</sql> | |||
*異動單 | |||
<sql> | |||
SELECT TB001,TB002,TB003,TB004,TB005,TB006,TB008,TB012,TB007,TB018,'000' AS TBTA01,'000' AS TBTA02 FROM INVTB WHERE TB004 LIKE '5%' | |||
</sql> | |||
*合併 | |||
SELECT TG001,TG002,TG003,TG004,TG005,TG006,TG007,TG010,TG011,TG014,TG015,TG022 FROM MOCTG WHERE TG004 LIKE '5%' | |||
UNION ALL | |||
SELECT TB001,TB002,TB003,TB004,TB005,TB006,TB008,TB012,TB007,TB018,'000' AS TBTA01,'000' AS TBTA02 FROM INVTB WHERE TB004 LIKE '5%' | |||
於 2015年11月18日 (三) 17:16 的修訂
主程式碼
<sql> SELECT TH001,TH002,TH003,TH004,TH005,TH006,TH007,TH008,UDF01,TH014,TH015,TH016 FROM COPTH WHERE TH020='N' AND TH004 LIKE '5%' </sql>
銷貨數量是否足夠
<sql> SELECT TH001,TH002,TH003,TH004,TH005,TH006,TH007,MB064-TH008 AS DMB064,TH014,TH015,TH016 FROM COPTH JOIN INVMB ON MB001=TH004 WHERE TH020='N' AND TH004 LIKE '5%' </sql>
- DMB064若小於0則數量不足
庫別數量不足
<sql> SELECT TH001,TH002,TH003,TH004,TH005,TH006,TH007,TH008,MB064-TH008 AS DMB064,MC007-TH008 AS DMC007,TH014,TH015,TH016 FROM COPTH JOIN INVMB ON MB001=TH004 LEFT JOIN INVMC ON MC001=TH004 AND TH007=MC002 WHERE TH020='N' AND TH004 LIKE '5%' </sql>
- DMC007若小於0則數量不足
品號異動資訊
- 生產入庫單
<sql> SELECT TG001,TG002,TG003,TG004,TG005,TG006,TG007,TG010,TG011,TG014,TG015,TG022 FROM MOCTG WHERE TG004 LIKE'5%' </sql>
- 異動單
<sql> SELECT TB001,TB002,TB003,TB004,TB005,TB006,TB008,TB012,TB007,TB018,'000' AS TBTA01,'000' AS TBTA02 FROM INVTB WHERE TB004 LIKE '5%' </sql>
- 合併
SELECT TG001,TG002,TG003,TG004,TG005,TG006,TG007,TG010,TG011,TG014,TG015,TG022 FROM MOCTG WHERE TG004 LIKE '5%' UNION ALL SELECT TB001,TB002,TB003,TB004,TB005,TB006,TB008,TB012,TB007,TB018,'000' AS TBTA01,'000' AS TBTA02 FROM INVTB WHERE TB004 LIKE '5%'