「貼紙列印註記」:修訂間差異

出自TSK WIKI
跳至導覽 跳至搜尋
Root​(留言 | 貢獻)
新頁面: ==叫出全部貼紙== <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...
 
Root​(留言 | 貢獻)
第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>

    • 客戶別
    • 業務代號
    • 訂單單號
    • 訂單序號
    • 客戶單號
    • 客戶料號
    • 品號
    • 品名
    • 規格
    • 訂單日期
    • 訂單交期
    • 貼紙有無
    • 貼紙轉出日
    • 外箱單備註
    • 數量
    • 製令單別
    • 製令單號
    • 加工設計書路徑
    • 訂單備註
    • 製令狀態