ome_refund_apply

退款单申请

所属应用: ome

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
apply_id	apply_id	int(10) unsigned	Y		Y
refund_apply_bn	退款申请单号	varchar(32)	Y		N
order_id	订单号	int(10) unsigned	Y		N
pay_type	支付类型 online:在线支付;offline:线下支付;deposit:预存款支付;	enum('online','offline','deposit')	Y	online	N
account	退款帐号	varchar(50)	N		N
bank	退款银行	varchar(50)	N		N
pay_account	收款帐号	varchar(50)	N		N
money	申请退款金额	decimal(20,3)	N		N
refunded	已退款金额	decimal(20,3)	N		N
payment	付款方式	mediumint(8) unsigned	N		N
memo	退款原因	text	N		N
create_time	申请时间	int(10) unsigned	N		N
last_modified	最后更新时间	int(10) unsigned	N		N
apply_op_id	申请操作员	mediumint(8) unsigned	N		N
verify_op_id	verify_op_id	mediumint(8) unsigned	N		N
status	退款状态 0:未审核;1:审核中;2:已接受申请;3:已拒绝;4:已退款;5:退款中;6:退款失败;10:卖家拒绝退款;	enum('0','1','2','3','4','5','6','10')	N	0	N
disabled	是否失效	enum('true','false')	Y	false	N
shop_id	来源店铺	varchar(32)	N		N
delivery_mode	可选值请参考ome_shop表的delivery_mode (self=>自发,jingxiao=>经销)	varchar(32)	N		N
return_id	售后ID	int(10)	N		N
reship_id	退换货ID	int(10)	N		N
addon	addon	longtext	N		N
refund_refer	退款来源 0:售前;1:售后;	enum('0','1')	N	0	N
bcmoney	补偿费用	decimal(20,3)	N	0	N
real_refund_amount	买家实退	decimal(20,3)	N		N
product_data	售后申请商品	longtext	N		N
source	来源	varchar(50)	N	local	N
source_status	平台状态	varchar(255)	N		N
shop_type	店铺类型	varchar(50)	N		N
mark_text	商家备注	longtext	N		N
problem_id	问题类型ID	mediumint(8) unsigned	N		N
outer_lastmodify	前端店铺最后更新时间	int(10) unsigned	N		N
archive	archive	tinyint(3) unsigned	Y	0	N
org_id	运营组织	mediumint(8) unsigned	N		N
oid	子订单号	varchar(255)	N	0	N
bn	货号	varchar(255)	N		N
abnormal_status	异常状态标识位	bigint(20)	N	0	N
bool_type	单据种类	bigint(20)	N	0	N
flag	标识	varchar(255)	N		N
tag_type	退款类型 0:常规退款;1:价保退款;2:返现退款;3:赔付退款;5:极速退款;6:售后仅退款;7:发货前退款;	enum('0','1','2','3','5','6','7')	N	0	N
cost_freight	运费	decimal(20,3)	N	0	N
order_source	来源渠道	varchar(50)	N	direct	N
negotiate_sync_status	协商状态 none:不可协商;pending:可协商;succ:协商发起成功;fail:协商发起失败;running:协商发起中;	enum('none','pending','succ','fail','running')	N	pending	N
negotiate_sync_msg	协商同步消息	varchar(500)	N		N

索引

Key name	Column names	Unique	Comment
primary	apply_id	Y
ind_refund_apply_bn_shop	refund_apply_bn, shop_id	Y
ind_reship_id	reship_id	N
ind_status_disabled	status, disabled, delivery_mode	N
idx_return_id	return_id	N
idx_abnormal_status	abnormal_status	N
idx_oid	oid	N
idx_bn	bn	N
idx_bool_type	bool_type	N
idx_tag_type	tag_type	N
ind_source_status	source_status	N
idx_delivery_mode	delivery_mode	N
ind_refund_refer	refund_refer	N
idx_order_source	order_source	N
idx_create_time	create_time	N
idx_disabled_org_deliverymode	disabled, org_id, delivery_mode	N
idx_refundrefer_orderid	refund_refer, order_id	N
idx_c_order_id	order_id	N
idx_c_payment	payment	N
idx_c_apply_op_id	apply_op_id	N
idx_c_verify_op_id	verify_op_id	N
idx_c_shop_id	shop_id	N
idx_c_problem_id	problem_id	N
idx_c_org_id	org_id	N