Name | Description | Type | Additional information |
---|---|---|---|
sell_shopid |
分店編號 |
string |
None. |
sell_order_no |
訂單 |
string |
None. |
sell_posid |
POS編號 |
string |
None. |
sell_no |
交易序號 |
string |
None. |
sell_day |
銷售日 |
string |
None. |
tday |
發生日 |
string |
None. |
sell_time |
銷售時間 |
string |
None. |
store_id |
專櫃編號 |
string |
None. |
sell_casher |
收銀員 |
string |
None. |
sell_transtype |
交易型態 |
string |
None. |
part_refund | string |
None. |
|
sell_invoice |
發票號碼 |
string |
None. |
invoice_amt |
發票金額 |
decimal number |
None. |
free_tax_amt |
免稅金額 |
decimal number |
None. |
untax_amt |
未稅金額 |
decimal number |
None. |
total_amt |
銷售總金額 |
decimal number |
None. |
total_qty |
銷售總數量 |
integer |
None. |
rate_amt |
銷售總稅額 |
decimal number |
None. |
disc_amt |
銷售小計後折讓 |
decimal number |
None. |
total_sales_amt |
實付金額 |
decimal number |
None. |
extra_amt |
溢收金額 |
decimal number |
None. |
vip_no |
會員卡號 |
string |
None. |
comp_id |
統一編號 |
string |
None. |
nrt_cardno |
外交官證號 |
string |
None. |
parking_token |
停車 token |
string |
None. |
sell_org_no |
原始交易序號 |
string |
None. |
sell_org_day |
原始交易日期 |
string |
None. |
sell_org_posid |
原始交易機號 |
string |
None. |
sell_org_tday |
原始發票開立日 |
string |
None. |
sell_org_shopid | string |
None. |
|
sell_disc_slip |
是否列印折讓單 |
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_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. |
contract_id |
合約編號 |
string |
None. |
disc_rate |
銷售小計後折扣 |
string |
None. |
eui_vehicle_type |
電子發票載具種類(共通載具=0,悠遊卡載具=2) |
string |
None. |
eui_donate |
電子發票捐贈狀態 '0':沒有 '1':有 |
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. |
skm_info |
外接訊息 |
string |
None. |
vip_point_registered |
會員累點狀態 |
string |
None. |
vip_point_recheckId |
會員累點ID |
string |
None. |
sell_detail |
銷售明細 |
Collection of sell_detail |
None. |
tender_detail |
付款明細 |
Collection of tender_detail |
None. |
change_payment_no |
找零金額所屬支付 |
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. |
staff_sales_status |
員購狀態 |
string |
None. |
sell_job_id |
班別 |
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 |
1.儲值 2.退款 |
string |
None. |
rtn_print_yn |
折讓單列印狀態 |
string |
None. |
change_status |
是否為換貨 |
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. |
vip_limit_point_date |
會員點數到期日 |
string |
None. |
vip_limit_point |
會員到期點數 |
integer |
None. |
vip_limit_point_dec | decimal number |
None. |
|
recoupon_sale |
回補券號資訊 |
recoupon_sale |
None. |
m_pmt_discount | m_pmt_discount |
None. |
|
special_no |
特約編號 |
string |
None. |
input_type |
報帳交易 |
string |
None. |
order_no |
訂單 |
string |
None. |
m_orderno | string |
None. |
|
order_type | string |
None. |
|
tra_no |
特約商店代碼 |
string |
None. |
invitation_no |
邀請函號碼 |
string |
None. |
vip_point_amt |
可累積點數金額 |
decimal number |
None. |
vip_point_source |
會員累點來源 |
string |
None. |
bs_print_flag |
電子發票列印次數 |
integer |
None. |
change_inv |
找零支付發票狀態 |
string |
None. |
change_sell_tender |
找零支付代碼 |
string |
None. |
nd_type |
交易歸屬抽成 |
string |
None. |
staffBalance |
員購剩餘額度 |
integer |
None. |
staffUsedAmt |
員購使用額度 |
integer |
None. |
staffMealBalance |
員餐剩餘額度 |
integer |
None. |
staffMealUsedAmt |
員餐使用額度 |
integer |
None. |
tenant_serial_no | string |
None. |
|
consumer_email | string |
None. |
|
consumer_name | string |
None. |
|
consumer_zip_code | string |
None. |
|
consumer_addr | string |
None. |
|
consumer_mobile_no | string |
None. |
|
erp_vip_no | string |
None. |
|
eui_request | string |
None. |
|
bs_print_time | string |
None. |
|
sale_count | integer |
None. |
|
meal_pickup_number | string |
None. |
|
meal_pickup_type | string |
None. |
|
meal_send_server | string |
None. |
|
vip_phone | string |
None. |
|
vip_uid | string |
None. |
|
ownname | string |
None. |
|
vip_comm_status | 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. |
|
discount_name | string |
None. |
|
extra_no | string |
None. |
|
order_memo | string |
None. |
|
order_origin | string |
None. |
|
rtn_tender_type | string |
None. |
|
vip_muid | string |
None. |
|
order_trans_status | string |
None. |
|
paid_amt | decimal number |
None. |
|
other_amt | decimal number |
None. |
|
use_date | string |
None. |
|
order_status | string |
None. |
|
balance | decimal number |
None. |
|
vip_name | string |
None. |
|
vip_level | string |
None. |
|
vip_gender | string |
None. |
|
vip_birth | string |
None. |
|
order_to_tshop | string |
None. |
|
pmt_no | string |
None. |
|
prom_name | string |
None. |
|
auto_trans_key | string |
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. |
|
deposit_org_no | string |
None. |
|
deposit_org_day | string |
None. |
|
deposit_org_posid | string |
None. |
|
memo | string |
None. |
|
m_orderNoList | Collection of orderNoList |
None. |
|
rm_vip_info | rm_vip_info |
None. |
|
promCode | promCode |
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. |