4.1 获取对账单
<h2>描述</h2>
<p>商户和服务商可以通过该接口下载历史交易清单。比如掉单、系统错误等导致商户系统和PayCloud平台数据不一致，通过对账单核对后可校正支付状态。
同一个app_id同一天生成一个文件。如果您是以服务商接入，那么您的对账单中包含多个商户的交易，若以商户接入，那么对账单中只包含本商户的交易。</p>
<blockquote>
<p>注意：
1、PayCloud平台未成功完成支付的交易不会出现在对账单中。银行卡支付支付成功后撤销的交易也不会出现在对账单中；
2、每日交易的对账单在<strong>T+1日下午16点</strong>提供下载；
3、对账单接口仅提供3个月以内的账单下载，超出范围的请求将被拒绝。
4、对账单的格式未来可能增加数据列，但不会修改已有的列，你应该保证你的系统有足够的兼容性</p>
</blockquote>
<h2>请求参数</h2>
<h4>公共参数</h4>
<p>参见【<a href="https://www.showdoc.com.cn/1724151917532295/8175841214113582">请求报文 - 公共参数</a>】</p>
<h4>业务参数</h4>
<table>
<thead>
<tr>
<th><strong>参数KEY</strong></th>
<th><strong>参数名称</strong></th>
<th><strong>类型</strong></th>
<th><strong>必要性</strong></th>
<th><strong>描述</strong></th>
</tr>
</thead>
<tbody>
<tr>
<td>method</td>
<td>请求方法</td>
<td>TEXT(128)</td>
<td>M</td>
<td>接口固定值为：paycloud.accounting.bill.download</td>
</tr>
<tr>
<td>trans_date</td>
<td>交易日期</td>
<td>TEXT(10)</td>
<td>M</td>
<td>商户所在时区的日期，格式：YYYY-MM-DD</td>
</tr>
<tr>
<td>extension_parameters</td>
<td>扩展参数</td>
<td>JSONObject</td>
<td>O</td>
<td>扩展输入参数，后续定义增加的参数存储于此JSON可变结构中</td>
</tr>
</tbody>
</table>
<h2></h2>
<h2>响应参数</h2>
<h4>公共参数</h4>
<p>参见【<a href="https://www.showdoc.com.cn/1724151917532295/8175841214113582">响应报文 - 公共参数</a>】</p>
<h4>业务参数</h4>
<p>当 code=0 时，data[0] 返回如下参数：</p>
<table>
<thead>
<tr>
<th><strong>参数KEY</strong></th>
<th><strong>参数名称</strong></th>
<th><strong>类型</strong></th>
<th><strong>必要性</strong></th>
<th><strong>描述</strong></th>
</tr>
</thead>
<tbody>
<tr>
<td>bill_file_url</td>
<td>对账单文件下载地址</td>
<td>TEXT</td>
<td>M</td>
<td>对账单文件下载地址，请请求该地址下载文件，文件格式为csv文本格式</td>
</tr>
</tbody>
</table>
<h2>附：文本表格的格式</h2>
<p>第一行为表头，后面各行为对应的字段内容，字段内容跟查询订单结果一致，具体字段说明可查阅相应接口。</p>
<p>第一行为表头,表头格式如下：
trans_end_time,merchant_no,store_no,partner_no,terminal_no,trans_no,orig_trans_no,merchant_order_no,payment_method,trans_type,pay_user_account_id,pay_user_account_name,trans_currency,trans_amount,customer_paid_amount,discount_bmopc,discount_bpc,trans_fee,trans_fee_rate,receivable_amount,description,card_type,sys_no,ref_no,vouch_no,batch_no,attach,store_name,outer_store_no</p>
<p>从第二行起，为数据记录，各参数以逗号分隔，字段顺序与表头一致。</p>
<p>例如：</p>
<pre><code>trans_end_time,merchant_no,store_no,partner_no,terminal_no,trans_no,orig_trans_no,merchant_order_no,payment_method,trans_type,pay_user_account_id,pay_user_account_name,trans_currency,trans_amount,customer_paid_amount,discount_bmopc,discount_bpc,trans_fee,trans_fee_rate,receivable_amount,,description,card_type,sys_no,ref_no,vouch_no,batch_no,attach,store_name,outer_store_no
2018-12-11 22:48:30,10030461,166130,,,PW000166130201812110000010,,OPEN-API-TEST-1544539623549,WECHATPAY,1,oLEz****************Ecg6x0,oLEz****************Ecg6x0,RMB,0.0100,0.0100,0.0000,0.0000,0.0000,0,0.0100,
2018-12-11 18:27:09,10030461,166130,,,PW000166130201812110000007,,OPEN-API-TEST-1544523933098,WECHATPAY,1,oLEz****************Ecg6x0,oLEz****************Ecg6x0,RMB,0.0100,0.0100,0.0000,0.0000,0.0000,0,0.0100,
2018-12-11 16:56:16,10030461,166130,df9dcc4b,,PW000166130201812110000005,,,WECHATPAY,1,oLEz****************um82Y8,oLEz****************um82Y8,RMB,0.0200,0.0200,0.0000,0.0000,0.0000,0,0.0200,
2018-12-11 16:56:38,10030461,166130,df9dcc4b,,PW000166130201812110000006,PW000166130201812110000005,,WECHATPAY,3,oLEz****************um82Y8,oLEz****************um82Y8,RMB,0.0200,0.0200,0.0000,0.0000,0.0000,0,0.0200,
2018-12-11 16:51:43,10030461,166130,df9dcc4b,,PW000166130201812110000003,,201911201948,WECHATPAY,1,oLEz****************um82Y8,oLEz****************um82Y8,RMB,0.0100,0.0100,0.0000,0.0000,0.0000,0,0.0100,
2018-12-11 16:53:34,10030461,166130,df9dcc4b,,PW000166130201812110000004,PW000166130201812110000003,201711201748,WECHATPAY,3,oLEz****************um82Y8,oLEz****************um82Y8,RMB,0.0100,0.0100,0.0000,0.0000,0.0000,0,0.0100,
2018-12-11 16:45:55,10030461,166130,df9dcc4b,,PW000166130201812110000002,PW000166130201812110000001,,WECHATPAY,3,oLEz****************um82Y8,oLEz****************um82Y8,RMB,0.0100,0.0100,0.0000,0.0000,0.0000,0,0.0100,
2018-12-11 16:01:50,10030461,166130,df9dcc4b,,PW000166130201812110000001,,,WECHATPAY,1,oLEz****************um82Y8,oLEz****************um82Y8,RMB,0.0100,0.0100,0.0000,0.0000,0.0000,0,0.0100,
2018-12-11 18:30:03,10030461,166130,df9dcc4b,,PW000166130201812110000008,,12345612345126,WECHATPAY,1,oLEz****************n8DyOY,oLEz****************n8DyOY,RMB,0.0100,0.0100,0.0000,0.0000,0.0000,0,0.0100,
2018-12-11 18:32:33,10030461,166130,df9dcc4b,,PW000166130201812110000009,PW000166130201812110000008,,WECHATPAY,3,oLEz****************n8DyOY,oLEz****************n8DyOY,RMB,0.0100,0.0100,0.0000,0.0000,0.0000,0,0.0100,
2018-12-11 14:23:32,10030461,166131,4fd82af4,,PC000166131201812110000020,,,UNIONPAY_BANKCARD,1,6214837211888163,6214837211888163,RMB,0.0200,0.0200,0.0000,0.0000,0.0000,0.0045,0.0200,
2018-12-11 10:56:21,10030461,166131,4fd82af4,,PW000166131201812110000001,,,WECHATPAY,1,oSxB****************0trkmY,oSxB****************0trkmY,RMB,0.2900,0.2900,0.0000,0.0000,0.0000,0.0045,0.2900,
2018-12-11 11:03:07,10030461,166131,4fd82af4,,PW000166131201812110000002,PW000166131201812110000001,,WECHATPAY,3,oSxB****************0trkmY,oSxB****************0trkmY,RMB,0.2900,0.2900,0.0000,0.0000,0.0000,0.0045,0.2900,
2018-12-11 11:47:47,10030461,166131,4fd82af4,,PW000166131201812110000003,,,WECHATPAY,1,oSxB****************0trkmY,oSxB****************0trkmY,RMB,0.0200,0.0200,0.0000,0.0000,0.0000,0.0045,0.0200,
2018-12-11 11:49:49,10030461,166131,4fd82af4,,PW000166131201812110000004,PW000166131201812110000003,,WECHATPAY,3,oSxB****************0trkmY,oSxB****************0trkmY,RMB,0.0200,0.0200,0.0000,0.0000,0.0000,0.0045,0.0200,
2018-12-11 22:54:03,10030461,166130,,,PW000166130201812110000012,,OPEN-API-TEST-1544539984306,WECHATPAY,1,ooIe****************GtT0gI,ooIe****************GtT0gI,RMB,0.0100,0.0100,0.0000,0.0000,0.0000,0.0043,0.0100,
2018-12-11 23:04:47,10030461,166130,,,PW000166130201812110000013,,OPEN-API-TEST-1544540643767,WECHATPAY,1,ooIe****************GtT0gI,ooIe****************GtT0gI,RMB,0.0100,0.0100,0.0000,0.0000,0.0000,0.0043,0.0100,
2018-12-11 14:17:29,10030461,166131,4fd82af4,,PA000166131201812110000001,,,ALIPAY,1,137**7352,137**7352,RMB,0.0100,0.0100,0.0000,0.0000,0.0000,0.0045,0.0100,
2018-12-11 14:17:49,10030461,166131,4fd82af4,,PA000166131201812110000002,PA000166131201812110000001,,ALIPAY,3,137**7352,137**7352,RMB,0.0100,0.0100,0.0000,0.0000,0.0000,0.0045,0.0100,</code></pre>
<h4>字段含义：</h4>
<table>
<thead>
<tr>
<th>字段名</th>
<th>说明</th>
<th>示例</th>
</tr>
</thead>
<tbody>
<tr>
<td>trans_end_time</td>
<td>交易完成时间</td>
<td>2018-09-24 08:36:12</td>
</tr>
<tr>
<td>merchant_no</td>
<td>商户平台编号</td>
<td>12,901800000175</td>
</tr>
<tr>
<td>store_no</td>
<td>门店号，门店编号，微智体系内分配的MCODE</td>
<td>210932</td>
</tr>
<tr>
<td>partner_no</td>
<td>服务商ID</td>
<td></td>
</tr>
<tr>
<td>terminal_no</td>
<td>终端号</td>
<td></td>
</tr>
<tr>
<td>trans_no</td>
<td>PayCloud平台交易号</td>
<td>TAD80000180925000029</td>
</tr>
<tr>
<td>orig_trans_no</td>
<td>PayCloud平台原交易号，退款交易存在，退款时为原支付交易的交易号</td>
<td>TAD80000180924000020</td>
</tr>
<tr>
<td>merchant_order_no</td>
<td>商户请求流水号，支付时为商户订单号，退款时为商户退款单号</td>
<td>SQD1800000175180925000008</td>
</tr>
<tr>
<td>payment_method</td>
<td>支付方式</td>
<td>目前支持的支付方式有：ALIPAY 支付宝WECHATPAY 微信支付UNIONPAY_QRCODE 银联二维码UNIONPAY 银联卡</td>
</tr>
<tr>
</tr>
<tr>
<td>trans_type</td>
<td>交易类型,取值如下：</td>
<td>1：消费；2：消费撤销；3：退款；5：预授权；6：预授权撤销；7：预授权完成；9：预授权完成撤销；</td>
</tr>
<tr>
<td>pay_user_account_id</td>
<td>买家用户标识，如为银行卡号，部分信息会加*处理</td>
<td>2088622907524175</td>
</tr>
<tr>
<td>pay_user_account_name</td>
<td>买家账号</td>
<td>cnb<em>@alitest.</em></td>
</tr>
<tr>
<td>trans_currency</td>
<td>标价币种</td>
<td>CNY</td>
</tr>
<tr>
<td>trans_amount</td>
<td>交易总金额</td>
<td>100.00</td>
</tr>
<tr>
<td>customer_paid_amount</td>
<td>顾客实付金额</td>
<td>100.00</td>
</tr>
<tr>
<td>discount_bmopc</td>
<td>支付通道商户优惠金额</td>
<td>0</td>
</tr>
<tr>
<td>discount_bpc</td>
<td>支付通道优惠金额</td>
<td>0</td>
</tr>
<tr>
<td>trans_fee</td>
<td>商户手续费</td>
<td>0.60</td>
</tr>
<tr>
<td>trans_fee_rate</td>
<td>商户签约费率</td>
<td>0.60%</td>
</tr>
<tr>
<td>receivable_amount</td>
<td>商户应收金额</td>
<td>99.04</td>
</tr>
<tr>
<td>description</td>
<td>订单描述</td>
<td>IPHONE X 白色</td>
</tr>
<tr>
<td>card_type</td>
<td><em>银行卡借贷记类型</em></td>
<td>取值如下：<em>0：未知<strong>1：借记卡</strong>2：贷记卡</em></td>
</tr>
<tr>
<td>sys_no</td>
<td>系统跟踪号</td>
<td></td>
</tr>
<tr>
<td>ref_no</td>
<td>索引参考号</td>
<td></td>
</tr>
<tr>
<td>vouch_no</td>
<td>凭证号</td>
<td></td>
</tr>
<tr>
<td>batch_no</td>
<td>批次号</td>
<td></td>
</tr>
<tr>
<td>attach</td>
<td>商户附加数据</td>
<td>商户自定义数据，本系统透传</td>
</tr>
<tr>
<td>store_name</td>
<td>门店名称</td>
<td></td>
</tr>
<tr>
<td>outer_store_no</td>
<td>外部商户号</td>
<td>商家自定义门店编号，商户可以PayCloud商户平台添加门店绑定商家自己的门店号</td>
</tr>
</tbody>
</table>