/erp/sc/routing/data/local_inventory/getBatchStatementList{
"operation": {
"method": "POST",
"path": "/erp/sc/routing/data/local_inventory/getBatchStatementList"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": {
"offset": 0,
"length": 20,
"wid_list": "1,5,18",
"statement_type_list": "19",
"search_field": "order_sn",
"search_value": "IB240725061",
"time_filter_field": "operate_time",
"start_date": "2024-07-29",
"end_date": "2024-07-29"
},
"responseExample": {
"code": 0,
"message": "success",
"error_details": [],
"request_id": "C27EE726-A102-114B-39B3-1A15BA36ED97",
"response_time": "2023-09-04 18:44:45",
"data": [
{
"wid": 46,
"wh_name": "自动化专用仓01",
"batch_no": "401352709134771204-1",
"source_batch_no": [],
"order_sn": "IB230829053",
"type": "1901",
"type_name": "其他入库",
"batch_time": "2023-09-04 18:44:45",
"opt_uid": 10580661,
"opt_name": "张三",
"update_time": "2023-09-04 18:44:45",
"product_id": 22383,
"product_name": "cecece",
"sku": "cecece",
"msku": "",
"fnsku": "",
"batch_state_id": "401352709134771204-1",
"store_id": "0",
"store_name": "",
"transit_balance_num": 0,
"balance_num": 2,
"good_transit_num": 0,
"bad_transit_num": 0,
"qc_num": 0,
"good_num": 1,
"bad_num": 1,
"stock_cost": "38.00",
"fee": "2.00",
"head_stock_cost": "0.00",
"amount": "36.00",
"plan_sn": [],
"purchase_order_sns": [],
"delivery_order_sns": [],
"supplier_ids": [],
"supplier_names": []
}
],
"total": 29866
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | statement_type_list | 批次流水主类型id | string | — | Optional | 批次流水主类型id,多个使用英文逗号分隔: 19 其他入库 22 采购入库 24 调拨入库 23 委外入库 25 盘盈入库 16 换标入库 17 加工入库 18 拆分入库 47 VC-PO出库 48 VC-DF出库 49 Temu出库 42 其他出库 41 调拨出库 32 委外出库 33 盘亏出库 34 换标出库 35 加工出库 36 拆分出库 37 FBA出库 38 FBM出库 39 退货出库 26 退货入库 27 移除入库 28 采购质检 29 委外质检 71 采购上架 72 委外上架 65 WFS出库 45 赠品入库 46 赠品质检入库 73 赠品上架 201 期初成本调整 202 尾差成本调整 |
| 2 | search_field | 搜索字段 | string | — | Optional | 搜索字段: sku SKU msku MSKU fnsku FNSKU product_name 品名 purchase_plan 采购计划 purchase_order 采购单 receipt_order 收货单 order_sn 单据号 batch_number 批次号 source_batch_number 源头批次号 |
| 3 | search_value | 搜索值 | string | — | Optional | 搜索值 |
| 4 | wid_list | 仓库id | string | — | Optional | 仓库id,多个使用英文逗号分隔 |
| 5 | time_filter_field | 时间筛选字段 | string | — | Optional | 时间筛选字段: operate_time 操作时间 update_time 更新时间 |
| 6 | start_date | 开始日期 | string | — | Optional | 开始日期,格式:Y-m-d |
| 7 | end_date | 结束日期 | string | — | Optional | 结束日期,格式:Y-m-d |
| 8 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量,默认0 |
| 9 | length | 分页长度 | integer | — | Optional | 分页长度,默认20,上限400 |
| 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 | 22E246A9-3384-5776-88EE-A477D86E39E3 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2022-03-23 09:17:03 | Required | 响应时间 |
| 6 | total | 总数 | integer | 1 | Required | 总数 |
| 7 | data | 响应数据 | array<object> | — | Required | 响应数据 |
| 7.1 | batch_state_id | 批次流水id | string | 401352725598155786-1 | Required | 批次流水id |
| 7.2 | type | 批次流水子类型id | integer | 3801 | Required | 批次流水子类型id |
| 7.3 | type_name | 流水类型名称 | string | FBM出库 | Required | 流水类型名称 |
| 7.4 | batch_time | 操作时间 | string | 2024-07-29 15:06:34 | Required | 操作时间 |
| 7.5 | opt_uid | 操作人 UID | integer | 10580661 | Required | 操作人 UID |
| 7.6 | opt_name | 操作人名称 | string | 张三 | Required | 操作人名称 |
| 7.7 | update_time | 更新时间 | string | 2024-07-29 15:06:34 | Required | 更新时间 |
| 7.8 | batch_no | 批次号 | string | 401352725598155786-1 | Required | 批次号 |
| 7.9 | order_sn | 单据号 | string | WO103352725767942656 | Required | 单据号 |
| 7.10 | source_batch_no | 源头批次号 | array<any> | ["401333177275752464-1","401333177275752465-1"] | Required | 源头批次号 |
| 7.11 | source_order_sn | 源头单据号 | array<any> | ["IB230711005"] | Required | 源头单据号 |
| 7.12 | product_id | 本地产品id | integer | 4 | Required | 本地产品id |
| 7.13 | product_name | 品名 | string | [演示数据]适用于iPad的手写笔带手掌柜绝 | Required | 品名 |
| 7.14 | sku | sku | string | SKUDF2B4A9 | Required | SKU |
| 7.15 | store_id | 店铺id | string | 0 | Required | 店铺id |
| 7.16 | store_name | 店铺名称 | string | xx店铺 | Required | 店铺名称 |
| 7.17 | msku | msku | string | sssds | Required | MSKU |
| 7.18 | fnsku | fnsku | string | ssrsd | Required | FNSKU |
| 7.19 | wid | 仓库id | integer | 5 | Required | 仓库id |
| 7.20 | wh_name | 仓库名称 | string | 仓库 | Required | 仓库名称 |
| 7.21 | transit_balance_num | 在途结存量 | integer | 0 | Required | 在途结存量 |
| 7.22 | balance_Num | 在库结存量 | integer | 0 | Required | 在库结存量 |
| 7.23 | good_transit_num | 可用在途量 | integer | 0 | Required | 可用在途量 |
| 7.24 | bad_transit_num | 次品在途量 | integer | 0 | Required | 次品在途量 |
| 7.25 | qc_num | 待检量 | integer | 0 | Required | 待检量 |
| 7.26 | good_num | 可用量 | integer | 0 | Required | 可用量 |
| 7.27 | bad_num | 次品量 | integer | 0 | Required | 次品量 |
| 7.28 | amount | 货值 | string | 5.4 | Required | 货值 |
| 7.29 | fee | 费用 | string | 4.3 | Required | 费用 |
| 7.30 | head_stock_cost | 头程 | string | 2.1 | Required | 头程 |
| 7.31 | stock_cost | 库存成本 | string | 3.6 | Required | 库存成本 |
| 7.32 | plan_sn | 采购计划单号信息 | array<any> | ["PP230711011"] | Required | 采购计划单号信息 |
| 7.33 | purchase_order_sns | 采购单单号信息 | array<any> | ["PO230711011"] | Required | 采购单单号信息 |
| 7.34 | delivery_order_sns | 收货单单号信息 | array<any> | ["CR230711004"] | Required | 收货单单号信息 |
| 7.35 | supplier_ids | 供应商id信息 | array<any> | ["5216"] | Required | 供应商id信息 |
| 7.36 | supplier_names | 供应商名称信息 | array<any> | ["供应商1","供应商2"] | Required | 供应商名称信息 |
The 查询批次流水 API (/erp/sc/routing/data/local_inventory/getBatchStatementList) 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.