/erp/sc/routing/inventoryReceipt/InventoryCheck/getOrderDetail{
"operation": {
"method": "POST",
"path": "/erp/sc/routing/inventoryReceipt/InventoryCheck/getOrderDetail"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": {
"order_sn": "IC240726001",
"search_field": "sku",
"search_value": "diannaotaozhuang",
"sort_field": "book_inventory",
"sort_type": "desc",
"page": 1,
"page_size": 20
},
"responseExample": {
"code": 0,
"message": "success",
"error_details": [],
"request_id": "7C458B32-D931-12D9-70F8-E6DB82598908",
"response_time": "2024-08-01 15:49:15",
"data": {
"order_sn": "IC240726001",
"status": 20,
"wid": 42,
"check_type": 1,
"check_uid": 10609364,
"is_display_check": 1,
"is_zero": 1,
"product_type": 15,
"create_time": "2024-07-26 16:32:20",
"create_uid": 10609364,
"check_time": "",
"real_check_uid": 0,
"commit_time": "",
"commit_uid": 0,
"cancel_time": "",
"cancel_uid": 0,
"cancel_reason": "",
"remark": "",
"request_status": 0,
"increment_time": "2024-07-26 16:32:51",
"check_type_text": "整仓盘点",
"status_text": "待盘点_预锁",
"check_user": "邓金琳",
"real_check_user": "",
"commit_user": "",
"create_user": "邓金琳",
"cancel_user": "",
"ware_house_name": "BTC",
"display_check_name": "明盘",
"product_list": [
{
"id": 511209,
"product_id": 18418,
"product_name": "电脑套装(电脑+鼠标+键盘)",
"sku": "diannaotaozhuang",
"fnsku": "",
"seller_id": "0",
"whb_id": 582,
"whb_code": "ts_valid",
"whb_type": 2,
"remark": "",
"actual_inventory": "",
"book_inventory": 0,
"different_count": "",
"whb_type_text": "可用暂存",
"whb_code_text": "可用暂存",
"pic_url": "https://image.umaicloud.com/erp-vue/90128554873982976/20220309/a51149090e274723a408d18bc0aad887.jpeg",
"seller_name": "",
"country_name": "",
"is_combo": 1,
"is_aux": 0
}
],
"total": 1,
"item_total": {
"book_inventory": "0",
"actual_inventory": 0,
"different_count": "0"
},
"file": []
},
"total": 0
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | order_sn | 盘点单号 | string | — | Required | 盘点单号 |
| 2 | search_field | 搜索字段 | string | — | Optional | 搜索字段: sku SKU fnsku FNSKU product_name 品名 whb_code_text 仓位 whb_type_text 仓位类型 |
| 3 | search_value | 搜索值 | string | — | Optional | 搜索值 |
| 4 | sort_field | 排序字段 | string | — | Optional | 排序字段: book_inventory 账面库存 actual_inventory 实盘库存 different_count 库存差异 |
| 5 | sort_type | 排序规则 | string | — | Optional | 排序规则:desc 降序【默认】,asc 升序 |
| 6 | page | 分页页码 | integer | — | Optional | 分页页码,默认1【控制 product_list 返回数目】 |
| 7 | page_size | 分页长度 | integer | — | Optional | 分页长度,默认20【控制 product_list 返回数目】 |
| 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 | D17B0688-C52D-1BA9-1BCC-50AA00058A3F | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2022-08-23 16:56:31 | Required | 响应时间 |
| 6 | data | 响应数据 | object | — | Required | 响应数据 |
| 6.1 | order_sn | 盘点单号 | string | IC220810001 | Required | 盘点单号 |
| 6.2 | status | 盘点状态 | integer | 40 | Required | 盘点状态: 10 待盘点 20 预锁 30 盘点中 40 已盘点 121 待审核 122 已驳回 123 通过 124 作废 |
| 6.3 | status_text | 状态文本 | string | 已盘点 | Required | 状态文本 |
| 6.4 | wid | 盘点仓库id | integer | 1 | Required | 盘点仓库id |
| 6.5 | ware_house_name | 盘点仓库名称 | string | 仓库1 | Required | 盘点仓库名称 |
| 6.6 | check_type | 盘点类型 | integer | 2 | Required | 盘点类型: 1 整仓盘点 2 SKU盘点 3 仓位盘点 4 SKU+仓位盘点 |
| 6.7 | check_type_text | 盘点类型说明 | string | SKU盘点 | Required | 盘点类型说明 |
| 6.8 | is_display_check | 是否明盘 | integer | 1 | Required | 是否明盘:0 否,1 是 |
| 6.9 | display_check_name | 是否明盘文本 | string | — | Required | 是否明盘文本 |
| 6.10 | is_zero | 是否零库存参与盘点 | integer | 1 | Required | 是否零库存参与盘点:0 否,1 是 |
| 6.11 | product_type | 产品种类 | integer | 1 | Required | 产品种类 |
| 6.12 | create_uid | 创建人id | integer | 10002789 | Required | 创建人id |
| 6.13 | create_user | 创建人姓名 | string | 张三 | Required | 创建人姓名 |
| 6.14 | create_time | 创建时间 | string | 2022-08-10 18:02:37 | Required | 创建时间 |
| 6.15 | check_uid | 盘点人id | integer | 10002789 | Required | 盘点人id |
| 6.16 | check_user | 盘点人姓名 | string | 张三 | Required | 盘点人姓名 |
| 6.17 | real_check_uid | 实际盘点人id | integer | 10002789 | Required | 实际盘点人id |
| 6.18 | real_check_user | 实际盘点人姓名 | string | 张三 | Required | 实际盘点人姓名 |
| 6.19 | check_time | 盘点时间 | string | 2022-08-10 18:02:37 | Required | 盘点时间 |
| 6.20 | commit_uid | 提交人id | integer | 10002789 | Required | 提交人id |
| 6.21 | commit_user | 提交人姓名 | string | 张三 | Required | 提交人姓名 |
| 6.22 | commit_time | 提交时间 | string | 2022-08-10 18:03:09 | Required | 提交时间 |
| 6.23 | cancel_uid | 作废人id | integer | — | Required | 作废人id |
| 6.24 | cancel_user | 作废人姓名 | string | — | Required | 作废人姓名 |
| 6.25 | cancel_time | 作废时间 | string | — | Required | 作废时间 |
| 6.26 | cancel_reason | 作废原因 | string | — | Required | 作废原因 |
| 6.27 | remark | 备注 | string | — | Required | 备注 |
| 6.28 | request_status | 单据状态 | integer | — | Required | 单据状态:0 正常,1 处理中 |
| 6.29 | file | 上传附件信息 | array<object> | — | Required | 上传附件信息 |
| 6.29.1 | file_id | 附件id | integer | — | Optional | 附件id |
| 6.29.2 | file_name | 附件名称 | string | — | Optional | 附件名称 |
| 6.29.3 | file_url | 附件URL | string | — | Optional | 附件URL |
| 6.30 | product_list | 盘点明细列表 | array<object> | — | Required | 盘点明细列表 |
| 6.30.1 | product_id | 本地产品id | integer | 9 | Required | 本地产品id |
| 6.30.2 | product_name | 品名 | string | [演示数据]Sony 儿童耳机 | Required | 品名 |
| 6.30.3 | sku | sku | string | 1164812 | Required | SKU |
| 6.30.4 | fnsku | fnsku | string | — | Required | FNSKU |
| 6.30.5 | seller_id | 店铺id | string | — | Required | 店铺id |
| 6.30.6 | seller_name | 店铺名称 | string | — | Required | 店铺名称 |
| 6.30.7 | country_name | 店铺所属国家名称 | string | — | Required | 店铺所属国家名称 |
| 6.30.8 | whb_id | 仓位id | integer | 2 | Required | 仓位id |
| 6.30.9 | whb_code | 仓位 | string | ts_valid | Required | 仓位 |
| 6.30.10 | whb_code_text | 仓位名称 | string | 可用暂存 | Required | 仓位名称 |
| 6.30.11 | whb_type | 仓位类型 | integer | 2 | Required | 仓位类型: 1 待检暂存 2 可用暂存 3 次品暂存 4 拣货暂存 5 可用 6 次品 7 可用在途 8 次品在途 |
| 6.30.12 | whb_type_text | 仓位类型文本 | string | 可用暂存 | Required | 仓位类型文本 |
| 6.30.13 | book_inventory | 账面库存 | integer | 80 | Required | 账面库存 |
| 6.30.14 | actual_inventory | 实盘库存 | integer | 70 | Required | 实盘库存 |
| 6.30.15 | different_count | 盘点差异 | integer | -10 | Required | 盘点差异 |
| 6.30.16 | remark | 明细备注 | string | — | Required | 明细备注 |
| 6.30.17 | pic_url | 产品图片链接 | string | https://xxx/xxx/.jpg | Required | 产品图片链接 |
| 6.30.18 | is_combo | 是否组合产品 | integer | — | Required | 是否组合产品:0 否,1 是 |
| 6.30.19 | is_aux | 是否辅料 | integer | — | Required | 是否辅料:0 否,1 是 |
| 6.31 | total | 盘点明细总数 | integer | 1 | Required | 盘点明细总数 |
| 6.32 | item_total | 盘点明细信息 | object | — | Required | 盘点明细信息 |
| 6.32.1 | book_inventory | 账面库存总数 | integer | 80 | Required | 账面库存总数 |
| 6.32.2 | actual_inventory | 实盘库存总数 | integer | 70 | Required | 实盘库存总数 |
| 6.32.3 | different_count | 盘点差异总数 | integer | -10 | Required | 盘点差异总数 |
The 查询盘点单详情 API (/erp/sc/routing/inventoryReceipt/InventoryCheck/getOrderDetail) 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.