貼紙列印註記
叫出全部貼紙
<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>
-
- 客戶別
- 業務代號
- 訂單單號
- 訂單序號
- 客戶單號
- 客戶料號
- 品號
- 品名
- 規格
- 訂單日期
- 訂單交期
- 貼紙有無
- 貼紙轉出日
- 外箱單備註
- 數量
- 製令單別
- 製令單號
- 加工設計書路徑
- 訂單備註
- 製令狀態