请求报文

JSON:

  1. {
  2.     "request_type": "store_datalist_request",
  3.     "isspid": "39493002",
  4.     "store_id": "A001",
  5.     "transaction_id": "query2022083111260000001",
  6.     "system_id": "8888",
  7.     "trans_date": "20220823",
  8.     "trans_time_begin": "000000",
  9.     "trans_time_end": "235959",
  10.     "pos_seq": "2018121400000021",
  11.     "pay_type": "502",
  12.     "page": "1",
  13.     "size": "10",
  14.     "sign": "2EB4051F33C84719D59E0F5EADACF5D2"
  15. }

XML:

  1. <?xml version="1.0" encoding="GBK"?>
  2. <business_trans>
  3.     <request_type>store_datalist_request</request_type>
  4.     <isspid>39493002</isspid>
  5.     <store_id>A001</store_id>
  6.     <transaction_id>query2022083111260000001</transaction_id>
  7.     <system_id>8888</system_id>
  8.     <trans_date>20220823</trans_date>
  9.     <trans_time_begin>000000</trans_time_begin>
  10.     <trans_time_end>235959</trans_time_end>
  11.     <pos_seq>2018121400000021</pos_seq>
  12.     <pay_type>502</pay_type>
  13.     <page>1</page>
  14.     <size>10</size>
  15. </business_trans>

请求报文说明

节点名称中文名称类型说明是否必填
sign报文签名String(32)请求报文格式为JSON时必填
计算签名方式请看2.1章节		可空
request_type请求类型String(32)固定值：store_datalist_request必填
isspid商户号String(8)翼码商户号，由翼码提供必填
store_id门店号String(20)商户自定义门店号必填
transaction_id请求流水号String(32)可空，用于日志跟踪可空
system_id系统平台号String(4)由翼码提供必填
trans_date交易日期String(8)交易日期，格式：yyyyMMdd，例如：20220809必填
trans_time_begin交易开始时间String(6)交易日期，格式：HHmmss，例如：000000可空，默认为000000
trans_time_end交易结束时间String(6)交易日期，格式：HHmmss，例如：235959可空，默认为235959
pos_seq交易流水号String(32)可作为数据结果中pos_seq字段的筛选条件可空
pay_type支付方式String(3)可作为数据结果中pay_type字段的筛选条件
502：支付宝
503：微信支付
512：银联二维码
515：微信小程序
516：数字人民币
521：聚分期
620：银行卡刷卡		可空
page当前页码String传空默认为1可空
size分页大小String分页最大条数，传空默认为10可空

返回报文

JSON:

  1. {
  2.     "response_type": "store_datalist_response",
  3.     "isspid": "39493002",
  4.     "store_id": "A001",
  5.     "transaction_id": "query2022083111260000001",
  6.     "page": "1",
  7.     "size": "10",
  8.     "total_page": 1,
  9.     "data_list": [
  10.         {
  11.             "trans_type": "1",
  12.             "trans_time": "20220823151010",
  13.             "source": "1",
  14.             "pos_id": "A001",
  15.             "pos_seq": "1511300000003",
  16.             "pay_type": "502",
  17.             "status": "a",
  18.             "tx_amt": "10000",
  19.             "trade_no": "1000000000000000001",
  20.             "org_pos_seq": "",
  21.             "memo": "收款备注",
  22.             "buyer_id": "502***@qq.com",
  23.             "charge_amount": "0",
  24.             "buss_discount_amt": "0",
  25.             "platform_discount_amt": "0",
  26.             "is_foreign_card": "",
  27.             "fund_freeze_stat": ""
  28.         },
  29.         {
  30.             "trans_type": "2",
  31.             "trans_time": "20220823161010",
  32.             "source": "1",
  33.             "pos_id": "A001",
  34.             "pos_seq": "1511300000003r",
  35.             "pay_type": "502",
  36.             "status": "0",
  37.             "tx_amt": "5000",
  38.             "trade_no": "1000000000000000001",
  39.             "org_pos_seq": "1511300000003",
  40.             "memo": "",
  41.             "buyer_id": "",
  42.             "charge_amount": "0",
  43.             "buss_discount_amt": "0",
  44.             "platform_discount_amt": "0",
  45.             "is_foreign_card": "",
  46.             "fund_freeze_stat": ""
  47.         }
  48.     ],
  49.     "result": {
  50.         "id": "0000",
  51.         "comment": "查询成功"
  52.     },
  53.     "sign": "824FE953936278AEE61CA8CEE8A08C86"
  54. }

XML:

  1. <?xml version="1.0" encoding="GBK"?>
  2. <business_trans>
  3.     <response_type>store_datalist_response</response_type>
  4.     <isspid>39493002</isspid>
  5.     <store_id>A001</store_id>
  6.     <transaction_id>query2022083111260000001</transaction_id>
  7.     <page>1</page>
  8.     <size>10</size>
  9.     <total_page>1</total_page>
  10.     <data_list><![CDATA[
  11.     [
  12.         {
  13.             "trans_type": "1",
  14.             "trans_time": "20220823151010",
  15.             "source": "1",
  16.             "pos_id": "A001",
  17.             "pos_seq": "1511300000003",
  18.             "pay_type": "502",
  19.             "status": "a",
  20.             "tx_amt": "10000",
  21.             "trade_no": "1000000000000000001",
  22.             "org_pos_seq": "",
  23.             "memo": "收款备注",
  24.             "buyer_id": "502***@qq.com",
  25.             "charge_amount": "0",
  26.             "buss_discount_amt": "0",
  27.             "platform_discount_amt": "0",
  28.             "is_foreign_card": "",
  29.             "fund_freeze_stat": ""
  30.         },
  31.         {
  32.             "trans_type": "2",
  33.             "trans_time": "20220823161010",
  34.             "source": "1",
  35.             "pos_id": "A001",
  36.             "pos_seq": "1511300000003r",
  37.             "pay_type": "502",
  38.             "status": "0",
  39.             "tx_amt": "5000",
  40.             "trade_no": "1000000000000000001",
  41.             "org_pos_seq": "1511300000003",
  42.             "memo": "",
  43.             "buyer_id": "",
  44.             "charge_amount": "0",
  45.             "buss_discount_amt": "0",
  46.             "platform_discount_amt": "0",
  47.             "is_foreign_card": "",
  48.             "fund_freeze_stat": ""
  49.         }
  50.     ]
  51.     ]]></data_list>
  52.     <result>
  53.         <id>0000</id>
  54.         <comment>查询成功</comment>
  55.     </result>
  56. </business_trans>

返回报文说明

标准接口会因业务升级需要而新增节点，请在解析返回报文时避免新增未知节点产生的程序出错！

节点名称中文名称类型说明是否必填
sign报文签名String(32)返回报文格式为JSON时必填
计算签名方式请看2.1章节		可选
response_type返回类型String(32)固定值：store_datalist_response必填
isspid商户号String(8)翼码商户号，由翼码提供必填
store_id门店号String(20)商户自定义门店号必填
transaction_id请求流水号String(32)与请求报文相同可空
page当前页码String必填
size分页大小String分页最大条数必填
total_page总页数Integer数据总页数必填
data_list数据列表JSONArray数据列表采用JSON格式
XML报文时使用CDATA标签包裹		可空
result
->id		响应码String(4)0000：查询成功
其它失败，错误信息说明见“响应码解释”字段		必填
result
->comment		响应码解释String(64)响应码对应中文注解，用于显示提示必填

标准接口会因业务升级需要而新增节点，请在解析返回报文时避免新增未知节点产生的程序出错！

data_list 数据列表 (JSONArray)

JSON节点参数名称类型说明是否必填
trans_type交易类型String(1)1：支付
2：退款		必填
trans_time交易时间String(14)交易时间，格式：yyyyMMddHHmmss必填
source订单来源String(1)1：接口接入
2：收款码牌
3：POS终端发起		必填
pos_id终端号String(20)source=1时，商户自定义终端号
source=2时，收款码编号
source=3时，刷卡POS设备的终端号		必填
pos_seq交易流水号String(32)支付/退款请求流水号，且大于12位必填
pay_type支付类型String(3)502：支付宝
503：微信支付
512：银联二维码
515：微信小程序
516：数字人民币
521：聚分期
620：银行卡刷卡		必填
status交易状态String(1)0：成功
3：失败
6：等待付款/退款处理中
1：已退款 (仅支付数据)
a：部分退款 (仅支付数据)
8：未付款已撤销 (仅支付数据)		必填
tx_amt交易金额String(9)单位为分必填
trade_no支付平台订单号String(64)支付平台的订单号，仅成功时有值可空
org_pos_seq支付请求流水号String(32)被退款的支付请求流水号可空
memo备注String(128)可空
buyer_id付款人标识String(128)支付宝：用户登录帐号(带星号脱敏)
微信/微信小程序：用户open_id
银联二维码：银行卡号(带星号脱敏)
银行卡刷卡：银行卡号(带星号脱敏)

该字段是否有值取决于支付通道是否返回		可空
charge_amount手续费String(9)单位为分可空
buss_discount_amt商家优惠金额String(9)单位为分可空
platform_discount_amt平台优惠金额String(9)单位为分可空
is_foreign_card外卡标识String(1)0：不是外卡
1：是外卡
仅pay_type=620时有值，其余为空		可空
fund_freeze_stat资金冻结状态String(2)01：冻结
02：解冻
空表示无此类业务
支付交易表示当前的资金冻结状态
退款交易表示退款发生时的原支付交易资金冻结状态		可空

data_list 样例：

  1. [
  2.     {
  3.         "trans_type": "1",
  4.         "trans_time": "20220823151010",
  5.         "source": "1",
  6.         "pos_id": "A001",
  7.         "pos_seq": "1511300000003",
  8.         "pay_type": "502",
  9.         "status": "a",
  10.         "tx_amt": "10000",
  11.         "trade_no": "1000000000000000001",
  12.         "org_pos_seq": "",
  13.         "memo": "收款备注",
  14.         "buyer_id": "502***@qq.com",
  15.         "charge_amount": "0",
  16.         "buss_discount_amt": "0",
  17.         "platform_discount_amt": "0",
  18.         "is_foreign_card": "",
  19.         "fund_freeze_stat": ""
  20.     },
  21.     {
  22.         "trans_type": "2",
  23.         "trans_time": "20220823161010",
  24.         "source": "1",
  25.         "pos_id": "A001",
  26.         "pos_seq": "1511300000003r",
  27.         "pay_type": "502",
  28.         "status": "0",
  29.         "tx_amt": "5000",
  30.         "trade_no": "1000000000000000001",
  31.         "org_pos_seq": "1511300000003",
  32.         "memo": "",
  33.         "buyer_id": "",
  34.         "charge_amount": "0",
  35.         "buss_discount_amt": "0",
  36.         "platform_discount_amt": "0",
  37.         "is_foreign_card": "",
  38.         "fund_freeze_stat": ""
  39.     }
  40. ]