「WF自訂格式」:修訂間差異

出自TSK WIKI
跳至導覽 跳至搜尋
Root​(留言 | 貢獻)
Root​(留言 | 貢獻)
第6行: 第6行:
**SELECT TD001,TD002,TD003,TD020,COPTD.UDF01,COPTD.UDF02 FROM COPTD JOIN COPTC ON TD001=TC001 AND TD002=TC002 LEFT JOIN MOCTA ON TD001=TA026 AND TD002=TA027 WHERE TC004='003C' AND COPTD.UDF02<>'' AND TA027 IS NULL
**SELECT TD001,TD002,TD003,TD020,COPTD.UDF01,COPTD.UDF02 FROM COPTD JOIN COPTC ON TD001=TC001 AND TD002=TC002 LEFT JOIN MOCTA ON TD001=TA026 AND TD002=TA027 WHERE TC004='003C' AND COPTD.UDF02<>'' AND TA027 IS NULL
*COPTD.UDF03 訂單單身.製令(為了用訂單憑證印外箱單用)
*COPTD.UDF03 訂單單身.製令(為了用訂單憑證印外箱單用)
**UPDATE COPTD SET COPTD.UDF03= TA001+TA002 FROM MOCTA JOIN COPTD ON TA026=TD001 AND TA027=TD002 AND TA028=TD003 WHERE COPTD.UDF03=''
*COPTD.UDF04 訂單單身.寫入品號ROHS
*COPTD.UDF04 訂單單身.寫入品號ROHS



於 2015年2月12日 (四) 16:15 的修訂

自訂單頭畫面

目訂單身畫面

  • COPTD.UDF01 訂單單身 銷製令
  • COPTD.UDF02 訂單單身 客單序號(精機序號專用)
    • UPDATE COPTD SET TD003 = COPTD.UDF02 FROM COPTD JOIN COPTC ON TD001=TC001 AND TD002=TC002 LEFT JOIN MOCTA ON TD001=TA026 AND TD002=TA027 WHERE TC004='003C' AND COPTD.UDF02<> AND TA027 IS NULL
    • SELECT TD001,TD002,TD003,TD020,COPTD.UDF01,COPTD.UDF02 FROM COPTD JOIN COPTC ON TD001=TC001 AND TD002=TC002 LEFT JOIN MOCTA ON TD001=TA026 AND TD002=TA027 WHERE TC004='003C' AND COPTD.UDF02<> AND TA027 IS NULL
  • COPTD.UDF03 訂單單身.製令(為了用訂單憑證印外箱單用)
    • UPDATE COPTD SET COPTD.UDF03= TA001+TA002 FROM MOCTA JOIN COPTD ON TA026=TD001 AND TA027=TD002 AND TA028=TD003 WHERE COPTD.UDF03=
  • COPTD.UDF04 訂單單身.寫入品號ROHS

自訂單頭欄位

自訂單身欄位

過渡使用

  • INVMB.UDF01 廠商代號及客戶產品代號,APR匯入備用