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 · 请求参数 6 个(必填 0) · 响应参数 35 个 · 限流令牌桶容量 1
Updated At
2026-11-21

查询库存流水(旧)

POST/erp/sc/routing/data/local_inventory/wareHouseStatement
Factory
{
  "operation": {
    "method": "POST",
    "path": "/erp/sc/routing/data/local_inventory/wareHouseStatement"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 1,
    "text": ""
  },
  "requestExample": {
    "offset": 0,
    "length": 20,
    "wid": "1,5,18",
    "start_date": "2024-07-29",
    "end_date": "2024-07-29",
    "type": "100"
  },
  "responseExample": {
    "code": 0,
    "message": "success",
    "error_details": [],
    "request_id": "596A9701-F2B8-1291-3EFC-9099C295A9C4",
    "response_time": "2024-07-31 15:39:39",
    "data": [
      {
        "wid": 18,
        "ware_house_name": "深圳仓",
        "order_sn": "PT240729003",
        "product_id": 33043,
        "product_name": "电脑cyt",
        "sku": "diannaocyt",
        "seller_id": "0",
        "fnsku": "",
        "product_good_num": -10,
        "product_bad_num": 0,
        "product_qc_num": 0,
        "product_lock_num": 10,
        "price": "",
        "amount": "",
        "product_amounts": "",
        "type": 100,
        "type_text": "库存调整",
        "fee_cost": "",
        "single_cg_price": "",
        "single_fee_cost": "",
        "opt_uid": 10603434,
        "opt_time": "2024-07-29 20:12",
        "opt_realname": "马旭哲",
        "cancel_time": "",
        "remark": "加工单锁定库存",
        "bid": 0,
        "brand_name": "",
        "ref_order_sn": "",
        "product_total": 0,
        "statement_id": "401469208181637651"
      }
    ],
    "total": 32
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1wid仓库IDstring—Optional仓库ID,多个仓库ID用英文逗号分隔,不填默认所有仓库
2type流水类型string—Optional流水类型:【多个流水类型用英文逗号分隔,不填默认全部类型】 1 其他入库 2 采购入库 3 调拨入库 10 其它入库(已撤销) 11 其他出库 12 FBA出库 13 调拨出库 14 退货出库 15 FBM退货 16 换标入库 17 加工入库 18 拆分入库 20 采购入库(已撤销) 21 库存调整 23 委外入库 25 盘盈入库 32 委外出库 33 盘亏出库 34 换标出库 35 加工出库 36 拆分出库 43 FBM出库 50 成本补录 110 其它出库(已撤销) 120 FBA出库(已撤销) 130 调拨出库(已撤销) 140 退货出库(已撤销) 210 库存调整(已撤销) 500 成本补录(已撤销)
3start_date操作开始时间string—Optional操作开始时间,格式:Y-m-d,闭区间,联合结束时间使用
4end_date操作结束时间string—Optional操作结束时间,格式:Y-m-d,开区间,联合开始时间使用
5offset分页偏移量integer—Optional分页偏移量,默认0
6length分页长度integer—Optional分页长度,默认20

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer0Required状态码,0 成功
2message消息提示stringsuccessRequired消息提示
3error_details错误信息array<any>—Required错误信息
4request_id请求链路idstringCF670F06-BD65-E580-7018-47219C66AC26Required请求链路id
5response_time响应时间string2020-05-18 11:23:47Required响应时间
6data响应数据array<object>—Required响应数据
6.1statement_id流水IDstring11036Required流水ID
6.2wid仓库IDinteger8Required仓库ID
6.3ware_house_name仓库名string测试仓库Required仓库名
6.4bid商品品牌IDinteger18Required商品品牌ID
6.5order_sn单据号stringOB220527028Required单据号
6.6product_id商品IDinteger18232Required商品ID
6.7product_name品名stringAA-组合3Required品名
6.8skuskustringAA-组合3RequiredSKU
6.9fnskufnskustring—RequiredFNSKU
6.10product_total商品总量number—Required商品总量
6.11product_good_num良品量number—Required良品量
6.12product_bad_num次品量number—Required次品量
6.13product_qc_num质检量number—Required质检量
6.14product_lock_num锁定量number—Required锁定量
6.15price单价number1Required单价
6.16amount金额number0Required金额
6.17type流水类型string1Required流水类型: 1 其他入库 2 采购入库 3 调拨入库 10 其它入库(已撤销) 11 其他出库 12 FBA出库 13 调拨出库 14 退货出库 15 FBM退货 16 换标入库 17 加工入库 18 拆分入库 20 采购入库(已撤销) 21 库存调整 23 委外入库 25 盘盈入库 32 委外出库 33 盘亏出库 34 换标出库 35 加工出库 36 拆分出库 43 FBM出库 50 成本补录 110 其它出库(已撤销) 120 FBA出库(已撤销) 130 调拨出库(已撤销) 140 退货出库(已撤销) 210 库存调整(已撤销) 500 成本补录(已撤销)
6.18remark备注string库存初始化Required备注
6.19opt_uid操作人员IDinteger230Required操作人员ID
6.20opt_time操作时间string2020-09-05 16:23Required操作时间
6.21cancel_time撤销时间string2020-09-06 10:23Required撤销时间
6.22fee_cost费用成本string0.00Required费用成本
6.23brand_name品牌stringNew deskRequired品牌
6.24single_fee_cost单位费用成本number0Required单位费用成本
6.25single_cg_price采购单价number1Required采购单价
6.26product_amounts货值number0Required货值
6.27type_text流水类型文本string其他入库Required流水类型文本
6.28opt_realname操作人员姓名string李XRequired操作人员姓名
7total总数目integer1Required总数目

The 查询库存流水(旧) API (/erp/sc/routing/data/local_inventory/wareHouseStatement) 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.