| Name | Description | Type | Additional information |
|---|---|---|---|
| store_id |
專櫃編號 |
string |
None. |
| contract_id |
合約編號 |
string |
None. |
| total_amt |
銷售總金額 |
decimal number |
None. |
| total_sales_amt |
銷售總金額 |
decimal number |
None. |
| total_qty |
銷售總數量 |
integer |
None. |
| disc_amt |
銷售總折扣 |
decimal number |
None. |
| disc_rate |
銷售總折扣 |
string |
None. |
| rate_amt |
銷售總稅額 |
decimal number |
None. |
| extra_amt |
溢收金額 |
decimal number |
None. |
| sell_invoice |
發票號碼 |
string |
None. |
| sell_no |
交易序號 |
string |
None. |
| tday |
發生日 |
string |
None. |
| sell_day |
銷售日 |
string |
None. |
| sell_time |
銷售時間 |
string |
None. |
| sell_posid |
POS機號 |
string |
None. |
| sell_shopid |
分店編號 |
string |
None. |
| sell_accountid | string |
None. |
|
| sell_transtype |
交易型態 |
string |
None. |
| sell_org_no |
原始交易日期 |
string |
None. |
| sell_org_day |
原始交易序號 |
string |
None. |
| sell_org_posid |
原始交易機號 |
string |
None. |
| sell_org_tday | string |
None. |
|
| vip_no |
會員卡號 |
string |
None. |
| comp_id |
統一編號 |
string |
None. |
| eui_vehicle_type |
電子發票載具種類(共通載具=0,悠遊卡載具=2) |
string |
None. |
| eui_vehicle_no |
電子發票載具卡號 |
string |
None. |
| eui_random_code |
電子發票防偽隨機碼 |
string |
None. |
| eui_print |
紙本電子發票列印狀態 '0':沒有 '1':有 |
string |
None. |
| eui_print_trans |
銷售清單列印狀態 '0':沒有 '1':有 |
string |
None. |
| eui_donate |
電子發票捐贈狀態 '0':沒有 '1':有 |
string |
None. |
| eui_donate_no |
愛心碼 |
string |
None. |
| eui_donate_status |
為愛心碼捐贈狀態 '0':沒有 '1':有 |
string |
None. |
| eui_universal_status |
為共通載具狀態 '0':沒有 '1':有 |
string |
None. |
| eui_vehicle_type_no |
電子發票載具類別編號 |
string |
None. |
| eui_vehicle_no_hidden |
電子發票載具隱碼 |
string |
None. |
| sell_casher |
電子發票載具類別編號 |
string |
None. |
| sell_trans_status |
銷售狀態 |
string |
None. |
| eui_print_cnt |
列印次數 |
integer |
None. |
| tenants_sell_posid |
租戶的收款機號 |
string |
None. |
| tenants_sell_no |
租戶交易序號 |
string |
None. |
| tenants_sell_day |
租戶銷售日期 yyyy/MM/dd |
string |
None. |
| tenants_sell_time |
租戶銷售時間 HH:mm |
string |
None. |
| tenants_sell_org_day |
租戶原始的交易日期 |
string |
None. |
| tenants_sell_org_no |
租戶原始的交易序號 |
string |
None. |
| tenants_sell_org_posid |
租戶原始的交易機號 |
string |
None. |
| tenants_sell_transtype |
租戶原始的交易型態 |
string |
None. |
| account_type |
MPos交易型態 10:商品交易(無支付)、11:商品交易(有支付)、20:直接上送交易 |
string |
None. |
| parking_token |
停車 token |
string |
None. |
| skm_info |
外接訊息 |
string |
None. |
| vip_point_registered |
會員累點狀態 |
string |
None. |
| vip_point_recheckId |
會員累點ID |
string |
None. |
| invoice_amt |
發票金額 |
decimal number |
None. |
| sell_detail |
銷售明細 |
Collection of sell_detail |
None. |
| tender_detail |
付款明細 |
Collection of tender_detail |
None. |
| return_detail |
已退商品明細 |
Collection of sell_detail |
None. |
| re_goods_status |
退貨狀態 |
string |
None. |
| nrt_cardno |
外交官證號 |
string |
None. |
| vip_before_point |
PI會員點數用 |
integer |
None. |
| vip_before_point_dec | decimal number |
None. |
|
| vip_use_point |
PI會員點數用 |
integer |
None. |
| vip_use_point_dec | decimal number |
None. |
|
| vip_new_point |
PI會員點數用 |
integer |
None. |
| vip_new_point_dec | decimal number |
None. |
|
| pre_sales_status |
預售狀態 |
string |
None. |
| sell_casher_auth |
授權者id ( 紀錄退貨授權人使用 ) |
string |
None. |
| vip_expiry_date |
會員卡期限 |
string |
None. |
| parking_json |
停車資訊 |
string |
None. |
| vip_info |
會員資訊 |
string |
None. |
| org_trans_barcode |
原始銷售條碼 |
string |
None. |
| braceletDeposited |
為手環儲值或退款 |
string |
None. |
| entertainment_tax_amt |
娛樂稅總額(由D加總) |
decimal number |
None. |
| sell_job_id |
班別 |
string |
None. |
| hg_vip_no |
HappyGo 卡號 |
string |
None. |
| hg_return_code |
HappyGo回傳代碼 |
string |
None. |
| hg_upd_flag |
HappyGo是否已執行累點 |
string |
None. |
| hg_reward_amt |
HappyGo可累點金額 |
decimal number |
None. |
| hg_reward_point |
HappyGo可累積點數 |
integer |
None. |
| vip_reward_amt |
會員可累點金額 |
decimal number |
None. |
| staff_sales_status |
員購狀態 |
string |
None. |
| is_changed |
發票是否換開 Y是 |
string |
None. |
| vip_limit_point_date |
會員點數到期日 |
string |
None. |
| vip_limit_point |
會員到期點數 |
integer |
None. |
| vip_limit_point_dec | decimal number |
None. |
|
| special_no |
特約編號 |
string |
None. |
| logistics_no |
物流單編號 |
string |
None. |
| logistics_status |
物流單狀態 |
string |
None. |
| logistics_goods_status |
物流單商品狀態 |
string |
None. |
| input_type |
報帳交易 |
string |
None. |
| order_no |
訂單 |
string |
None. |
| tra_no |
特約商店代碼 |
string |
None. |
| extra_no | string |
None. |
|
| invitation_no |
邀請函號碼 |
string |
None. |
| vip_point_amt |
可累積點數金額 |
decimal number |
None. |
| vip_point_source |
會員累點來源 |
string |
None. |
| copy_flag |
複製狀態 |
string |
None. |
| nd_type |
交易歸屬抽成 |
string |
None. |
| staffBalance |
員購剩餘額度 |
integer |
None. |
| staffUsedAmt |
員購使用額度 |
integer |
None. |
| staffMealBalance |
員餐剩餘額度 |
integer |
None. |
| staffMealUsedAmt |
員餐使用額度 |
integer |
None. |
| tenant_serial_no | string |
None. |
|
| sale_count | integer |
None. |
|
| bs_print_flag | string |
None. |
|
| bs_print_time | string |
None. |
|
| meal_pickup_number | string |
None. |
|
| meal_pickup_type | string |
None. |
|
| egui_request | string |
None. |
|
| consumer_mobile_no | string |
None. |
|
| erp_vip_no | string |
None. |
|
| consumer_name | string |
None. |
|
| meal_send_server | string |
None. |
|
| vip_phone | string |
None. |
|
| vip_uid | string |
None. |
|
| m_orderno | string |
None. |
|
| ownname | string |
None. |
|
| gogoro_orderType | string |
None. |
|
| receptType | string |
None. |
|
| braceletPostValue | integer |
None. |
|
| braceletPreValue | integer |
None. |
|
| bracelet_id | string |
None. |
|
| bracelet_outerId | string |
None. |
|
| has_coupon | string |
None. |
|
| sales_id | string |
None. |
|
| parking_customer_type | string |
None. |
|
| fpqqlsh | string |
None. |
|
| partner_no | string |
None. |
|
| parking_record_type | string |
None. |
|
| inputVipNo | string |
None. |
|
| couponGroupNo | string |
None. |
|
| rtn_tender_type | string |
None. |
|
| vip_muid | string |
None. |
|
| order_origin | string |
None. |
|
| order_status | string |
None. |
|
| order_type | string |
None. |
|
| paid_amt | decimal number |
None. |
|
| other_amt | decimal number |
None. |
|
| use_date | string |
None. |
|
| balance | decimal number |
None. |
|
| vip_name | string |
None. |
|
| vip_level | string |
None. |
|
| vip_gender | string |
None. |
|
| vip_birth | string |
None. |
|
| m_order_no | string |
None. |
|
| change_status | string |
None. |
|
| m_pmt_discount | m_pmt_discount |
None. |
|
| grade | string |
None. |
|
| grade_discount | string |
None. |
|
| vip_id | string |
None. |
|
| discount_percent | string |
None. |
|
| staff_id | string |
None. |
|
| staff_type | string |
None. |
|
| prom40_count | integer |
None. |
|
| deposit_status | string |
None. |
|
| bad_yn | string |
None. |
|
| prize_list | Collection of type_list_detail |
None. |
|
| prize_amt | decimal number |
None. |
|
| print_pos_no | string |
None. |
|
| print_schema_no | string |
None. |
|
| print_time | string |
None. |
|
| award_modify_user_id | string |
None. |
|
| memo | string |
None. |
|
| m_orderNoList | Collection of orderNoList |
None. |
|
| rm_vip_info | rm_vip_info |
None. |
|
| reprint_times | integer |
None. |
|
| vip_multi_wallet | Collection of vip_multi_wallet |
None. |
|
| vip_reward_recheckId | string |
None. |
|
| cust_var1 | string |
None. |
|
| cust_var2 | string |
None. |
|
| cust_nvar1 | string |
None. |
|
| cust_nvar2 | string |
None. |
|
| cust_dec1 | decimal number |
None. |
|
| cust_dec2 | decimal number |
None. |
|
| cust_int1 | integer |
None. |
|
| cust_int2 | integer |
None. |
|
| cust_int3 | integer |
None. |
|
| promCode | promCode |
None. |