貼紙列印註記
叫出全部貼紙
<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>
- 20160324改寫
<sql> SELECT TD041,TC006,TD001,TD002,TC006,TD002,TD003,TC012,TD014,TD004,TD005,TD006,TD008,TD013,TD064,TD020,Y.UDF03,X.UDF01, MB028,TA001,TA002,TA011 FROM COPTD X JOIN COPTC ON TC001=TD001 AND TC002=TD002 JOIN INVMB Y ON TD004=MB001 JOIN MOCTA ON TA002= TD054 AND TA001='5102' WHERE TD001='2202' AND TC004<>'0125' AND TC004<>'003A' AND TC004<>'003C' AND TC004<>'0002' AND TD016='N' ORDER BY Y.UDF03 DESC,TD064 ASC </sql>
-
- 客戶別
- 業務代號
- 訂單單號
- 訂單序號
- 客戶單號
- 客戶料號
- 品號
- 品名
- 規格
- 訂單日期
- 訂單交期
- 貼紙有無
- 貼紙轉出日
- 外箱單備註
- 數量
- 製令單別
- 製令單號
- 加工設計書路徑
- 訂單備註
- 製令狀態