/erp/sc/routing/data/local_inventory/getBatchDetailList{
"operation": {
"method": "POST",
"path": "/erp/sc/routing/data/local_inventory/getBatchDetailList"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": {
"offset": 0,
"length": 20,
"show_zero_stock": 0,
"wid": "1,5,18",
"stock_in_type_list": "19",
"search_field": "product_name",
"search_value": "pan1575"
},
"responseExample": {
"code": 0,
"message": "success",
"error_details": [],
"request_id": "FE236155-8309-D871-F4B9-DC5D49F9EB36",
"response_time": "2023-09-04 18:41:31",
"data": [
{
"wid": 1,
"wh_name": "默认仓库",
"batch_no": "401286103900685831-1",
"source_batch_no": [],
"order_sn": "IB230228023",
"type": 2202,
"type_name": "采购入库",
"product_id": 18019,
"product_name": "A022401",
"sku": "A022401",
"msku": "",
"fnsku": "",
"store_id": "0",
"store_name": "",
"total": 1,
"transit_balance_num": 0,
"balance_num": 1,
"good_transit_num": 0,
"bad_transit_num": 0,
"qc_num": 0,
"good_num": 1,
"bad_num": 0,
"plan_sn": [],
"purchase_order_sns": [
"PO230228001"
],
"delivery_order_sns": [
"CR230228017"
],
"supplier_ids": [
"359"
],
"supplier_names": [
"xxx服装厂"
],
"purchase_in_time": "",
"purchase_price": 0,
"price": 0,
"head_stock_price": 0,
"stock_price": 0,
"storage_used_lock_num": 0,
"storage_defective_lock_num": 0,
"stock_cost": "5.23",
"fee": "1.23",
"head_stock_cost": "0.00",
"amount": "4.00"
}
],
"total": 15038
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量,默认0 |
| 2 | length | 分页长度 | integer | — | Optional | 分页长度,默认20,上限400 |
| 3 | show_zero_stock | 是否显示0库存信息 | integer | — | Optional | 是否显示0库存信息:0 不显示,1 显示 |
| 4 | wids | 仓库id | string | — | Optional | 仓库id,多个使用英文逗号分隔 |
| 5 | stock_in_type_list | 入库类型 | string | — | Optional | 入库类型,多个使用英文逗号分隔: 19 其他入库 22 采购入库 24 调拨入库 23 委外入库 25 盘盈入库 16 换标入库 17 加工入库 18 拆分入库 26 退货入库 27 移除入库 45 赠品入库 |
| 6 | search_field | 搜索字段 | string | — | Optional | 搜索字段: sku SKU msku MSKU fnsku FNSKU order_sn 单据号 product_name 品名 batch_number 批次号 receipt_order 收货单 purchase_order 采购单 purchase_plan 采购计划 source_batch_number 源头批次号 |
| 7 | search_value | 搜索值 | string | — | Optional | 搜索值 |
| 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 | D76CFAC8-3385-0A42-8916-A168F3449996 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2022-03-23 09:17:03 | Required | 响应时间 |
| 6 | total | 总数 | integer | 0 | Required | 总数 |
| 7 | data | 响应数据 | array<object> | — | Required | 响应数据 |
| 7.1 | batch_no | 批次号 | string | 401352726865658370-1 | Required | 批次号 |
| 7.2 | source_batch_no | 源头批次号 | string | ["401351566731194390-1"] | Required | 源头批次号 |
| 7.3 | order_sn | 入库单号 | string | PT230901004 | Required | 入库单号 |
| 7.4 | type | 入库类型 | integer | 1701 | Required | 入库类型 |
| 7.5 | type_name | 入库类型描述 | string | 加工入库 | Required | 入库类型描述 |
| 7.6 | product_id | 本地产品id | integer | 81892 | Required | 本地产品id |
| 7.7 | product_name | 品名 | string | 商品1 | Required | 品名 |
| 7.8 | sku | sku | string | 0710-1 | Required | SKU |
| 7.9 | store_id | 店铺id | string | 0 | Required | 店铺id |
| 7.10 | store_name | 店铺名称 | string | 店铺1 | Required | 店铺名称 |
| 7.11 | msku | msku | string | MSKU123 | Required | MSKU |
| 7.12 | fnsku | fnsku | string | FNSKU412 | Required | FNSKU |
| 7.13 | wid | 仓库id | integer | 24 | Required | 仓库id |
| 7.14 | wh_name | 仓库名称 | string | nickey111 | Required | 仓库名称 |
| 7.15 | total | 结存总数【在途结存 + 在库结存】 | integer | 20 | Required | 结存总数【在途结存 + 在库结存】 |
| 7.16 | transit_balance_num | 在途结存 | integer | 15 | Required | 在途结存 |
| 7.17 | balance_num | 在库结存 | integer | 5 | Required | 在库结存 |
| 7.18 | good_transit_num | 可用在途量 | integer | 2 | Required | 可用在途量 |
| 7.19 | bad_transit_num | 次品在途量 | integer | 3 | Required | 次品在途量 |
| 7.20 | qc_num | 待检量 | integer | 4 | Required | 待检量 |
| 7.21 | good_num | 可用量 | integer | 1 | Required | 可用量 |
| 7.22 | bad_num | 次品量 | integer | 10 | Required | 次品量 |
| 7.23 | plan_sn | 采购计划单号信息 | array<any> | ["PP230901003","PP230901002","PP230901001"] | Required | 采购计划单号信息 |
| 7.24 | purchase_order_sns | 采购单单号信息 | array<any> | ["PO230901001"] | Required | 采购单单号信息 |
| 7.25 | delivery_order_sns | 收货单单号信息 | array<any> | ["CR230901001"] | Required | 收货单单号信息 |
| 7.26 | supplier_ids | 供应商id信息 | array<any> | ["5221"] | Required | 供应商id信息 |
| 7.27 | supplier_names | 供应商名称列表 | array<any> | ["供应商1"] | Required | 供应商名称列表 |
| 7.28 | purchase_in_time | 入库时间 | string | — | Required | 入库时间 |
| 7.29 | purchase_price | 采购单价 | number | 0 | Required | 采购单价 |
| 7.30 | price | 单价 | number | 0 | Required | 单价 |
| 7.31 | head_stock_price | 头程单价 | number | 0 | Required | 头程单价 |
| 7.32 | stock_price | 库存成本单价 | number | 0 | Required | 库存成本单价 |
| 7.33 | storage_used_lock_num | 可用锁定数 | number | 0 | Required | 可用锁定数 |
| 7.34 | storage_defective_lock_num | 次品锁定数 | number | 0 | Required | 次品锁定数 |
| 7.35 | amount | 货值 | string | 2.5 | Required | 货值 |
| 7.36 | head_stock_cost | 头程 | string | 3.1 | Required | 头程 |
| 7.37 | fee | 费用 | string | 1.2 | Required | 费用 |
| 7.38 | stock_cost | 库存成本 | string | 2.3 | Required | 库存成本 |
The 查询批次明细 API (/erp/sc/routing/data/local_inventory/getBatchDetailList) 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.