zqm_refund_detail
- 退款详细表
| 字段 | 类型 | 允许空 | 默认 | 注释 | ||
|---|---|---|---|---|---|---|
| refund_id | int(10) unsigned | NO | NULL | 记录ID | ||
| order_id | int(10) unsigned | NO | NULL | 订单ID | ||
| batch_no | varchar(32) | NO | NULL | 批次号 | ||
| refund_amount | decimal(10,2) | YES | 0.00 | 退款金额 | ||
| pay_amount | decimal(10,2) | YES | 0.00 | 在线退款金额 | ||
| pd_amount | decimal(10,2) | YES | 0.00 | 预存款金额 | ||
| rcb_amount | decimal(10,2) | YES | 0.00 | 充值卡金额 | ||
| refund_code | char(10) | NO | predeposit | 退款支付代码 | ||
| refund_state | tinyint(1) unsigned | YES | 1 | 退款状态:1为处理中,2为已完成,默认为1 | ||
| add_time | int(10) unsigned | NO | NULL | 添加时间 | ||
| pay_time | int(10) unsigned | YES | 0 | 在线退款完成时间,默认为0 | ||
| refund_settlement_id | varchar(64) | YES | 退款清算编号 | |||
| refund_fee | decimal(10,2) | YES | 0.00 | 退款金额 | ||
| refund_query | tinyint(1) unsigned | YES | 0 | 退款查询请求：0 | 为请求 1 | 已请求 |