/erp/sc/routing/purchase/purchase_return_order/getPurchaseReturnOrderList{
"operation": {
"method": "POST",
"path": "/erp/sc/routing/purchase/purchase_return_order/getPurchaseReturnOrderList"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": {
"offset": 0,
"length": 20,
"start_date": "2024-08-02",
"end_date": "2024-08-02",
"status": [
10,
20
]
},
"responseExample": {
"code": 0,
"message": "success",
"error_details": [],
"request_id": "0CDB0A84-AE71-A25C-7432-041C78192C34",
"response_time": "2024-08-02 17:46:27",
"data": {
"total": 2,
"list": [
{
"order_sn": "PR240802002",
"create_realname": "何承伟",
"create_uid": 10548111,
"buyer_realname": "甄新晴",
"buyer_uid": 10401445,
"create_time": "2024-08-02 10:56:57",
"last_time": "2024-08-02 10:56:57",
"purchase_order_sn": "PO240104006",
"wid": 44,
"supplier_name": "深圳市健爱户外运动用品有限公司(已删除)",
"supplier_id": 1583,
"return_method": 2,
"replenish_method": 1,
"receipt_funds_order_sn": "",
"status": 10,
"purchase_currency": "CNY",
"purchase_currency_icon": "¥",
"fee_part_type": null,
"shipping_currency": "CNY",
"shipping_price": "0.00",
"other_currency": "CNY",
"other_fee": "0.00",
"return_amount_total": "0.00",
"return_reason": "",
"remark": "",
"item_list": [
{
"item_id": 2414,
"spu_name": "",
"spu": "",
"product_name": "服装1111",
"sku": "fuzhuang1111",
"fnsku": "B0BBB14W7B",
"msku": [],
"attribute": [],
"seller_id": "109",
"price": "100.0000",
"quantity_real": 80,
"return_good_num": 0,
"return_bad_num": 5,
"replenish_num": 5,
"deduction_amount": "0.00",
"expect_arrive_time": "",
"remark": ""
}
]
}
]
},
"total": 0
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | search_field_time | 时间搜索维度 | string | — | Optional | 时间搜索维度: create_time 创建时间【默认值】 last_time 更新时间 |
| 2 | start_date | 开始时间 | string | — | Optional | 开始时间,格式:Y-m-d,双闭区间 当筛选更新时间时,支持Y-m-d或Y-m-d H:i:s |
| 3 | end_date | 结束时间 | string | — | Optional | 结束时间,格式:Y-m-d,双闭区间 当筛选更新时间时,支持Y-m-d或Y-m-d H:i:s |
| 4 | status | 状态 | array<any> | — | Optional | 状态: 121 待审批 122 已驳回 124 已作废(审批作废) 10 已处理 20 已作废(单据作废) 5 待退货 |
| 5 | offset | 分页偏移量 | integer | — | Required | 分页偏移量 |
| 6 | length | 分页长度 | integer | — | Required | 分页长度,上限500 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0 成功 |
| 2 | message | 消息提示 | string | success | Required | 消息提示 |
| 3 | error_details | 错误信息 | array<any> | [] | Required | 错误信息 |
| 4 | request_id | 请求链路id | string | 929A1D7D-D656-0EA0-C78A-A686790C7090 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2022-05-20 16:57:03 | Required | 响应时间 |
| 6 | data | 响应数据 | object | — | Required | 响应数据 |
| 6.1 | total | 总数 | integer | 1000 | Required | 总数 |
| 6.2 | list | 列表 | array<object> | — | Required | 列表 |
| 6.2.1 | wid | 仓库id | integer | 1 | Required | 仓库id |
| 6.2.2 | order_sn | 退货单号 | string | PR220520004 | Required | 退货单号 |
| 6.2.3 | create_uid | 创建人id | integer | 125 | Required | 创建人id |
| 6.2.4 | create_realname | 创建人名称 | string | JSTAPI | Required | 创建人名称 |
| 6.2.5 | create_time | 创建时间 | string | 2022-05-20 11:48:23 | Required | 创建时间 |
| 6.2.6 | last_time | 更新时间 | string | 2022-05-20 11:48:23 | Required | 更新时间 |
| 6.2.7 | buyer_uid | 采购员id | integer | 175 | Required | 采购员id |
| 6.2.8 | buyer_realname | 采购员名称 | string | API | Required | 采购员名称 |
| 6.2.9 | purchase_order_sn | 采购单号 | string | PO220513032 | Required | 采购单号 |
| 6.2.10 | supplier_id | 供应商id | integer | 12 | Required | 供应商id |
| 6.2.11 | supplier_name | 供应商名称 | string | 供应商3 | Required | 供应商名称 |
| 6.2.12 | return_method | 退货方式 | integer | 1 | Required | 退货方式:1 退货扣款,2 退货补货 |
| 6.2.13 | replenish_method | 补货方式 | integer | — | Required | 补货方式:1 源单补货 |
| 6.2.14 | receipt_funds_order_sn | 收款单号 | string | — | Required | 收款单号 |
| 6.2.15 | status | 状态 | integer | 10 | Required | 状态: 121 待审批 122 已驳回 124 已作废(审批作废) 10 已处理 20 已作废(单据作废) |
| 6.2.16 | purchase_currency | 采购币种 | string | CNY | Required | 采购币种 |
| 6.2.17 | purchase_currency_icon | 采购币种符号 | string | ¥ | Required | 采购币种符号 |
| 6.2.18 | fee_part_type | 费用分配方式 | integer | — | Required | 费用分配方式: 0 不分配 1 按金额 2 按数量 |
| 6.2.19 | shipping_currency | 运费币种 | string | CNY | Required | 运费币种 |
| 6.2.20 | shipping_price | 退货运费 | number | 0 | Required | 退货运费 |
| 6.2.21 | other_currency | 其他费用币种 | string | CNY | Required | 其他费用币种 |
| 6.2.22 | other_fee | 其他费用 | number | 0 | Required | 其他费用 |
| 6.2.23 | return_reason | 退货原因 | string | 单品0001破损 | Required | 退货原因 |
| 6.2.24 | return_amount_total | 退货总金额 | string | — | Required | 退货总金额 |
| 6.2.25 | remark | 单据备注 | string | 破损需要退货 | Required | 单据备注 |
| 6.2.26 | item_list | 子项列表 | array<object> | — | Required | 子项列表 |
| 6.2.26.1 | item_id | 子项id | integer | 313 | Required | 子项id |
| 6.2.26.2 | spu_name | 款名 | string | SPU NAME | Required | 款名 |
| 6.2.26.3 | spu | spu | string | SPU1 | Required | SPU |
| 6.2.26.4 | product_name | 品名 | string | 单品0001 | Required | 品名 |
| 6.2.26.5 | sku | sku | string | DP0001 | Required | SKU |
| 6.2.26.6 | fnsku | fnsku | string | — | Required | FNSKU |
| 6.2.26.7 | msku | msku | array<any> | — | Required | MSKU |
| 6.2.26.8 | attribute | 属性 | array<object> | — | Required | 属性 |
| 6.2.26.8.1 | attr_id | 属性id | string | 1 | Required | 属性id |
| 6.2.26.8.2 | attr_name | 属性名 | string | 颜色 | Required | 属性名 |
| 6.2.26.8.3 | attr_value | 属性值 | string | 白 | Required | 属性值 |
| 6.2.26.9 | price | 含税单价 | number | 1 | Required | 含税单价 |
| 6.2.26.10 | quantity_real | 采购数量 | integer | 20 | Required | 采购数量 |
| 6.2.26.11 | return_good_num | 良品退货量 | integer | 5 | Required | 良品退货量 |
| 6.2.26.12 | return_bad_num | 次品退货量 | integer | — | Required | 次品退货量 |
| 6.2.26.13 | replenish_num | 扣款数量 | integer | 5 | Required | 扣款数量 |
| 6.2.26.14 | deduction_amount | 退货金额 | number | 5 | Required | 退货金额 |
| 6.2.26.15 | expect_arrive_time | 预计到货时间 | string | | Required | 预计到货时间 |
| 6.2.26.16 | remark | 备注 | string | 破损 | Required | 备注 |
The 查询采购退货单列表 API (/erp/sc/routing/purchase/purchase_return_order/getPurchaseReturnOrderList) of 领星ERP is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with 领星ERP version updates.
Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.