核銷報表.md
9 additions, 0 deletions
| ... | ... | @@ -14,6 +14,7 @@ |
| 14 | 14 | PRODUCT.PRODUCT_NAME AS 商品名稱, |
| 15 | + MEMBER_VOUCHER.ID AS 身份證字號, | |
| 15 | 16 | ACCOUNT.INVITE_CODE AS 會員編號, |
| 16 | 17 | PRODUCT.SERIAL_ID AS 核銷票券商品編號, |
| 17 | 18 | MEMBER_VOUCHER.EXCHANGE_NO AS 核銷票券序號, |
| 18 | 19 | CASE MEMBER_VOUCHER.EXCHANGE_STATUS |
| 19 | 20 | WHEN '1' THEN '已使用' |
| ... | ... | @@ -35,9 +37,17 @@ |
| 35 | 37 | FROM DBMT.SELFGEN_REDEMPTION) REDEMPTION |
| 36 | 38 | ON MEMBER_VOUCHER.SEQ_ID = TO_CHAR(REDEMPTION.EXCHANGEVOLUME_ID) AND REDEMPTION.RN = 1 |
| 39 | + | |
| 40 | + | |
| 41 | +## 匯出 | |
| 42 | +上述 SQL 執行完後直接在 SQL Developer 對查詢結果按右鍵，點「匯出」選項，視窗中的檔案類型從 insert table 改為 xlsx，修改檔名及儲存位置後下一步即可。 | |
| 43 | + | |
| 44 | +## TFS Wiki | |
| 45 | +[https://pialm01/tfs/DefaultCollection/EBTLXMYR01-MyRewards/_wiki/wikis/EBTLXMYR01-MyRewards.wiki/43177/%E8%87%AA%E5%BB%BA%E7%A5%A8%E5%88%B8%E6%A0%B8%E9%8A%B7%E5%A0%B1%E8%A1%A8](https://pialm01/tfs/DefaultCollection/EBTLXMYR01-MyRewards/_wiki/wikis/EBTLXMYR01-MyRewards.wiki/43177/%E8%87%AA%E5%BB%BA%E7%A5%A8%E5%88%B8%E6%A0%B8%E9%8A%B7%E5%A0%B1%E8%A1%A8) | |
| 46 | +MIMA 為當天日期西元年月日共 8 碼數字 (YYYYMMDD) |