ET951
Country Reports
國家統計報告
Contents
00. Overview統計任何時段輸出至不同國家的金額和所佔百分比, 並加以排名. 國家編碼放在客戶檔的 Code 2 (三個字), 國家名稱放在系統編碼 COUNTRY + CODE 的第三欄. 大多數報表在執行前, 資料必預先在 ET911 做過資料倉儲匯出.
01. Country Sales Amount Ranking
| Date | 日期範圍. |
| Using | Booking dates:
依客戶下單日期擷取資料. 資料須先在 ET911 做過 Data
Warehouse 匯出動作. Shipping dates: 依預定出貨日期擷取資料. |
| Data ordered by | 資料可依訂單金額或國家名稱排列. |
| Company Nos. | 公司範圍. 若只要公司 1 和公司 2 之資料, 寫成 12. 空白表所有公司資料都要. |
| Currency to use | 金額加總使用之幣別. |
| Limit list size to | 限定只列印排名前幾名之筆數, 0 表示全部印出. |
| Print note | 列印附註. |
02. Country Shipment Amount Ranking
| Shipment date | 出貨日期, 亦即 invoice date. |
| Data ordered by | 資料可依出貨金額或國家名稱排列. |
| Company Nos. | 公司範圍. 若只要公司 1 和公司 2 之資料, 寫成 12. 空白表所有公司資料都要. |
| Currency to use | 金額加總使用之幣別. |
| Limit list size to | 限定只列印排名前幾名之筆數, 0 表示全部印出. |
| Print note | 列印附註. |
| Date | Version | Downloads | Actions | Explanations |
|---|---|---|---|---|
| 2012-1-7 | SP3 Secured | et911zip.exe, et951zip.exe, dwmsalec.exe, dwmshipc.exe. | After installation, re-do export to data warehouse (shipment) in ET911. | New addition: Country Shipment Amount Ranking - Per Origin. (Specifications of country of origin in shipment memos required.) |
| 2009-3-7 | SP3 Secured | et951zip.exe. | 程式翻新. |
| Code | Fields | Values | Explanations |
|---|---|---|---|
| ET951-LAYOUT-SALES | 3 | 5 numbers. | Country Sales Amount Ranking - Order by Amount. Default values: 0.0,1.0,3.0,4.0,7.0. |
| ET951-LAYOUT-SALES2 | 3 | 5 numbers. | Country Sales Amount Ranking - Order by Rank. Default values: 0.0,3.0,5.0,6.0,7.0. |
| ET951-LAYOUT-SHIPMENT | 3 | 5 numbers. | Country Shipment Amount Ranking - Order by Amount. Default values: 0.0,1.0,3.0,4.0,7.0. |
| ET951-LAYOUT-SHIPMENT2 | 3 | 5 numbers. | Country Shipment Amount Ranking - Order by Rank. Default values: 0.0,3.0,5.0,6.0,7.0. |
Last modified: March 2012