「貼紙列印註記」:修訂間差異
新頁面: ==叫出全部貼紙== <sql> SELECT MA002,MA016,TD002,TD003,TC012,TD014,TD004,TD005,TD006,TD008,TC003,TD013,TD064,TD020, INVMB.UDF03,X.UDF01,MB028,TA001,TA002,TA011 FROM (SELECT COPTD... |
|||
| 第1行: | 第1行: | ||
==叫出全部貼紙== | ==叫出全部貼紙== | ||
<sql> | |||
SELECT MA002,MA016,TD002,TD003,TC012,TD014,TD004,TD005,TD006,TD008,TC003,TD013,TD064,TD020, | |||
INVMB.UDF03,X.UDF01,MB028,TA001,TA002,TA011 | |||
FROM (SELECT COPTD.*,COPTC.TC004,COPTC.TC012,TC003,TA001,TA002,TA011 | |||
FROM COPTD JOIN COPTC ON TD001=TC001 AND TD002=TC002 | |||
JOIN v_ORDER ON COPTD.TD002 = v_ORDER.TD002 AND COPTD.TD001 = v_ORDER.TD001 AND COPTD.TD003 = v_ORDER.TD003 | |||
WHERE ( TC003<>'' ) AND (COPTD.TD001='2202' AND COPTD.TD016='N' | |||
AND COPTD.TD021='Y' AND COPTC.TC004 <>'0125' AND COPTC.TC004 <>'003A' AND COPTC.TC004<>'003C' AND COPTC.TC004<>'0002' )) | |||
X JOIN COPMA ON TC004=MA001 JOIN INVMB ON TD004=MB001 ORDER BY INVMB.UDF03 DESC,TD064 ASC | |||
</sql> | |||
*改寫 | |||
<sql> | <sql> | ||
SELECT MA002,MA016,TD002,TD003,TC012,TD014,TD004,TD005,TD006,TD008,TC003,TD013,TD064,TD020, | SELECT MA002,MA016,TD002,TD003,TC012,TD014,TD004,TD005,TD006,TD008,TC003,TD013,TD064,TD020, | ||
於 2016年3月24日 (四) 14:16 的修訂
叫出全部貼紙
<sql> SELECT MA002,MA016,TD002,TD003,TC012,TD014,TD004,TD005,TD006,TD008,TC003,TD013,TD064,TD020, INVMB.UDF03,X.UDF01,MB028,TA001,TA002,TA011 FROM (SELECT COPTD.*,COPTC.TC004,COPTC.TC012,TC003,TA001,TA002,TA011 FROM COPTD JOIN COPTC ON TD001=TC001 AND TD002=TC002 JOIN v_ORDER ON COPTD.TD002 = v_ORDER.TD002 AND COPTD.TD001 = v_ORDER.TD001 AND COPTD.TD003 = v_ORDER.TD003 WHERE ( TC003<> ) AND (COPTD.TD001='2202' AND COPTD.TD016='N' AND COPTD.TD021='Y' AND COPTC.TC004 <>'0125' AND COPTC.TC004 <>'003A' AND COPTC.TC004<>'003C' AND COPTC.TC004<>'0002' )) X JOIN COPMA ON TC004=MA001 JOIN INVMB ON TD004=MB001 ORDER BY INVMB.UDF03 DESC,TD064 ASC </sql>
- 改寫
<sql> SELECT MA002,MA016,TD002,TD003,TC012,TD014,TD004,TD005,TD006,TD008,TC003,TD013,TD064,TD020, INVMB.UDF03,X.UDF01,MB028,TA001,TA002,TA011 FROM (SELECT COPTD.*,COPTC.TC004,COPTC.TC012,TC003,TA001,TA002,TA011 FROM COPTD JOIN COPTC ON TD001=TC001 AND TD002=TC002 JOIN v_ORDER ON COPTD.TD002 = v_ORDER.TD002 AND COPTD.TD001 = v_ORDER.TD001 AND COPTD.TD003 = v_ORDER.TD003 WHERE ( TC003<> ) AND (COPTD.TD001='2202' AND COPTD.TD016='N' AND COPTD.TD021='Y' AND COPTC.TC004 <>'0125' AND COPTC.TC004 <>'003A' AND COPTC.TC004<>'003C' AND COPTC.TC004<>'0002' )) X JOIN COPMA ON TC004=MA001 JOIN INVMB ON TD004=MB001 ORDER BY INVMB.UDF03 DESC,TD064 ASC </sql>
-
- 客戶別
- 業務代號
- 訂單單號
- 訂單序號
- 客戶單號
- 客戶料號
- 品號
- 品名
- 規格
- 訂單日期
- 訂單交期
- 貼紙有無
- 貼紙轉出日
- 外箱單備註
- 數量
- 製令單別
- 製令單號
- 加工設計書路徑
- 訂單備註
- 製令狀態