acc对账导出

CREATE TABLE `unionpay_quickpass_to_acc_20200824` ( `id` int(11) NOT NULL, `business_date` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '运营日期', `bank_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '银行卡号', `ticket_type` varchar(4) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '票卡类型', `in_operator` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '进站操作员', `in_station` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '进站车站', `in_station_no` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '进站设备', `in_time` datetime DEFAULT NULL COMMENT '进站时间', `in_tranflow_no` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '进站流水号', `out_operator` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '出站操作员', `out_station` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '出站车站', `out_station_no` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '出站设备', `out_time` datetime DEFAULT NULL COMMENT '出站时间', `out_tranflow_no` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '出站流水号', `order_no` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '行程交易订单号', `tran_time` datetime DEFAULT NULL COMMENT '交易扣费时间', `tran_date` date DEFAULT NULL COMMENT '交易扣费运营日', `tick_price` int(11) DEFAULT NULL COMMENT '票价', `tran_price` int(11) DEFAULT NULL COMMENT '支付金额', `order_status` tinyint(1) DEFAULT NULL COMMENT '订单状态0 进出订单 1 日终单边订单', `tran_status` tinyint(1) DEFAULT NULL COMMENT '1已支付', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

acc对账导出

请求参数

参数名

类型

描述

必填

说明 / 示例