通联对账

CREATE TABLE `unionpay_quickpass_to_tl` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_no` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `natural_date` date DEFAULT NULL COMMENT '自然日期', `business_date` date DEFAULT NULL COMMENT '运营日期', `user_id` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户标识', `in_station_no` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '进站站点号', `in_station` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '进站站点名称', `in_time` datetime DEFAULT NULL COMMENT '进站时间', `out_station_no` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '出站站点号', `out_station` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '出站站点名称', `out_time` datetime DEFAULT NULL COMMENT '出站时间', `base_price` int(11) DEFAULT NULL COMMENT '基础金额', `fine_price` int(11) DEFAULT NULL COMMENT '扣罚金额', `discount_price` int(11) DEFAULT NULL COMMENT '优惠金额', `real_price` int(11) DEFAULT NULL COMMENT '消费金额', `settle_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '结算方式', `pay_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '支付方式', `settle_price` int(11) DEFAULT NULL COMMENT '结算票价', `settle_state` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '结算类型', `settle_time` datetime DEFAULT NULL COMMENT '结算时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

通联对账

请求参数

参数名

类型

描述

必填

说明 / 示例