/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
}
]
}
]
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | offset | 分页页码 | integer | — | Required | 分页页码,默认1 |
| 2 | length | 分页长度 | integer | — | Required | 分页长度,默认15,不超过100 |
| 3 | start_date | 开始时间 | string | — | Required | 开始时间,格式:Y-m-d |
| 4 | end_date | 结束时间 | string | — | Required | 结束时间,格式:Y-m-d |
| 5 | sys_wid | 系统仓库id | string | — | Optional | 系统仓库id,多个用英文逗号分隔 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0 成功 |
| 2 | message | 消息 | string | — | Required | 消息 |
| 3 | request_id | 请求链路id | string | c39932cfb78143f48235d2ccbc87cb80 | Required | 请求链路id |
| 4 | response_time | 响应时间 | string | 2022-12-21 18:43:02 | Required | 响应时间 |
| 5 | total | 总数 | integer | 1 | Required | 总数 |
| 6 | data | 响应数据 | array<object> | — | Required | 响应数据 |
| 6.1 | sys_wid | 系统仓库ID | integer | 1 | Required | 系统仓库ID |
| 6.2 | ware_house_name | 仓库名称 | string | 仓库1 | Required | 仓库名称 |
| 6.3 | seller_name | 店铺名称 | string | 店铺2 | Required | 店铺名称 |
| 6.4 | product_name | 商品名称 | string | [演示数据]Sony ZX系列有线头戴式耳机 黑色 MDR-ZX110 | Required | 商品名称 |
| 6.5 | product_type | 产品类型 | string | 普通产品 | Required | 产品类型:普通产品 组合产品 辅料 捆绑产品 |
| 6.6 | sku | sku | string | SKU37E3BFF | Required | SKU |
| 6.7 | fnsku | fnsku | string | FND1D7401 | Required | FNSKU |
| 6.8 | spu | spu | string | — | Required | SPU |
| 6.9 | spu_name | 款名 | string | — | Required | 款名 |
| 6.10 | brand | 品牌名称 | string | 品牌1 | Required | 品牌名称 |
| 6.11 | category1 | 一级类目-名称 | string | 分类3 | Required | 一级类目-名称 |
| 6.12 | category2 | 二级类目-名称 | string | — | Required | 二级类目-名称 |
| 6.13 | category3 | 三级类目-名称 | string | — | Required | 三级类目-名称 |
| 6.14 | attribute_text | 库存属性 | string | 全部 | Required | 库存属性: 全部可售待检不可售 |
| 6.15 | global_tags | 产品标签列表 | array<any> | — | Required | 产品标签列表 |
| 6.16 | sku_attribute | 产品属性 | array<any> | — | Required | 产品属性 |
| 6.17 | allocation_in_cost | 调拨入库-成本(精度 | number | 0 | Required | 调拨入库-成本(精度:2位小数点) |
| 6.18 | allocation_in_count | 调拨入库-数量 | number | — | Required | 调拨入库-数量 |
| 6.19 | allocation_in_transit_cost | 期末在途-成本(精度 | number | 0 | Required | 期末在途-成本(精度:2位小数点) |
| 6.20 | allocation_in_transit_count | 期末在途-数量 | number | — | Required | 期末在途-数量 |
| 6.21 | allocation_out_cost | 调拨出库-成本(精度 | number | 0 | Required | 调拨出库-成本(精度:2位小数点) |
| 6.22 | allocation_out_count | 调拨出库-数量 | number | — | Required | 调拨出库-数量 |
| 6.23 | change_of_standard_in_cost | 换标入库-成本(精度 | number | 0 | Required | 换标入库-成本(精度:2位小数点) |
| 6.24 | change_of_standard_in_count | 换标入库-数量 | number | — | Required | 换标入库-数量 |
| 6.25 | change_of_standard_out_cost | 换标出库-成本(精度 | number | 0 | Required | 换标出库-成本(精度:2位小数点) |
| 6.26 | change_of_standard_out_count | 换标出库-数量 | number | — | Required | 换标出库-数量 |
| 6.27 | cost_adjustment | 成本调整(精度 | number | 0 | Required | 成本调整(精度:2位小数点) |
| 6.28 | day_early_cost | 期初库存-成本(精度 | number | 0 | Required | 期初库存-成本(精度:2位小数点) |
| 6.29 | day_early_count | 期初库存-数量 | number | — | Required | 期初库存-数量 |
| 6.30 | day_end_cost | 期末库存-成本(精度 | number | 0 | Required | 期末库存-成本(精度:2位小数点) |
| 6.31 | day_end_count | 期末库存-数量 | number | — | Required | 期末库存-数量 |
| 6.32 | fba_out_cost | fba出库-成本(精度 | number | 0 | Required | fba出库-成本(精度:2位小数点) |
| 6.33 | fba_out_count | fba出库-数量 | number | — | Required | fba出库-数量 |
| 6.34 | fbm_out_cost | fbm出库-成本(精度 | number | 0 | Required | fbm出库-成本(精度:2位小数点) |
| 6.35 | fbm_out_count | fbm出库-数量 | number | — | Required | fbm出库-数量 |
| 6.36 | inventory_deficit_out_cost | 盘亏出库-成本(精度 | number | 0 | Required | 盘亏出库-成本(精度:2位小数点) |
| 6.37 | inventory_deficit_out_count | 盘亏出库-数量 | number | — | Required | 盘亏出库-数量 |
| 6.38 | inventory_surplus_in_cost | 盘盈入库-成本(精度 | number | 0 | Required | 盘盈入库-成本(精度:2位小数点) |
| 6.39 | inventory_surplus_in_count | 盘盈入库-数量 | number | — | Required | 盘盈入库-数量 |
| 6.40 | other_in_cost | 其他入库-成本(精度 | number | 0 | Required | 其他入库-成本(精度:2位小数点) |
| 6.41 | other_in_count | 其他入库-数量 | number | — | Required | 其他入库-数量 |
| 6.42 | other_out_cost | 其他出库-成本(精度 | number | 0 | Required | 其他出库-成本(精度:2位小数点) |
| 6.43 | other_out_count | 其他出库-数量 | number | — | Required | 其他出库-数量 |
| 6.44 | outsourcing_in_cost | 委外入库-成本(精度 | number | 0 | Required | 委外入库-成本(精度:2位小数点) |
| 6.45 | outsourcing_in_count | 委外入库-数量 | number | — | Required | 委外入库-数量 |
| 6.46 | outsourcing_out_cost | 委外出库-成本(精度 | number | 0 | Required | 委外出库-成本(精度:2位小数点) |
| 6.47 | outsourcing_out_count | 委外出库-数量 | number | — | Required | 委外出库-数量 |
| 6.48 | processing_in_cost | 加工入库-成本(精度 | number | 0 | Required | 加工入库-成本(精度:2位小数点) |
| 6.49 | processing_in_count | 加工入库-数量 | number | — | Required | 加工入库-数量 |
| 6.50 | processing_out_cost | 加工出库-成本(精度 | number | 0 | Required | 加工出库-成本(精度:2位小数点) |
| 6.51 | processing_out_count | 加工出库-数量 | number | — | Required | 加工出库-数量 |
| 6.52 | purchase_in_cost | 采购入库-成本(精度 | number | 0 | Required | 采购入库-成本(精度:2位小数点) |
| 6.53 | purchase_in_count | 采购入库-数量 | number | — | Required | 采购入库-数量 |
| 6.54 | purchase_return_cost | 退货出库-成本(精度 | number | 0 | Required | 退货出库-成本(精度:2位小数点) |
| 6.55 | purchase_return_count | 退货出库-数量 | number | — | Required | 退货出库-数量 |
| 6.56 | remove_in_cost | 移除入库-成本(精度 | number | 0 | Required | 移除入库-成本(精度:2位小数点) |
| 6.57 | remove_in_count | 移除入库-数量 | number | — | Required | 移除入库-数量 |
| 6.58 | return_goods_in_cost | 退货入库-成本(精度 | number | 0 | Required | 退货入库-成本(精度:2位小数点) |
| 6.59 | return_goods_in_count | 退货入库-数量 | number | — | Required | 退货入库-数量 |
| 6.60 | rotation_day_cost | 周转天数-成本(精度 | number | 0 | Required | 周转天数-成本(精度:2位小数点) |
| 6.61 | rotation_day_count | 周转天数-数量(精度 | number | 0 | Required | 周转天数-数量(精度:2位小数点) |
| 6.62 | split_in_cost | 拆分入库-成本(精度 | number | 0 | Required | 拆分入库-成本(精度:2位小数点) |
| 6.63 | split_in_count | 拆分入库-数量 | number | — | Required | 拆分入库-数量 |
| 6.64 | split_out_cost | 拆分出库-成本(精度 | number | 0 | Required | 拆分出库-成本(精度:2位小数点) |
| 6.65 | split_out_count | 拆分出库-数量 | number | — | Required | 拆分出库-数量 |
| 6.66 | wfs_out_cost | WFS出库-成本(精度 | number | 0 | Required | WFS出库-成本(精度:2位小数点) |
| 6.67 | wfs_out_count | WFS出库-数量 | number | — | Required | WFS出库-数量 |
| 6.68 | gifts_in_cost | 赠品入库-成本(精度 | number | 0 | Required | 赠品入库-成本(精度:2位小数点) |
| 6.69 | gifts_in_count | 赠品入库-数量 | number | 0 | Required | 赠品入库-数量 |
| 6.70 | rotation_rate_count | 周转率-数量(精度 | number | 0 | Required | 周转率-数量(精度:4位小数点) |
| 6.71 | rotation_rate_cost | 周转率-成本(精度 | number | 0 | Required | 周转率-成本(精度:4位小数点) |
| 6.72 | sales_ratio_count | 存销比-数量(精度 | number | 0 | Required | 存销比-数量(精度:4位小数点) |
| 6.73 | sales_ratio_cost | 存销比-成本(精度 | number | 0 | Required | 存销比-成本(精度:4位小数点) |
| 6.74 | child_list | 子项 | array<any> | | 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.
Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.