目前分類：BI商業智慧 (16)
- May 05 Thu 2011 16:48
集團合併銷貨客戶統計表 (SQL 範例)
- May 05 Thu 2011 16:47
集團應收帳齡資訊一覽表(SQL 範例)
- May 05 Thu 2011 16:47
未結工單明細表(SQL 範例)
- May 05 Thu 2011 16:46
集團即將逾期應收帳款統計表(SQL 範例)
- May 05 Thu 2011 16:46
集團逾期應收帳款資訊一覽表(SQL 範例)
- May 05 Thu 2011 16:46
集團AR應收帳款彙總表(SQL 範例)
- May 05 Thu 2011 16:46
集團AP應付帳款彙總表(SQL 範例)
- May 05 Thu 2011 16:45
BOM產品結構尾階料價格分析表(SQL 範例)
SELECT plant,XPATH,x1,x2,x3,x4,x5,x6,to_char(cdate,'yyyy/mm/dd') cdate,D1,D2,D3,D4,D5,D6,D7,D8,D9,D10,D11,D12,p0a,p1a,1,p2a,p3a,p4a,p5a,p6a FROM ( SELECT DISTINCT 'ds' plant,XPATH,x1,x2, x3, x4, x5,x6,cdate, p0a, p1a, p2a, p3a, p4a, p5a, p6a,D1,D2,D3,D4,D5,D6,D7,D8,D9,D10,D11,D12
- May 05 Thu 2011 16:06
BOM產品結構尾階料價格分析表(SQL 範例)
SELECT plant,XPATH,x1,x2,x3,x4,x5,x6,to_char(cdate,'yyyy/mm/dd') cdate,D1,D2,D3,D4,D5,D6,D7,D8,D9,D10,D11,D12,p0a,p1a,1,p2a,p3a,p4a,p5a,p6a FROM ( SELECT DISTINCT 'ds' plant,XPATH,x1,x2, x3, x4, x5,x6,cdate, p0a, p1a, p2a, p3a, p4a, p5a, p6a,D1,D2,D3,D4,D5,D6,D7,D8,D9,D10,D11,D12
- May 05 Thu 2011 16:06
集團AP應付帳款彙總表(SQL 範例)
- May 05 Thu 2011 16:06
集團AR應收帳款彙總表(SQL 範例)
- May 05 Thu 2011 16:05
集團逾期應收帳款資訊一覽表(SQL 範例)
- May 05 Thu 2011 16:05
集團即將逾期應收帳款統計表(SQL 範例)
- May 05 Thu 2011 16:04
未結工單明細表(SQL 範例)
- May 05 Thu 2011 15:50
集團應收帳齡資訊一覽表(SQL 範例)
- May 05 Thu 2011 15:50
集團合併銷貨客戶統計表 (SQL 範例)
站台介紹 (1)