文档
测试

我的闪付卡退款申请列表

websocket测试
POST
http://192.168.0.91:8070/quickpassRefund/myApprove

请求参数

参数名
类型
描述
必填
userId
用户id
必填
pageSize
页大小
必填
pageNum
页数
必填
approveStatus
审批状态0未审批 1审批通过 2审批拒绝
必填
startTime
开始时间
必填
endTime
结束时间
必填

返回字段

CREATE TABLE `unionpay_quickpass_order_refund_approve` ( `track2data` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '二磁道数据', `order_no` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单号', `batch_no` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '批次号', `flow_no` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '流水号', `order_type` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '交易类型：0 扣费 1 退款 2 预授权撤销', `card_no` varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '卡号', `card_seq` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '序列号', `card_exp_date` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '卡有效期', `card_data` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '卡数据', `in_route_terminal_type` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '设备类型：0 闸机 1 BOM', `in_route_terminal_no` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '进站设备流水号', `in_route_batch_no` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '进站批次号', `in_route_flow_no` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '进站流水号', `in_route_station_code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '进站站点编码', `in_route_station` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '进站站点名称', `in_route_date` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '进站时间', `union_in_route_time` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '受卡方所在地时间', `union_in_route_date` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '受卡方所在地日期', `union_in_bill_date` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '清算日期', `union_in_refer_code` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '检索参考号', `union_in_auth_code` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '授权码', `union_in_resp_code` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '应答码', `union_in_mcc_code` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '国际信用卡公司代码', `union_in_recv_code` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '附加响应信息、收单机构', `out_route_terminal_type` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '设备类型：0 闸机 1 BOM', `out_route_terminal_no` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '出站设备流水号', `out_route_batch_no` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '出站批次号', `out_route_flow_no` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '出站流水号', `out_route_station_code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '出站站点编码', `out_route_station` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '出站站点名称', `out_route_date` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '出站时间', `union_out_route_time` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `union_out_route_date` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `union_out_bill_date` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `union_out_refer_code` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '检索参考号', `union_out_auth_code` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '授权码', `union_out_resp_code` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '应答码', `union_out_recv_code` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '附加响应信息、收单机构', `ticket_price` decimal(7,3) unsigned zerofill DEFAULT NULL COMMENT '票价', `forfeit` decimal(7,3) unsigned zerofill DEFAULT NULL COMMENT '扣罚金额', `favourable` decimal(7,3) DEFAULT NULL COMMENT '优惠金额', `amount` decimal(7,3) DEFAULT NULL COMMENT '支付金额', `order_date` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '交易时间', `actual_amount` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '实扣金额', `authorize_amount` decimal(7,0) DEFAULT NULL COMMENT '预授权金额', `favor_code` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '银联营销活动代码', `create_date` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建时间', `update_date` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '更新时间', `order_status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订单状态:0 未支付 1 已支付 2 退款中 3 已退款', `unionpay_status` tinyint(1) DEFAULT NULL COMMENT '银联状态', `id` int(10) NOT NULL AUTO_INCREMENT, `approve_user_id` int(11) DEFAULT NULL COMMENT '申请人id', `approve_complete_user_id` int(11) DEFAULT NULL COMMENT '审批人id', `approve_comment` varchar(255) DEFAULT NULL COMMENT '提交审批备注', `approve_complete_comment` varchar(255) DEFAULT NULL COMMENT '审批完成意见', `approve_status` tinyint(1) DEFAULT NULL COMMENT '审批状态0未审批 1审批通过 2审批拒绝', `approve_amount` int(4) DEFAULT NULL COMMENT '退款金额', `send_str` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发送数据', `rev_str` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '返回数据', PRIMARY KEY (`id`) USING BTREE, KEY `UNIONPAY_QUICKPASS_ORDER_CARD_NO_CARD_SEQ` (`card_no`,`card_seq`) USING BTREE, KEY `idx_card_no_in_route_date_out_route_date` (`card_no`,`in_route_date`,`out_route_date`) USING BTREE, KEY `uk_order_date` (`order_date`) USING BTREE, KEY `uk_create_date` (`create_date`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=876 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='当处于预授权撤销时，出站信息为预授权撤销响应信息';

响应参数

参数名
类型
描述
必填
status
int
示例：6
必填
message
object
示例：null
必填
data
object
数据字典
必填
pageContent
object
数据字典
必填
list
array
数据列表
必填
routeNo
string
示例：bom2021010109155960506749255525743351
必填
accRouteNo
string
示例：bom2021010109155960506749255525743351
必填
mode
int
示例：0
必填
appUserId
string
示例：A31012019000006029b1209183231241
必填
accUserId
string
示例：60506749255525743351
必填
phone
string
示例：15326039983
必填
routeStation
string
示例：伊利健康谷
必填
routeStationCode
string
示例：0119
必填
routeType
int
示例：0
必填
codeType
int
示例：0
必填
isException
int
示例：0
必填
exceptionReason
string
示例：
必填
routeDate
string
示例：20210101091559
必填
createDate
int
示例：1609463766442
必填
unionReturnCode
string
示例：1000
必填
unionReturnMsg
string
示例：成功
必填
totalNum
int
示例：39881
必填
totalPages
int
示例：3989
必填
上一篇 闪付卡退款申请接口
nextDoc 全部闪付卡退款申请列表
本文档使用易文档编写, 更新时间: 2021-04-02 14:58