檢視 ERP Debug SQL code 的原始碼
←
ERP Debug SQL code
跳至導覽
跳至搜尋
由於以下原因,您無權編輯此頁面:
您請求的操作只有這個群組的使用者能使用:
使用者
您可以檢視並複製此頁面的原始碼。
==訂單品號與製令品號不符SQL碼== <sql> SELECT TA011,TC006,TC004,TD001,TD002,TD003,TA001,TA002,TD004,TA006,TD005,TA034,TD006,TA035 FROM COPTD JOIN MOCTA ON TD001=TA026 AND TD002=TA027 AND TD003=TA028 JOIN COPTC ON TD001=TC001 AND TD002=TC002 WHERE TA011<>'V' AND TA011<>'Y' AND TD004<>TA006 AND TA013<>'V' AND TA006 NOT LIKE'53%' ORDER BY TC006 </sql> ==已發製令未建BOM查詢== <sql> SELECT TA001,TA002,TA004,AMOUNT,TA006,TA034,TA035,TA013,TA011,TA010,TD020,COPTD.UDF01 FROM MOCTA LEFT JOIN (SELECT TB002,COUNT(TB003) AS AMOUNT FROM MOCTB WHERE TB001='5102' AND TB003<>'Z001' AND TB002 >='151109001' GROUP BY TB002)X ON TA002=TB002 JOIN COPTD ON TA026=TD001 AND TA027=TD002 AND TA028=TD003 WHERE TA001='5102' AND TA002 >='151109001' ORDER BY AMOUNT </sql> ==BOM電線用量異常檢視== #以訂單品號 <sql> SELECT RTRIM(MD001) AS MD001,X.MB002,X.MB003,MD002,RTRIM(MD003) AS MD003,Y.MB002 AS YMB002,MD006/MD007 AS AMOUNT,MD007,MD004,Y.MB007,MD017, (SELECT CASE WHEN CHARINDEX('x1C',Y.MB003)>0 THEN '1' ELSE '2' END) AS CORE ,BOMMD.MODI_DATE FROM BOMMD JOIN INVMB X ON MD001=X.MB001 JOIN INVMB Y ON MD003=Y.MB001 JOIN (SELECT TD004 FROM COPTD GROUP BY TD004)Z ON TD004=MD001 </sql> #以製令檢視 <sql> SELECT TA001,TA002,RTRIM(MD001) AS MD001,X.MB002,X.MB003,MD002,RTRIM(MD003) AS MD003,Y.MB002 AS YMB002,MD006/MD007 AS AMOUNT,MD007,MD004,Y.MB007,MD017, (SELECT CASE WHEN CHARINDEX('x1C',Y.MB003)>0 THEN '1' ELSE '2' END) AS CORE ,BOMMD.MODI_DATE FROM BOMMD JOIN INVMB X ON MD001=X.MB001 JOIN INVMB Y ON MD003=Y.MB001 JOIN (SELECT TA001,TA002,TA006 FROM MOCTA)Z ON TA006=MD001 WHERE TA001='5102' AND TA002 >'151101001' AND MD017='1' AND MD009='HM01' AND Y.MB007='302' </sql>
返回到「
ERP Debug SQL code
」。
導覽選單
個人工具
建立帳號
登入
命名空間
頁面
討論
臺灣正體
視圖
閱讀
檢視原始碼
檢視歷史
更多
搜尋
導覽
首頁
近期變更
隨機頁面
MediaWiki說明
工具
連結至此的頁面
相關變更
特殊頁面
頁面資訊