「出貨管理」:修訂間差異
新頁面: ==出貨條碼管理== *[https://play.google.com/store/apps/details?id=hk.com.nexinno.barcodegun VvScanner APP] * 印外箱單時 產生箱號流水號(每箱均不同箱號) 並把該... |
|||
| (未顯示同一使用者於中間所作的 3 次修訂) | |||
| 第1行: | 第1行: | ||
==出貨條碼管理== | ==出貨條碼管理== | ||
*增加INPUTBOXNO | |||
**INID:箱號 | |||
**INPUTDATE:輸入日期 | |||
**OUT:(未來將用於是否已檢貨) | |||
*查詢今日應出箱號 | |||
<SQL> | |||
SELECT ID,CONTENT FROM v_COPTGH JOIN COPTD ON TH014=TD001 AND TH015=TD002 AND TH016=TD003 JOIN BOXNO ON CONTENT=TD054 WHERE TG003='20160407' | |||
</SQL> | |||
*抓取同箱號中的某製令及相關資訊寫入INPUTBOXNO中 | |||
<SQL> | |||
UPDATE INPUTBOXNO SET MAKENO=CONTENT,CUSTOMER=TD041,PARTNO=TD004,NAME=TD005,SPEC=TD006,BOXMETHOD=ABOX FROM | |||
INPUTBOXNO JOIN | |||
(SELECT ID,CONTENT,TD041,TD004,TD005,TD006,ABOX FROM (Select ID,CONTENT,ABOX From ( | |||
Select ID,INID,CONTENT,ABOX, | |||
ROW_NUMBER() Over (Partition By INID Order By CONTENT Desc) As Sort From INPUTBOXNO JOIN BOXNO ON ID=INID) TMP_S | |||
Where TMP_S.Sort=1)X JOIN COPTD ON TD054=CONTENT) Y ON ID=INID WHERE CONVERT(VARCHAR(10),NEWTIME,112)='20160412' | |||
</SQL> | |||
==箱號進出管理系統== | |||
*2018/07/18規畫 | |||
**刷箱號取得客戶名及代表製令建檔 | |||
<SQL> | |||
SELECT ID,MAKENO,TC075 AS CU | |||
FROM( | |||
SELECT distinct ID, | |||
( | |||
SELECT TOP 1 CONTENT | |||
FROM BOXNO AS T2 | |||
WHERE T2.ID = T1.ID AND T2.ID LIKE '1807180%' | |||
) AS MAKENO | |||
FROM BOXNO AS T1 | |||
WHERE T1.ID LIKE '1807180%' | |||
)X JOIN v_COPTCD ON TD054=MAKENO | |||
</SQL> | |||
*依銷貨日取得應出庫之製令及箱號 | |||
<SQL> | |||
SELECT ISNULL(BNO,'')BNO,TG003,STATUS,TA002,MA002,TD004,TD014,TD008,TD009,SMC007,TH020 FROM v_NEWCOPTCD | |||
LEFT JOIN | |||
(SELECT BNO,CONTENT,STATUS FROM HMBOXIO | |||
JOIN BOXNO ON ID=BNO | |||
)X | |||
ON TA002 = CONTENT | |||
LEFT JOIN v_INVMC01 ON MC001=TD004 | |||
WHERE TG003='20180620' AND TH001='2302' AND TD001='2202'AND TC004<>'197B' AND TC004<>'0197' | |||
</SQL> | |||
==舊規畫== | |||
*[https://play.google.com/store/apps/details?id=hk.com.nexinno.barcodegun VvScanner APP] | *[https://play.google.com/store/apps/details?id=hk.com.nexinno.barcodegun VvScanner APP] | ||
* 印外箱單時 產生箱號流水號(每箱均不同箱號) 並把該箱的製令or所有製令寫入資料庫 未來出貨時 將所有箱號刷好 比對箱號之所有製令對應當天銷貨單的製令 確認是否有出錯貨 | * 印外箱單時 產生箱號流水號(每箱均不同箱號) 並把該箱的製令or所有製令寫入資料庫 未來出貨時 將所有箱號刷好 比對箱號之所有製令對應當天銷貨單的製令 確認是否有出錯貨 | ||
於 2018年7月19日 (四) 17:23 的最新修訂
出貨條碼管理
- 增加INPUTBOXNO
- INID:箱號
- INPUTDATE:輸入日期
- OUT:(未來將用於是否已檢貨)
- 查詢今日應出箱號
<SQL> SELECT ID,CONTENT FROM v_COPTGH JOIN COPTD ON TH014=TD001 AND TH015=TD002 AND TH016=TD003 JOIN BOXNO ON CONTENT=TD054 WHERE TG003='20160407' </SQL>
- 抓取同箱號中的某製令及相關資訊寫入INPUTBOXNO中
<SQL> UPDATE INPUTBOXNO SET MAKENO=CONTENT,CUSTOMER=TD041,PARTNO=TD004,NAME=TD005,SPEC=TD006,BOXMETHOD=ABOX FROM INPUTBOXNO JOIN (SELECT ID,CONTENT,TD041,TD004,TD005,TD006,ABOX FROM (Select ID,CONTENT,ABOX From ( Select ID,INID,CONTENT,ABOX, ROW_NUMBER() Over (Partition By INID Order By CONTENT Desc) As Sort From INPUTBOXNO JOIN BOXNO ON ID=INID) TMP_S Where TMP_S.Sort=1)X JOIN COPTD ON TD054=CONTENT) Y ON ID=INID WHERE CONVERT(VARCHAR(10),NEWTIME,112)='20160412' </SQL>
箱號進出管理系統
- 2018/07/18規畫
- 刷箱號取得客戶名及代表製令建檔
<SQL> SELECT ID,MAKENO,TC075 AS CU FROM( SELECT distinct ID, (
SELECT TOP 1 CONTENT FROM BOXNO AS T2 WHERE T2.ID = T1.ID AND T2.ID LIKE '1807180%'
) AS MAKENO FROM BOXNO AS T1 WHERE T1.ID LIKE '1807180%' )X JOIN v_COPTCD ON TD054=MAKENO </SQL>
- 依銷貨日取得應出庫之製令及箱號
<SQL> SELECT ISNULL(BNO,)BNO,TG003,STATUS,TA002,MA002,TD004,TD014,TD008,TD009,SMC007,TH020 FROM v_NEWCOPTCD LEFT JOIN (SELECT BNO,CONTENT,STATUS FROM HMBOXIO JOIN BOXNO ON ID=BNO
)X
ON TA002 = CONTENT
LEFT JOIN v_INVMC01 ON MC001=TD004 WHERE TG003='20180620' AND TH001='2302' AND TD001='2202'AND TC004<>'197B' AND TC004<>'0197' </SQL>
舊規畫
- VvScanner APP
- 印外箱單時 產生箱號流水號(每箱均不同箱號) 並把該箱的製令or所有製令寫入資料庫 未來出貨時 將所有箱號刷好 比對箱號之所有製令對應當天銷貨單的製令 確認是否有出錯貨