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

库存报表 - 本地仓 - 新报表 - 明细

POST/inventory/center/openapi/storageReport/local/detail/page
Factory
{
  "operation": {
    "method": "POST",
    "path": "/inventory/center/openapi/storageReport/local/detail/page"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 3,
    "text": ""
  },
  "requestExample": {
    "offset": 1,
    "length": 15,
    "start_date": "2020-01-01",
    "end_date": "2024-08-05",
    "sys_wid": "1268,21"
  },
  "responseExample": {
    "code": 0,
    "message": "",
    "request_id": "99954c8d8cdc44f0b165331ec2ae7eff",
    "response_time": "2022-12-21 18:52:14",
    "total": 1,
    "data": [
      {
        "other_in_count": 0,
        "purchase_in_count": 0,
        "allocation_in_count": 0,
        "outsourcing_in_count": 0,
        "inventory_surplus_in_count": 0,
        "change_of_standard_in_count": 0,
        "processing_in_count": 0,
        "split_in_count": 0,
        "return_goods_in_count": 0,
        "remove_in_count": 0,
        "outsourcing_out_count": 0,
        "inventory_deficit_out_count": 0,
        "change_of_standard_out_count": 0,
        "processing_out_count": 0,
        "split_out_count": 0,
        "fba_out_count": 0,
        "fbm_out_count": 0,
        "purchase_return_count": 0,
        "allocation_out_count": 0,
        "other_out_count": 0,
        "wfs_out_count": 0,
        "gifts_in_cost": 0,
        "gifts_in_count": 0,
        "day_early_count": 443,
        "day_end_count": 443,
        "allocation_in_transit_count": 0,
        "other_in_cost": "0.00",
        "purchase_in_cost": "0.00",
        "allocation_in_cost": "0.00",
        "outsourcing_in_cost": "0.00",
        "inventory_surplus_in_cost": "0.00",
        "change_of_standard_in_cost": "0.00",
        "processing_in_cost": "0.00",
        "split_in_cost": "0.00",
        "return_goods_in_cost": "0.00",
        "remove_in_cost": "0.00",
        "outsourcing_out_cost": "0.00",
        "inventory_deficit_out_cost": "0.00",
        "change_of_standard_out_cost": "0.00",
        "processing_out_cost": "0.00",
        "split_out_cost": "0.00",
        "fba_out_cost": "0.00",
        "fbm_out_cost": "0.00",
        "purchase_return_cost": "0.00",
        "allocation_out_cost": "0.00",
        "other_out_cost": "0.00",
        "wfs_out_cost": "0.00",
        "day_early_cost": "0.00",
        "day_end_cost": "0.00",
        "allocation_in_transit_cost": "0.00",
        "cost_adjustment": "0.00",
        "rotation_day_count": "0.00",
        "rotation_rate_count": "0.0000",
        "sales_ratio_count": "0.0000",
        "rotation_day_cost": "0.00",
        "rotation_rate_cost": "0.0000",
        "sales_ratio_cost": "0.0000",
        "seller_name": null,
        "sys_wid": null,
        "ware_house_name": "仓库1",
        "brand": null,
        "product_name": "[演示数据]适用于iPad的手写笔带手掌柜绝",
        "spu": "",
        "spu_name": "",
        "sku": "SKU1991FC9",
        "fnsku": "",
        "category1": null,
        "category2": null,
        "category3": null,
        "global_tags": null,
        "product_type": "普通产品",
        "sku_attribute": null,
        "attribute_text": "全部",
        "child_list": [
          {
            "other_in_count": 0,
            "purchase_in_count": 0,
            "allocation_in_count": 0,
            "outsourcing_in_count": 0,
            "inventory_surplus_in_count": 0,
            "change_of_standard_in_count": 0,
            "processing_in_count": 0,
            "split_in_count": 0,
            "return_goods_in_count": 0,
            "remove_in_count": 0,
            "outsourcing_out_count": 0,
            "inventory_deficit_out_count": 0,
            "change_of_standard_out_count": 0,
            "processing_out_count": 0,
            "split_out_count": 0,
            "fba_out_count": 0,
            "fbm_out_count": 0,
            "purchase_return_count": 0,
            "allocation_out_count": 0,
            "other_out_count": 0,
            "wfs_out_count": 0,
            "gifts_in_cost": 0,
            "gifts_in_count": 0,
            "day_early_count": 440,
            "day_end_count": 440,
            "allocation_in_transit_count": 0,
            "other_in_cost": "0.00",
            "purchase_in_cost": "0.00",
            "allocation_in_cost": "0.00",
            "outsourcing_in_cost": "0.00",
            "inventory_surplus_in_cost": "0.00",
            "change_of_standard_in_cost": "0.00",
            "processing_in_cost": "0.00",
            "split_in_cost": "0.00",
            "return_goods_in_cost": "0.00",
            "remove_in_cost": "0.00",
            "outsourcing_out_cost": "0.00",
            "inventory_deficit_out_cost": "0.00",
            "change_of_standard_out_cost": "0.00",
            "processing_out_cost": "0.00",
            "split_out_cost": "0.00",
            "fba_out_cost": "0.00",
            "fbm_out_cost": "0.00",
            "purchase_return_cost": "0.00",
            "allocation_out_cost": "0.00",
            "other_out_cost": "0.00",
            "wfs_out_cost": "0.00",
            "day_early_cost": "0.00",
            "day_end_cost": "0.00",
            "allocation_in_transit_cost": "0.00",
            "cost_adjustment": "0.00",
            "rotation_day_count": "0.00",
            "rotation_rate_count": "0.0000",
            "sales_ratio_count": "0.0000",
            "rotation_day_cost": "0.00",
            "rotation_rate_cost": "0.0000",
            "sales_ratio_cost": "0.0000",
            "seller_name": null,
            "sys_wid": null,
            "ware_house_name": "仓库1",
            "brand": null,
            "product_name": "[演示数据]适用于iPad的手写笔带手掌柜绝",
            "spu": "",
            "spu_name": "",
            "sku": "SKU1991FC9",
            "fnsku": "",
            "category1": null,
            "category2": null,
            "category3": null,
            "global_tags": null,
            "product_type": "普通产品",
            "sku_attribute": null,
            "attribute_text": "可售",
            "child_list": null
          },
          {
            "other_in_count": 0,
            "purchase_in_count": 0,
            "allocation_in_count": 0,
            "outsourcing_in_count": 0,
            "inventory_surplus_in_count": 0,
            "change_of_standard_in_count": 0,
            "processing_in_count": 0,
            "split_in_count": 0,
            "return_goods_in_count": 0,
            "remove_in_count": 0,
            "outsourcing_out_count": 0,
            "inventory_deficit_out_count": 0,
            "change_of_standard_out_count": 0,
            "processing_out_count": 0,
            "split_out_count": 0,
            "fba_out_count": 0,
            "fbm_out_count": 0,
            "purchase_return_count": 0,
            "allocation_out_count": 0,
            "other_out_count": 0,
            "wfs_out_count": 0,
            "day_early_count": 0,
            "day_end_count": 0,
            "allocation_in_transit_count": 0,
            "other_in_cost": "0.00",
            "purchase_in_cost": "0.00",
            "allocation_in_cost": "0.00",
            "outsourcing_in_cost": "0.00",
            "inventory_surplus_in_cost": "0.00",
            "change_of_standard_in_cost": "0.00",
            "processing_in_cost": "0.00",
            "split_in_cost": "0.00",
            "return_goods_in_cost": "0.00",
            "remove_in_cost": "0.00",
            "outsourcing_out_cost": "0.00",
            "inventory_deficit_out_cost": "0.00",
            "change_of_standard_out_cost": "0.00",
            "processing_out_cost": "0.00",
            "split_out_cost": "0.00",
            "fba_out_cost": "0.00",
            "fbm_out_cost": "0.00",
            "purchase_return_cost": "0.00",
            "allocation_out_cost": "0.00",
            "other_out_cost": "0.00",
            "wfs_out_cost": "0.00",
            "day_early_cost": "0.00",
            "day_end_cost": "0.00",
            "allocation_in_transit_cost": "0.00",
            "cost_adjustment": "0.00",
            "rotation_day_count": "0.00",
            "rotation_rate_count": "0.0000",
            "sales_ratio_count": "0.0000",
            "rotation_day_cost": "0.00",
            "rotation_rate_cost": "0.0000",
            "sales_ratio_cost": "0.0000",
            "seller_name": null,
            "sys_wid": null,
            "ware_house_name": "仓库1",
            "brand": null,
            "product_name": "[演示数据]适用于iPad的手写笔带手掌柜绝",
            "spu": "",
            "spu_name": "",
            "sku": "SKU1991FC9",
            "fnsku": "",
            "category1": null,
            "category2": null,
            "category3": null,
            "global_tags": null,
            "product_type": "普通产品",
            "sku_attribute": null,
            "attribute_text": "待检",
            "child_list": null
          },
          {
            "other_in_count": 0,
            "purchase_in_count": 0,
            "allocation_in_count": 0,
            "outsourcing_in_count": 0,
            "inventory_surplus_in_count": 0,
            "change_of_standard_in_count": 0,
            "processing_in_count": 0,
            "split_in_count": 0,
            "return_goods_in_count": 0,
            "remove_in_count": 0,
            "outsourcing_out_count": 0,
            "inventory_deficit_out_count": 0,
            "change_of_standard_out_count": 0,
            "processing_out_count": 0,
            "split_out_count": 0,
            "fba_out_count": 0,
            "fbm_out_count": 0,
            "purchase_return_count": 0,
            "allocation_out_count": 0,
            "other_out_count": 0,
            "wfs_out_count": 0,
            "day_early_count": 3,
            "day_end_count": 3,
            "allocation_in_transit_count": 0,
            "other_in_cost": "0.00",
            "purchase_in_cost": "0.00",
            "allocation_in_cost": "0.00",
            "outsourcing_in_cost": "0.00",
            "inventory_surplus_in_cost": "0.00",
            "change_of_standard_in_cost": "0.00",
            "processing_in_cost": "0.00",
            "split_in_cost": "0.00",
            "return_goods_in_cost": "0.00",
            "remove_in_cost": "0.00",
            "outsourcing_out_cost": "0.00",
            "inventory_deficit_out_cost": "0.00",
            "change_of_standard_out_cost": "0.00",
            "processing_out_cost": "0.00",
            "split_out_cost": "0.00",
            "fba_out_cost": "0.00",
            "fbm_out_cost": "0.00",
            "purchase_return_cost": "0.00",
            "allocation_out_cost": "0.00",
            "other_out_cost": "0.00",
            "wfs_out_cost": "0.00",
            "day_early_cost": "0.00",
            "day_end_cost": "0.00",
            "allocation_in_transit_cost": "0.00",
            "cost_adjustment": "0.00",
            "rotation_day_count": "0.00",
            "rotation_rate_count": "0.0000",
            "sales_ratio_count": "0.0000",
            "rotation_day_cost": "0.00",
            "rotation_rate_cost": "0.0000",
            "sales_ratio_cost": "0.0000",
            "seller_name": null,
            "sys_wid": null,
            "ware_house_name": "仓库1",
            "brand": null,
            "product_name": "[演示数据]适用于iPad的手写笔带手掌柜绝",
            "spu": "",
            "spu_name": "",
            "sku": "SKU1991FC9",
            "fnsku": "",
            "category1": null,
            "category2": null,
            "category3": null,
            "global_tags": null,
            "product_type": "普通产品",
            "sku_attribute": null,
            "attribute_text": "不可售",
            "child_list": null
          }
        ]
      }
    ]
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1offset分页页码integer—Required分页页码,默认1
2length分页长度integer—Required分页长度,默认15,不超过100
3start_date开始时间string—Required开始时间,格式:Y-m-d
4end_date结束时间string—Required结束时间,格式:Y-m-d
5sys_wid系统仓库idstring—Optional系统仓库id,多个用英文逗号分隔

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer0Required状态码,0 成功
2message消息string—Required消息
3request_id请求链路idstringc39932cfb78143f48235d2ccbc87cb80Required请求链路id
4response_time响应时间string2022-12-21 18:43:02Required响应时间
5total总数integer1Required总数
6data响应数据array<object>—Required响应数据
6.1sys_wid系统仓库IDinteger1Required系统仓库ID
6.2ware_house_name仓库名称string仓库1Required仓库名称
6.3seller_name店铺名称string店铺2Required店铺名称
6.4product_name商品名称string[演示数据]Sony ZX系列有线头戴式耳机 黑色 MDR-ZX110Required商品名称
6.5product_type产品类型string普通产品Required产品类型:普通产品 组合产品 辅料 捆绑产品
6.6skuskustringSKU37E3BFFRequiredSKU
6.7fnskufnskustringFND1D7401RequiredFNSKU
6.8spuspustring—RequiredSPU
6.9spu_name款名string—Required款名
6.10brand品牌名称string品牌1Required品牌名称
6.11category1一级类目-名称string分类3Required一级类目-名称
6.12category2二级类目-名称string—Required二级类目-名称
6.13category3三级类目-名称string—Required三级类目-名称
6.14attribute_text库存属性string全部Required库存属性: 全部可售待检不可售
6.15global_tags产品标签列表array<any>—Required产品标签列表
6.16sku_attribute产品属性array<any>—Required产品属性
6.17allocation_in_cost调拨入库-成本(精度number0Required调拨入库-成本(精度:2位小数点)
6.18allocation_in_count调拨入库-数量number—Required调拨入库-数量
6.19allocation_in_transit_cost期末在途-成本(精度number0Required期末在途-成本(精度:2位小数点)
6.20allocation_in_transit_count期末在途-数量number—Required期末在途-数量
6.21allocation_out_cost调拨出库-成本(精度number0Required调拨出库-成本(精度:2位小数点)
6.22allocation_out_count调拨出库-数量number—Required调拨出库-数量
6.23change_of_standard_in_cost换标入库-成本(精度number0Required换标入库-成本(精度:2位小数点)
6.24change_of_standard_in_count换标入库-数量number—Required换标入库-数量
6.25change_of_standard_out_cost换标出库-成本(精度number0Required换标出库-成本(精度:2位小数点)
6.26change_of_standard_out_count换标出库-数量number—Required换标出库-数量
6.27cost_adjustment成本调整(精度number0Required成本调整(精度:2位小数点)
6.28day_early_cost期初库存-成本(精度number0Required期初库存-成本(精度:2位小数点)
6.29day_early_count期初库存-数量number—Required期初库存-数量
6.30day_end_cost期末库存-成本(精度number0Required期末库存-成本(精度:2位小数点)
6.31day_end_count期末库存-数量number—Required期末库存-数量
6.32fba_out_costfba出库-成本(精度number0Requiredfba出库-成本(精度:2位小数点)
6.33fba_out_countfba出库-数量number—Requiredfba出库-数量
6.34fbm_out_costfbm出库-成本(精度number0Requiredfbm出库-成本(精度:2位小数点)
6.35fbm_out_countfbm出库-数量number—Requiredfbm出库-数量
6.36inventory_deficit_out_cost盘亏出库-成本(精度number0Required盘亏出库-成本(精度:2位小数点)
6.37inventory_deficit_out_count盘亏出库-数量number—Required盘亏出库-数量
6.38inventory_surplus_in_cost盘盈入库-成本(精度number0Required盘盈入库-成本(精度:2位小数点)
6.39inventory_surplus_in_count盘盈入库-数量number—Required盘盈入库-数量
6.40other_in_cost其他入库-成本(精度number0Required其他入库-成本(精度:2位小数点)
6.41other_in_count其他入库-数量number—Required其他入库-数量
6.42other_out_cost其他出库-成本(精度number0Required其他出库-成本(精度:2位小数点)
6.43other_out_count其他出库-数量number—Required其他出库-数量
6.44outsourcing_in_cost委外入库-成本(精度number0Required委外入库-成本(精度:2位小数点)
6.45outsourcing_in_count委外入库-数量number—Required委外入库-数量
6.46outsourcing_out_cost委外出库-成本(精度number0Required委外出库-成本(精度:2位小数点)
6.47outsourcing_out_count委外出库-数量number—Required委外出库-数量
6.48processing_in_cost加工入库-成本(精度number0Required加工入库-成本(精度:2位小数点)
6.49processing_in_count加工入库-数量number—Required加工入库-数量
6.50processing_out_cost加工出库-成本(精度number0Required加工出库-成本(精度:2位小数点)
6.51processing_out_count加工出库-数量number—Required加工出库-数量
6.52purchase_in_cost采购入库-成本(精度number0Required采购入库-成本(精度:2位小数点)
6.53purchase_in_count采购入库-数量number—Required采购入库-数量
6.54purchase_return_cost退货出库-成本(精度number0Required退货出库-成本(精度:2位小数点)
6.55purchase_return_count退货出库-数量number—Required退货出库-数量
6.56remove_in_cost移除入库-成本(精度number0Required移除入库-成本(精度:2位小数点)
6.57remove_in_count移除入库-数量number—Required移除入库-数量
6.58return_goods_in_cost退货入库-成本(精度number0Required退货入库-成本(精度:2位小数点)
6.59return_goods_in_count退货入库-数量number—Required退货入库-数量
6.60rotation_day_cost周转天数-成本(精度number0Required周转天数-成本(精度:2位小数点)
6.61rotation_day_count周转天数-数量(精度number0Required周转天数-数量(精度:2位小数点)
6.62split_in_cost拆分入库-成本(精度number0Required拆分入库-成本(精度:2位小数点)
6.63split_in_count拆分入库-数量number—Required拆分入库-数量
6.64split_out_cost拆分出库-成本(精度number0Required拆分出库-成本(精度:2位小数点)
6.65split_out_count拆分出库-数量number—Required拆分出库-数量
6.66wfs_out_costWFS出库-成本(精度number0RequiredWFS出库-成本(精度:2位小数点)
6.67wfs_out_countWFS出库-数量number—RequiredWFS出库-数量
6.68gifts_in_cost赠品入库-成本(精度number0Required赠品入库-成本(精度:2位小数点)
6.69gifts_in_count赠品入库-数量number0Required赠品入库-数量
6.70rotation_rate_count周转率-数量(精度number0Required周转率-数量(精度:4位小数点)
6.71rotation_rate_cost周转率-成本(精度number0Required周转率-成本(精度:4位小数点)
6.72sales_ratio_count存销比-数量(精度number0Required存销比-数量(精度:4位小数点)
6.73sales_ratio_cost存销比-成本(精度number0Required存销比-成本(精度:4位小数点)
6.74child_list子项array<any>&nbsp;Required子项,与外层列表字段一致-库存状态为全部时会有数据

The 库存报表 - 本地仓 - 新报表 - 明细 API (/inventory/center/openapi/storageReport/local/detail/page) 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.