wdt.sales.rawtrade.search{
"operation": {
"method": "none"
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | params | params | object | 1 | Required | 查询参数 |
| 2 | pager | pager | object | 1 | Required | 分页 |
| 3 | tid | tid | string | 1 | Optional | 原始单号 |
| 4 | start_time | start_time | string | 1 | Optional | 修改起始时间 |
| 5 | end_time | end_time | string | 1 | Optional | 修改结束时间 |
| 6 | shop_no | shop_no | string | 1 | Optional | 店铺编号 |
| 7 | page_size | page_size | string | 1 | Optional | 分页大小 |
| 8 | page_no | page_no | string | 1 | Optional | 从0开始 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | rec_id | rec_id | string | 1 | Required | 唯一键 |
| 2 | platform_id | platform_id | string | 1 | Required | 平台ID |
| 3 | tid | tid | string | 1 | Required | 原始单号 |
| 4 | shop_id | shop_id | string | 1 | Required | 店铺id |
| 5 | shop_no | shop_no | string | 1 | Required | 店铺编号 |
| 6 | process_status | process_status | string | 1 | Required | 10:待递交 15:部分发货待递交 20:已递交 30:部分发货 40:已发货 60:已完成 70:已取消 |
| 7 | trade_status | trade_status | string | 1 | Required | 10:未确认 20:待尾款 30:待发货 40:部分发货 50:已发货 60:已签收 70:已完成 80:已退款 90:已关闭 |
| 8 | pay_status | pay_status | string | 1 | Required | 0:未付款 1:部分付款 2:已付款 |
| 9 | pay_method | pay_method | string | 1 | Required | 1:在线转账 2:现金 3:银行转账 4:邮局汇款 5:预付款 6:刷卡 |
| 10 | refund_status | refund_status | string | 1 | Required | 0:无退款 1:取消退款 2:已申请退款 3:等待退货 4:等待收货 5:退款成功 6:未付款关闭 |
| 11 | bad_reason | bad_reason | string | 1 | Required | 递交失败原因 |
| 12 | order_count | order_count | string | 1 | Required | 子单数量 |
| 13 | goods_count | goods_count | string | 1 | Required | 货品数量 |
| 14 | trade_time | trade_time | string | 1 | Required | 下单时间 |
| 15 | pay_time | pay_time | string | 1 | Required | 支付时间 |
| 16 | end_time | end_time | string | 1 | Required | 结束时间 |
| 17 | buyer_message | buyer_message | string | 1 | Required | 买家留言 |
| 18 | remark | remark | string | 1 | Required | 客服备注 |
| 19 | buyer_nick | buyer_nick | string | 1 | Required | 买家昵称 |
| 20 | buyer_email | buyer_email | string | 1 | Required | 邮箱 |
| 21 | buyer_name | buyer_name | string | 1 | Required | 买家姓名 |
| 22 | buyer_area | buyer_area | string | 1 | Required | 买家区域 |
| 23 | pay_id | pay_id | string | 1 | Required | 平台支付单号 |
| 24 | pay_account | pay_account | string | 1 | Required | 买家支付账号 |
| 25 | receiver_name | receiver_name | string | 1 | Required | 收件人姓名 |
| 26 | receiver_country | receiver_country | string | 1 | Required | 见城市代码表 |
| 27 | receiver_province | receiver_province | string | 1 | Required | 见城市代码表 |
| 28 | receiver_city | receiver_city | string | 1 | Required | 见城市代码表 |
| 29 | receiver_district | receiver_district | string | 1 | Required | 见城市代码表 |
| 30 | receiver_address | receiver_address | string | 1 | Required | 收件地址 |
| 31 | receiver_mobile | receiver_mobile | string | 1 | Required | 收件人手机 |
| 32 | receiver_telno | receiver_telno | string | 1 | Required | 收件人电话 |
| 33 | receiver_area | receiver_area | string | 1 | Required | 收件人省市区 |
| 34 | receiver_ring | receiver_ring | string | 1 | Required | 区域(京东几环) |
| 35 | to_deliver_time | to_deliver_time | string | 1 | Required | 送货时间 |
| 36 | goods_amount | goods_amount | string | 1 | Required | 货款 |
| 37 | post_amount | post_amount | string | 1 | Required | 邮费 |
| 38 | other_amount | other_amount | string | 1 | Required | 其他收费 |
| 39 | discount | discount | string | 1 | Required | 优惠 |
| 40 | receivable | receivable | string | 1 | Required | 应收 |
| 41 | received | received | string | 1 | Required | 已从平台收款金额 |
| 42 | paid | paid | string | 1 | Required | 买家已付金额 |
| 43 | platform_cost | platform_cost | string | 1 | Required | 平台费用 |
| 44 | warehouse_no | warehouse_no | string | 1 | Required | 自流转仓库编号 |
| 45 | is_auto_wms | is_auto_wms | string | 1 | Required | 是否自流转 |
| 46 | modified | modified | string | 1 | Required | 最后修改时间 |
| 47 | consumer_amount | consumer_amount | string | 1 | Required | 给消费者开票金额,数值来源于订单平台,若平台未传递给旺店通对应的值,该字段不返回 |
| 48 | platform_amount | platform_amount | string | 1 | Required | 给平台开票金额,数值来源于订单平台,若平台未传递给旺店通对应的值,该字段不返回 |
| 49 | created | created | string | 1 | Required | 创建时间 |
| 50 | trade_orders | trade_orders | array | 1 | Required | 原始单明细 |
| 51 | rec_id | rec_id | string | 1 | Required | 系统原始单明细id |
| 52 | tid | tid | string | 1 | Required | 原始单号 |
| 53 | oid | oid | string | 1 | Required | 原始子单号 |
| 54 | platform_id | platform_id | string | 1 | Required | 平台id |
| 55 | status | status | string | 1 | Required | 10:未确认 20:待尾款 30:待发货 40:部分发货 50:已发货 60:已签收 70:已完成 80:已退款 90:已关闭 |
| 56 | process_status | process_status | string | 1 | Required | 10:待递交 15:部分发货待递交 20:已递交 30:部分发货 40:已发货 60:已完成 70:已取消 |
| 57 | refund_status | refund_status | string | 1 | Required | 0:无退款 1:取消退款 2:已申请退款 3:等待退货 4:等待收货 5:退款成功 6:未付款关闭 |
| 58 | goods_name | goods_name | string | 1 | Required | 平台货品名称 |
| 59 | goods_no | goods_no | string | 1 | Required | 平台货品编号 |
| 60 | goods_id | goods_id | string | 1 | Required | 平台货品id |
| 61 | spec_no | spec_no | string | 1 | Required | 平台规格编码 |
| 62 | spec_name | spec_name | string | 1 | Required | 平台规格名称 |
| 63 | spec_id | spec_id | string | 1 | Required | 平台规格id |
| 64 | num | num | string | 1 | Required | 数量 |
| 65 | price | price | string | 1 | Required | 单价 |
| 66 | discount | discount | string | 1 | Required | 优惠 |
| 67 | adjust_amount | adjust_amount | string | 1 | Required | 调整 |
| 68 | share_discount | share_discount | string | 1 | Required | 分摊优惠 |
| 69 | total_amount | total_amount | string | 1 | Required | 总价 |
| 70 | share_amount | share_amount | string | 1 | Required | 分摊后金额 |
| 71 | refund_amount | refund_amount | string | 1 | Required | 退款金额 |
| 72 | remark | remark | string | 1 | Required | 备注 |
| 73 | modified | modified | string | 1 | Required | 最后变更时间 |
| 74 | created | created | string | 1 | Required | 创建时间 |
| 75 | end_time | end_time | string | 1 | Required | 子单完成时间 |
The 原始单查询_v1 API (wdt.sales.rawtrade.search) of 旺店通·旗舰奇门 is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with 旺店通·旗舰奇门 version updates.
Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.