轻易云
注册体验

领星ERP库存报表 - 本地仓 - 新报表 - 明细接口

所属平台
领星ERP
类型
WebAPI
作用
QUERY
接口版本
1.0
适配器
\Adapter\LingXing\LXQueryAdapter
授权方式
OTHER
描述
统计 · POST · 请求参数 5 个(必填 4) · 响应参数 80 个 · 限流令牌桶容量 3
更新日期
2026-11-21

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

POST/inventory/center/openapi/storageReport/local/detail/page
加工厂
{
  "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
          }
        ]
      }
    ]
  }
}

接口请求参数

序号字段名称类型默认值必填描述
1offset分页页码integer—必填分页页码,默认1
2length分页长度integer—必填分页长度,默认15,不超过100
3start_date开始时间string—必填开始时间,格式:Y-m-d
4end_date结束时间string—必填结束时间,格式:Y-m-d
5sys_wid系统仓库idstring—可选系统仓库id,多个用英文逗号分隔

接口响应参数

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

领星ERP的接口:库存报表 - 本地仓 - 新报表 - 明细(/inventory/center/openapi/storageReport/local/detail/page),由轻易云数据集成平台 API 资产管理模块整理收纳,并随领星ERP版本更新同步更新。

需要对接这个接口?

轻易云已预置该接口的适配能力,联系我们即可开始配置数据集成。