ERP自動寄發郵件
超時單據
- 每日超過14:00建立當日出貨之銷貨單
<sql> SELECT TH001,TH002,TH003,MA002,TH004,TH005,TH006,TG003,X.CREATE_DATE,X.CREATE_TIME FROM COPTH X JOIN COPTG Y ON TH001=TG001 AND TH002=TG002 JOIN COPMA ON MA001=TG004 WHERE TG003 = CONVERT(VARCHAR,GETDATE(),112) AND X.CREATE_DATE=CONVERT(VARCHAR,GETDATE(),112) AND X.CREATE_TIME >'14:00:00' AND ( TH001='2302' OR TH001='2303') AND TH020='N' </sql>