「WF自訂格式」:修訂間差異
跳至導覽
跳至搜尋
| 第2行: | 第2行: | ||
==目訂單身畫面== | ==目訂單身畫面== | ||
*COPTD.UDF01 訂單單身 銷製令 | *COPTD.UDF01 訂單單身 銷製令 | ||
*COPTD.UDF02 訂單單身 客單序號(精機序號專用) | *(done)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 | **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 | **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 訂單單身.製令(為了用訂單憑證印外箱單用) | *(done)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='' | **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月24日 (二) 09:59 的修訂
自訂單頭畫面
目訂單身畫面
- COPTD.UDF01 訂單單身 銷製令
- (done)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
- (done)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匯入備用
- INVMB.MB502 說明一 建BOM: Y、N
- INVMB.MB503 說明二 發料、不發、客供料