<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="zh-Hant-TW">
	<id>http://tskds213.synology.me/mediawiki/index.php?action=history&amp;feed=atom&amp;title=ERP%E8%87%AA%E5%8B%95%E5%AF%84%E7%99%BC%E9%83%B5%E4%BB%B6</id>
	<title>ERP自動寄發郵件 - 修訂紀錄</title>
	<link rel="self" type="application/atom+xml" href="http://tskds213.synology.me/mediawiki/index.php?action=history&amp;feed=atom&amp;title=ERP%E8%87%AA%E5%8B%95%E5%AF%84%E7%99%BC%E9%83%B5%E4%BB%B6"/>
	<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=ERP%E8%87%AA%E5%8B%95%E5%AF%84%E7%99%BC%E9%83%B5%E4%BB%B6&amp;action=history"/>
	<updated>2026-11-16T23:51:29Z</updated>
	<subtitle>本 wiki 上此頁面的修訂紀錄</subtitle>
	<generator>MediaWiki 1.43.5</generator>
	<entry>
		<id>http://tskds213.synology.me/mediawiki/index.php?title=ERP%E8%87%AA%E5%8B%95%E5%AF%84%E7%99%BC%E9%83%B5%E4%BB%B6&amp;diff=2695&amp;oldid=prev</id>
		<title>Root：​/* 超時單據 */</title>
		<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=ERP%E8%87%AA%E5%8B%95%E5%AF%84%E7%99%BC%E9%83%B5%E4%BB%B6&amp;diff=2695&amp;oldid=prev"/>
		<updated>2017-01-19T08:34:12Z</updated>

		<summary type="html">&lt;p&gt;&lt;span class=&quot;autocomment&quot;&gt;超時單據&lt;/span&gt;&lt;/p&gt;
&lt;table style=&quot;background-color: #fff; color: #202122;&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;zh-Hant-TW&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;←上個修訂&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;於 2017年1月19日 (四) 16:34 的修訂&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l2&quot;&gt;第2行：&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;第2行：&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;*每日超過14:00建立當日出貨之銷貨單&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;*每日超過14:00建立當日出貨之銷貨單&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;sql&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;sql&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;−&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;SELECT TH001,TH002,TH003,MA002,TH004,TH005,TH006,TG003,X.CREATE_DATE,X.CREATE_TIME FROM COPTH X&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;SELECT TH001,TH002,TH003,MA002,TH004,TH005,TH006,TG003,X.CREATE_DATE,X.CREATE_TIME  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;FROM COPTH X&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;JOIN COPTG Y ON TH001=TG001 AND TH002=TG002&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;JOIN COPTG Y ON TH001=TG001 AND TH002=TG002&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;JOIN COPMA ON MA001=TG004&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;JOIN COPMA ON MA001=TG004&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Root</name></author>
	</entry>
	<entry>
		<id>http://tskds213.synology.me/mediawiki/index.php?title=ERP%E8%87%AA%E5%8B%95%E5%AF%84%E7%99%BC%E9%83%B5%E4%BB%B6&amp;diff=2694&amp;oldid=prev</id>
		<title>Root：​新頁面: ==超時單據== *每日超過14:00建立當日出貨之銷貨單 &lt;sql&gt; SELECT TH001,TH002,TH003,MA002,TH004,TH005,TH006,TG003,X.CREATE_DATE,X.CREATE_TIME FROM COPTH X JOIN COPTG Y ON...</title>
		<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=ERP%E8%87%AA%E5%8B%95%E5%AF%84%E7%99%BC%E9%83%B5%E4%BB%B6&amp;diff=2694&amp;oldid=prev"/>
		<updated>2017-01-19T08:33:38Z</updated>

		<summary type="html">&lt;p&gt;新頁面: ==超時單據== *每日超過14:00建立當日出貨之銷貨單 &amp;lt;sql&amp;gt; SELECT TH001,TH002,TH003,MA002,TH004,TH005,TH006,TG003,X.CREATE_DATE,X.CREATE_TIME FROM COPTH X JOIN COPTG Y ON...&lt;/p&gt;
&lt;p&gt;&lt;b&gt;新頁面&lt;/b&gt;&lt;/p&gt;&lt;div&gt;==超時單據==&lt;br /&gt;
*每日超過14:00建立當日出貨之銷貨單&lt;br /&gt;
&amp;lt;sql&amp;gt;&lt;br /&gt;
SELECT TH001,TH002,TH003,MA002,TH004,TH005,TH006,TG003,X.CREATE_DATE,X.CREATE_TIME FROM COPTH X&lt;br /&gt;
JOIN COPTG Y ON TH001=TG001 AND TH002=TG002&lt;br /&gt;
JOIN COPMA ON MA001=TG004&lt;br /&gt;
WHERE TG003 = CONVERT(VARCHAR,GETDATE(),112)&lt;br /&gt;
AND X.CREATE_DATE=CONVERT(VARCHAR,GETDATE(),112) &lt;br /&gt;
AND X.CREATE_TIME &amp;gt;&amp;#039;14:00:00&amp;#039; AND ( TH001=&amp;#039;2302&amp;#039; OR TH001=&amp;#039;2303&amp;#039;)&lt;br /&gt;
AND TH020=&amp;#039;N&amp;#039;&lt;br /&gt;
&amp;lt;/sql&amp;gt;&lt;/div&gt;</summary>
		<author><name>Root</name></author>
	</entry>
</feed>