Qeasy Cloud
Get Started

领星ERP 查询批次流水 API

Platform
领星ERP
Type
WebAPI
Effect
QUERY
API Version
1.0
Adapter
\Adapter\LingXing\LXQueryAdapter
Auth Mode
OTHER
Description
仓库 / 库存&流水 · POST · 请求参数 9 个(必填 0) · 响应参数 43 个 · 限流令牌桶容量 1
Updated At
2026-11-21

查询批次流水

POST/erp/sc/routing/data/local_inventory/getBatchStatementList
Factory
{
  "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
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1statement_type_list批次流水主类型idstring—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 尾差成本调整
2search_field搜索字段string—Optional搜索字段: sku SKU msku MSKU fnsku FNSKU product_name 品名 purchase_plan 采购计划 purchase_order 采购单 receipt_order 收货单 order_sn 单据号 batch_number 批次号 source_batch_number 源头批次号
3search_value搜索值string—Optional搜索值
4wid_list仓库idstring—Optional仓库id,多个使用英文逗号分隔
5time_filter_field时间筛选字段string—Optional时间筛选字段: operate_time 操作时间 update_time 更新时间
6start_date开始日期string—Optional开始日期,格式:Y-m-d
7end_date结束日期string—Optional结束日期,格式:Y-m-d
8offset分页偏移量integer—Optional分页偏移量,默认0
9length分页长度integer—Optional分页长度,默认20,上限400

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer0Required状态码,0 成功
2message消息提示stringsuccessRequired消息提示
3error_details错误信息array<any>—Required错误信息
4request_id请求链路idstring22E246A9-3384-5776-88EE-A477D86E39E3Required请求链路id
5response_time响应时间string2022-03-23 09:17:03Required响应时间
6total总数integer1Required总数
7data响应数据array<object>—Required响应数据
7.1batch_state_id批次流水idstring401352725598155786-1Required批次流水id
7.2type批次流水子类型idinteger3801Required批次流水子类型id
7.3type_name流水类型名称stringFBM出库Required流水类型名称
7.4batch_time操作时间string2024-07-29 15:06:34Required操作时间
7.5opt_uid操作人 UIDinteger10580661Required操作人 UID
7.6opt_name操作人名称string张三Required操作人名称
7.7update_time更新时间string2024-07-29 15:06:34Required更新时间
7.8batch_no批次号string401352725598155786-1Required批次号
7.9order_sn单据号stringWO103352725767942656Required单据号
7.10source_batch_no源头批次号array<any>["401333177275752464-1","401333177275752465-1"]Required源头批次号
7.11source_order_sn源头单据号array<any>["IB230711005"]Required源头单据号
7.12product_id本地产品idinteger4Required本地产品id
7.13product_name品名string[演示数据]适用于iPad的手写笔带手掌柜绝Required品名
7.14skuskustringSKUDF2B4A9RequiredSKU
7.15store_id店铺idstring0Required店铺id
7.16store_name店铺名称stringxx店铺Required店铺名称
7.17mskumskustringsssdsRequiredMSKU
7.18fnskufnskustringssrsdRequiredFNSKU
7.19wid仓库idinteger5Required仓库id
7.20wh_name仓库名称string仓库Required仓库名称
7.21transit_balance_num在途结存量integer0Required在途结存量
7.22balance_Num在库结存量integer0Required在库结存量
7.23good_transit_num可用在途量integer0Required可用在途量
7.24bad_transit_num次品在途量integer0Required次品在途量
7.25qc_num待检量integer0Required待检量
7.26good_num可用量integer0Required可用量
7.27bad_num次品量integer0Required次品量
7.28amount货值string5.4Required货值
7.29fee费用string4.3Required费用
7.30head_stock_cost头程string2.1Required头程
7.31stock_cost库存成本string3.6Required库存成本
7.32plan_sn采购计划单号信息array<any>["PP230711011"]Required采购计划单号信息
7.33purchase_order_sns采购单单号信息array<any>["PO230711011"]Required采购单单号信息
7.34delivery_order_sns收货单单号信息array<any>["CR230711004"]Required收货单单号信息
7.35supplier_ids供应商id信息array<any>["5216"]Required供应商id信息
7.36supplier_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.

Need to integrate this API?

Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.