收款明细汇总V2
按支付方式汇总, 收款统计, 退款统计等
请求地址
/api/v2/cashier/pay_stats_v2
公共请求参数
请求参数
| 参数 | 必填 | 类型 | 说明 |
|---|---|---|---|
| begin_time | 是 | String | 开始时间, 格式"yyyy-MM-dd HH:mm:ss" |
| end_time | 是 | String | 结束时间, 格式"yyyy-MM-dd HH:mm:ss" |
响应参数
返回list, 详情见示例
list 数据结构
| 名称 | 类型 | 说明 |
|---|---|---|
| key | string | 汇总key |
| origin_fee | int | 订单原价 |
| pay_fee | int | 收款金额（订单金额） |
| pay_count | int | 收款笔数（订单笔数） |
| k_discount_fee | int | 业务优惠金额 |
| k_discount_count | int | 业务优惠笔数 |
| m_discount_fee | int | 免充值券优惠金额 |
| m_discount_count | int | 免充值券优惠笔数 |
| m_discount_fee | int | 免充值券优惠金额 |
| y_discount_count | int | 预充值券优惠笔数 |
| y_discount_fee | int | 预充值券优惠金额 |
| p_discount_fee | int | 平台补贴金额 |
| p_discount_count | int | 平台补贴笔数 |
| mch_discount_fee | int | 商家出资优惠金额=业务优惠金额+免充值券优惠金额 |
| mch_discount_count | int | 商家出资优惠金额笔数 |
| received_fee | int | 实收金额 |
| received_count | int | 实收笔数 |
| settlement_fee | int | 结算金额 |
| service_fee | int | 手续费 |
| refund_fee | int | 退款订单金额 |
| refund_service_fee | int | 退回手续费 |
| refund_discount_fee | int | 退回优惠金额（免充） |
| refund_actual_fee | int | 实退金额（不含手续费） |
| refund_settle_fee | int | 退款结算金额 |
| refund_count | int | 退款订单笔数 |
| delta_actual_fee | int | 汇总实收金额=支付实收-退款实退，不含手续费 |
| delta_settle_fee | int | 汇总结算金额=支付结算金额-退款结算金额 |
| delta_service_fee | int | 汇总手续费，=支出手续费-退回手续费 |
| statements_fee | int | 银行入账金额 |
请求示例
:::: tabs
::: tab biz_content
{
"begin_time": "2020-10-14 00:00:00",
"end_time": "2020-10-15 00:00:00"
}
:::
::::
响应示例
:::: tabs
::: tab result
{
"code": 0,
"data": [
{
"delta_actual_fee": 963,
"delta_service_fee": 1,
"delta_settle_fee": 962,
"k_discount_count": 7,
"k_discount_fee": 402,
"key": "微信支付",
"m_discount_count": 1,
"m_discount_fee": 100,
"mch_discount_count": 0,
"mch_discount_fee": 502,
"origin_fee": 2999,
"p_discount_count": 0,
"p_discount_fee": 0,
"pay_count": 15,
"pay_fee": 2598,
"received_count": 15,
"received_fee": 2498,
"refund_actual_fee": 1535,
"refund_count": 7,
"refund_discount_fee": 0,
"refund_fee": 1535,
"refund_service_fee": 16,
"refund_settle_fee": 1519,
"service_fee": 17,
"settlement_fee": 2481,
"statements_fee": 962,
"y_discount_count": 1,
"y_discount_fee": 90
},
{
"delta_actual_fee": 53366,
"delta_service_fee": 0,
"delta_settle_fee": 53366,
"k_discount_count": 10,
"k_discount_fee": 953835,
"key": "余额支付",
"m_discount_count": 0,
"m_discount_fee": 0,
"mch_discount_count": 0,
"mch_discount_fee": 953835,
"origin_fee": 1008201,
"p_discount_count": 0,
"p_discount_fee": 0,
"pay_count": 13,
"pay_fee": 54366,
"received_count": 10,
"received_fee": 54366,
"refund_actual_fee": 1000,
"refund_count": 1,
"refund_discount_fee": 0,
"refund_fee": 1000,
"refund_service_fee": 0,
"refund_settle_fee": 1000,
"service_fee": 0,
"settlement_fee": 54366,
"statements_fee": 0,
"y_discount_count": 0,
"y_discount_fee": 0
},
{
"delta_actual_fee": 2,
"delta_service_fee": 0,
"delta_settle_fee": 2,
"k_discount_count": 0,
"k_discount_fee": 0,
"key": "支付宝支付",
"m_discount_count": 0,
"m_discount_fee": 0,
"mch_discount_count": 0,
"mch_discount_fee": 0,
"origin_fee": 306,
"p_discount_count": 0,
"p_discount_fee": 0,
"pay_count": 6,
"pay_fee": 306,
"received_count": 6,
"received_fee": 206,
"refund_actual_fee": 204,
"refund_count": 4,
"refund_discount_fee": 0,
"refund_fee": 204,
"refund_service_fee": 0,
"refund_settle_fee": 204,
"service_fee": 0,
"settlement_fee": 206,
"statements_fee": 2,
"y_discount_count": 0,
"y_discount_fee": 0
},
{
"delta_actual_fee": 54331,
"delta_service_fee": 1,
"delta_settle_fee": 54330,
"k_discount_count": 17,
"k_discount_fee": 954237,
"key": "合计",
"m_discount_count": 1,
"m_discount_fee": 100,
"mch_discount_count": 0,
"mch_discount_fee": 954337,
"origin_fee": 1011506,
"p_discount_count": 0,
"p_discount_fee": 0,
"pay_count": 34,
"pay_fee": 57270,
"received_count": 31,
"received_fee": 57070,
"refund_actual_fee": 2739,
"refund_count": 12,
"refund_discount_fee": 0,
"refund_fee": 2739,
"refund_service_fee": 16,
"refund_settle_fee": 2723,
"service_fee": 17,
"settlement_fee": 57053,
"statements_fee": 964,
"y_discount_count": 1,
"y_discount_fee": 90
}
],
"msg": "success",
"succeed": true
}
::::