###### tags: `NTM`
目錄
[TOC]
# 會員
### ==CE_MEMBER==：會員主檔(縮寫CMEM)
> CMEM_NUM：會員流水號
> CMEM_ID：會員身分證字號，若未驗證身份(卡友或員工)，則為BN開頭。
> CMEM_NAME：會員姓名
## 集團員工
### ==CE_EMPLOYEE==：關係企業員工資料檔
> CMEM_ID：身分證字號
> CEMP_STATUS：員工狀態 -> 0:離職 1:在職
* 每次匯入名單時，都會將所有人狀態壓成離職，再新Insert一筆在職的資料，因此同一個人會有多筆資料，但只會有一筆是在職。
> MAPPING：CE_EMPLOYEE.CMEM_ID = CE_MEMBER.CMEM_ID
> [color=#907bf7]
# 商品
### ==CE_PRODUCT==：商品報價單(縮寫CPRO)
> CPRO_NUM：商品QC
> CPRO_STORAGE：庫存量
> CPRO_SAFESTO：安全庫存量
> 可售數量 = 庫存 - 安全庫存
* 報價單 = 一樣商品
### ==CE_PRODETAIL==：商品上架單(縮寫CPDT)
> CPDT_NUM：商品流水號
> CPDT_PRICE：售價
> CPDT_STARTDAY：上架日
> CPDT_ENDDAY：下架日
> CPDT_STATUS：商品狀態 -> 0:下架 1:上架
> CPDT_CHECK：審核狀態 -> 3:審核通過
> CPDT_SEARCHFLAG：是否可被搜尋 -> Y:可以 N:不可 6:僅TM顯示
* 上架單 = 一樣商品的一種價格
> MAPPING：CE_PRODETAIL.CPRO_NUM = CE_PRODUCT.CPRO_NUM
> [color=#907bf7]
## 多規格商品
### ==CE_PROGROUP==：商品群組(縮寫CPRG)
> CPRG_NUM：商品群組編號
* MAPPING：CE_PROGROUP.CPRG_NUM = CE_PRODUCT.CPRG_NUM
* API：product/MallProduct裡已有回傳同群組商品(body/Standard)
```jsonld=
"CpdtNum": 35819048,
"Name": "任天堂 Switch 健身環大冒險+Joy-Con左右控制器(紫橙)",
(略)
"Standard": [{"CpdtNum": 35819044,"Name": "電光紅&電光藍手把"},
{"CpdtNum": 35819045,"Name": "綠色&粉紅"},
{"CpdtNum": 35819046,"Name": "灰色"},
{"CpdtNum": 35819047,"Name": "藍&電光黃"},
{"CpdtNum": 35819048,"Name": "紫橙"}],
```
## 館別
### ==CE_PROSPACE==：大館(縮寫CPSE)
> CPSE_ID：大館編號(eg.MR)
> CPSE_NAME：大館名稱(eg.國泰優惠)
### ==CE_PRONEWHALL==：小館(縮寫CPNHL)
> CPSE_ID：小館編號(eg.MR01)
> CPSE_NAME：小館名稱
> MAPPING：CE_PRONEWHALL.CPSE_NUM = CE_PROSPACE.CPSE_NUM
> [color=#907bf7]
### ==CE_PROTYPE==：次館(縮寫CPTE)
> CPSE_ID：次館編號(eg.MR0102)
> CPSE_NAME：次館名稱
> MAPPING：CE_PROTYPE.CPNHL_NUM = CE_PRONEWHALL.CPNHL_NUM
> [color=#907bf7]
### ==CE_PROITEM==：次次館(縮寫CPTM)
> CPSE_ID：次次館編號(eg.MR010203)
> CPSE_NAME：次次館名稱
> MAPPING：CE_PROITEM.CPTE_NUM = CE_PROTYPE.CPTE_NUM
> [color=#907bf7]
### ==CE_PRODETAIL_HALL==：商品對應館別
> 商品：CE_PRODETAIL_HALL.CPDT_NUM = CE_PRODETAIL.CPDT_NUM
> 次次館：CE_PRODETAIL_HALL.CPTM_NUM = CE_PROITEM.CPTM_NUM
# 訂單
### ==SHOPPINGCART==：購物車(縮寫CART)
> CART_NO：購物車流水號
> CART_ID：購物車編號(SMRN+6碼日期+5碼流水號) eg.SMRN20071512345
> CART_CASH：使用多少現金
> INVOICE_NO：發票號碼
> CMEM_NUM：購買人會員流水號
> CART_WCASH：使用多少小樹點
> 會員MAPPING：SHOPPINGCART.CMEM_NUM = CE_MEMBER.CMEM_NUM
> [color=#907bf7]
### ==CE_ORDER==：訂單主檔(縮寫CORD)
> CORD_NUM：訂單流水號
> CORD_ID：訂單編號(MRNC+6碼日期+5碼流水號) eg.MRNC20071512345
> CMEM_NUM：會員流水號
> CORD_DAY：訂單日
> CORD_STATUS：訂單狀態，對應到 CE_MD_CORD_STATUS (見下方參考資料)
> CORD_STATUSDAY：訂單狀態最後更新日
> CORD_CASH：使用多少現金
> CORD_WCASH：使用多少小樹點
> CORD_WCASH_RATE：小樹點匯率
> 購物車MAPPING：CE_ORDER.CART_NO = SHOPPINGCART.CART_NO
> 會員MAPPING：CE_ORDER.CMEM_NUM = CE_MEMBER.CMEM_NUM
> [color=#907bf7]
### ==CE_ITEM==：訂單明細檔(縮寫CITE)
> CITE_NUM：流水號
> CORD_NUM：對應到CE_ORDER
> CITE_WCASH：使用多少小樹點
> CITE_WCASH_RATE：小樹點匯率
> 訂單MAPPING：CE_ITEM.CORD_NUM = CE_ORDER.CORD_NUM
> [color=#907bf7]
### ==CE_STATUS_DATE==：訂單狀態更新時間LOG
> CSTS_0：
> CSTS_1：
> ...
* 當CE_ORDER.CORD_STATUS更動時，需一併寫入時間至對應狀態的欄位
* 沒有CSTS_10: 未授權訂單
# 金流
### ==CE_ORDFINANCE==：帳務主檔
> CFNC_NUM：流水
> CORD_NUM：訂單流水號
> CFNC_SETTLE：請款狀態 0:未請款 1:可請款 2:已請款 3:取消請款 4:可退款 5:已退款 6:不用請退 7:不用退款
> 訂單MAPPING：CE_ORDFINANCE.CORD_NUM = CE_ORDER.CORD_NUM
> [color=#907bf7]
*
### ==FINANCE_CARSCASH_HEADER==：現金請退款主檔
> CART_NO：購物車流水號
> PAYMENT_STATUS：請退款註記：1可請款 2已請款 3取消請款 4可退款 5已退款
> CASH：金額
> PAYMENT_DATE：
> 購物車MAPPING：FINANCE_CARSCASH_HEADER.CART_NO = SHOPPINGCART.CART_NO
> [color=#907bf7]
*
### ==FINANCE_CARSCASH_HEADER_ORDER==：現金請退款明細
> CARSCASH_ID：現金請退款主檔流水號
> CORD_NUM：訂單編號
> CORD_CASH：訂單現金金額
> 請退款主檔MAPPING：FINANCE_CARSCASH_HEADER_ORDER.CARSCASH_ID = FINANCE_CARSCASH_HEADER.ID
> 訂單MAPPING：FINANCE_CARSCASH_HEADER_ORDER.CORD_NUM = CE_ORDER.CORD_NUM
> 訂單金額MAPPING：FINANCE_CARSCASH_HEADER_ORDER.CORD_CASH = CE_ORDER.CORD_CASH
> [color=#907bf7]
# 發票
### ==SYM_BEFINV==：發票主檔
> BEFINV_NUM：流水號
> CART_NO：購物車編號
> BEFINV_CORDNUM：訂單流水號
> BEFINV_OLDINVSN：統一發票號碼(英文2字+9碼數字，末一碼為檢查碼)
> BEFINV_DELIVERFLAG：0:未索取 1:索取配送中 2:已寄送 3:取消 4:可退 5:已退 6:先出發票
> BEFINV_OLDTYPE：發票格式(2：二聯3：三聯)
> PRINT_MARK：Y
> 訂單MAPPING：CE_ITEM.CORD_NUM = CE_ORDER.CORD_NUM
> [color=#907bf7]
* VEC訂單以購物車為單位開發票，只寫CART_NO，不寫BEFINV_CORDID
:::danger
**注意：負向退貨的發票也要寫入**
:::
```
NTM訂單發票範例
欄位 正向訂單 負向訂單
--------------------|-------------------|-------------------|
BEFINV_NUM |6340705 |6344286 |
BEFINV_CORDNUM |0 |0 |
BEFINV_TRNDATE |2020-07-10 23:05:46|2020-07-14 17:00:23|
BEFINV_TRNPEOPLE |0 |3977 |
BEFINV_OLDINVSN |EA476861235 |EA476861235 |
BEFINV_OLDDATE |2020-07-10 23:05:46|2020-07-10 00:00:00|
BEFINV_OLDMONEY |2780 |-2780 |
BEFINV_OLDPOINT |0 |0 |
BEFINV_OLDTYPE |2 |2 |
BEFINV_OLDREGNO | | |
BEFINV_OLDTITLE | | |
BEFINV_INVSTATUS |1 |2 |
BEFINV_VERIFYSTATUS |1 |1 |
BEFINV_REMARK |ORDER COMPONENT |ORDER COMPONENT |
BEFINV_CORDID | | |
BEFINV_WINFLAG |0 |0 |
BEFINV_DELIVERFLAG |3 |0 |
BEFINV_DELIVERDATE | | |
BEFINV_PODATE | | |
BEFINV_DELIVERPEOPLE| | |
BEFINV_RETURNDATE | | |
BEFINV_FTPFLAG |3 |0 |
BEFINV_FTPDATE |2020-07-11 01:07:34| |
ERP_SALESNO | | |
ERP_NO | | |
ERP_TOKENTIME | | |
NUM_RTN | | |
ACCOUNT_DATE |2020-07-13 00:00:00| |
WRITEOFF_FLAG |0 |0 |
WRITEOFF_DATE | | |
CART_NO |3418014 |3418014 |
BEFINV_TAX |0 |0 |
BEFINV_TAXAMOUNT |0 |0 |
ERP_AR |0 |0 |
INVOICE_FLAG |0 |0 |
CARRIER_TYPE |3J0002 | |
CARRIER_ID |/40N-WN2 | |
NPOBAN | | |
RANDOM_NUMBER |7689 | |
PRINT_MARK |N | |
SAP_UPLOAD_DAY |2020-07-11 07:01:42| |
SAP_CHANGE_DAY | | |
```
### ==SYM_BEFINV_ORDER==：發票明細
> BEFINV_NUM：發票流水號
> CORD_NUM：訂單流水號
> CORD_CASH：開立發票金額
> 發票MAPPING：SYM_BEFINV_ORDER.BEFINV_NUM = SYM_BEFINV.BEFINV_NUM
> 訂單MAPPING：SYM_BEFINV_ORDER.CORD_NUM = CE)ORDER.CORD_NUM
> [color=#907bf7]
* 負向退貨的發票不需寫入
```
Name |Value |
----------|--------|
ID |1716063 |
BEFINV_NUM|6344286 |
CORD_NUM |34508583|
CORD_CASH |2780 |
```
# 物流
### ==CE_ORDABNORMAL==：訂單退換貨主檔
> CORD_NUM：訂單流水號
> COAN_STATUS：退貨狀態 (3:缺貨 6:退貨 8:換貨 Q:預換 P:預退)
> COAN_REMARK：預退、預換說明
> 訂單MAPPING：CE_ORDABNORMAL.CORD_NUM = CE_ORDER.CORD_NUM
> [color=#907bf7]
* 申請退貨時需寫入，狀態押P: 預退
# NTM紀錄LOG用
### ==RS_MEMBER_BINDED==：Treemall會員與Orca會員綁訂表
> CMEM_NUM：神坊會員編號
> RS_MEMBER：Orca會員編號
> RSMB_STATUS：狀態 (10：已綁訂、11：已解除綁訂)
> MAPPING：RS_MEMBER_BINDED.CMEM_NUM = CE_MEMBER.CMEM_NUM
> [color=#907bf7]
### ==RS_MEMBER_BINDED_LOG==：Treemall會員與Orca會員綁訂紀錄LOG
> RSMB_NUM：對應綁訂表
> RSMB_STATUS_DATE：狀態異動日期
> MAPPING：RS_MEMBER_BINDED_LOG.RSMB_NUM = RS_MEMBER_BINDED.RSMB_NUM
> [color=#907bf7]
### ==RS_STATUS_DATE==：排程紀錄
> CORD_NUM：訂單流水號
> RSTS_S01：退貨完成回寫NTM訂單狀態成功
> 發票MAPPING：RS_STATUS_DATE.CORD_NUM = CE_ORDER.CORD_NUM
> [color=#907bf7]
### ==RS_ORDER_BINDED==：VEC扣泰贈點紀錄(無使用)
> BEFINV_NUM：發票流水號
> CORD_NUM：訂單流水號
> CORD_CASH：開立發票金額
> 發票MAPPING：SYM_BEFINV_ORDER.BEFINV_NUM = SYM_BEFINV.BEFINV_NUM
> 訂單MAPPING：SYM_BEFINV_ORDER.CORD_NUM = CE)ORDER.CORD_NUM
> [color=#907bf7]
### ==CHANNEL_LOG==：呼叫NTM的API紀錄
> CHANNEL_ID：平台識別碼 (NTM是55)
> PROJ_NAME：程式專案名稱 (NTM是NTM_API)
> API_NAME：API名稱
> REQ_MSG：REQUEST BODY內容
> RES_MSG：RESPONSE BODY內容
> CMEM_NUM：會員流水號
> 會員MAPPING：CHANNEL_LOG.CMEM_NUM = CE_MEMBER.CMEM_NUM
> [color=#907bf7]
```
CHANNEL_LOG_NUM |275381
CHANNEL_ID |55
PROJ_NAME |NTM_API
API_NAME |OrderDetail
REQ_MSG |{"header":{"txSn":"20071603281000173684","txId":"ntm0002"},"body":{"UserKey":"133c89f5e480991e6e81887f4858a1bcec4db4bb25644b7173ea0df4e059c35b","UserNum":2299651,"CartId":"SMRN20032336991","OrderId":"MRNC20032345495"}}
RES_MSG |{"header":{"txSN":"20071603281000164141","txID":"ntm0002","rtnMsg":"成功","rtnCode":"E000"},"body":{"Order":[{"Status":"貨到","Item":{"EPoint":0,"FreePoint":0,"WalletCash":0,"Qty":1,"Point":0,"Change":"Y","Cash":299,"ImgUrl":"https://www.treemall.com.tw/reward/Hall/90/imageQC28869303.jpg","CpdtNum":"35814023","ECoupon":0,"CiteNum":17006846,"Name":"***mAh"},"Invoice":{"Zip":"236","Status":"未索取","Address":"***10樓","Number":"EA47687205","Request":"Y","InvType":"電子發票","Carrier":"會員載具","Name":"***順","Remark":""},"Return":"Y","Cancel":"N","TradeMode":"信用卡","CanReturnOrder":true,"Carrier":"0","Delivery":{"Zip":"236","Address":"***10樓","Message":"新竹貨運1938676364","Change":"N","Step":[{"time":1594474892,"status":"未授權訂單"},{"time":1594475060,"status":"貨物待處理"},{"time":1594610734,"status":"貨到"}],"Mobile":"***579","Url":"MRNC20071109638","Name":"***順"},"OrderId":"MRNC20071109638"}],"Return":"Y","Platform":"NTM","Cancel":"N","CartId":"SMRN20071177905","Change":"Y","Name":"***lee","CartDay":"2020/07/11 21:41:32"}}
CMEM_NUM |2299651
IN_TIME |2020-07-16 11:28:11.986
INS_USER |NTM_API
RETURN_CODE |E000
REQUEST_IP |18.182.219.162
REQUEST_PATH |http://3.113.54.212:8080/treemall/order/OrderDetail
REQUEST_DATE |2020-07-16 11:28:10.299
RESPONSE_DATE |2020-07-16 11:28:11.986
REQUEST_HEADER |{"content-length":"231","host":"3.113.54.212:8080","connection":"keep-alive","content-type":"application/json","accept-encoding":"gzip, deflate","user-agent":"python-requests/2.22.0","accept":"*/*","signcode":"ad5c7d53448991410b1dd6b84f6f408c479061b676b7598c44b2794583829039"}
RS_MEMBER |
TOKEN |
ERROR_MSG |
```
# 參考資料
### ==CE_MD_CORD_STATUS==：訂單狀態
```
(僅列出常用)
0 貨物待處理
1 貨物處理中
2 貨到
3 缺貨
4 授權失敗
5 取消訂單
6 退貨
7 配送異常
8 換貨
9 判退取消
10 未授權訂單
P 預退
```
Sign in with Wallet
Connect another wallet