/inventory/center/openapi/storageReport/local/aggregate/list{
"operation": {
"method": "POST",
"path": "/inventory/center/openapi/storageReport/local/aggregate/list"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 3,
"text": ""
},
"requestExample": {
"start_date": "2020-01-01",
"end_date": "2024-08-05",
"sys_wid": "1694,1688"
},
"responseExample": "{\n \"code\": 0,\n \"message\": \"success\",\n \"error_details\":[],\n \"request_id\": \"BDF6F403-1998-7E7F-62C2-369C15FEE14D\",\n \"response_time\": \"2022-12-21 18:44:54\"\n \"data\": [{\n \"other_in_count\": 0,\n \"purchase_in_count\": 0,\n \"allocation_in_count\": 0,\n \"outsourcing_in_count\": 0,\n \"inventory_surplus_in_count\": 0,\n \"change_of_standard_in_count\": 0,\n \"processing_in_count\": 0,\n \"split_in_count\": 0,\n \"return_goods_in_count\": 0,\n \"remove_in_count\": 0,\n \"outsourcing_out_count\": 0,\n \"inventory_deficit_out_count\": 0,\n \"change_of_standard_out_count\": 0,\n \"processing_out_count\": 0,\n \"split_out_count\": 0,\n \"fba_out_count\": 0,\n \"fbm_out_count\": 0,\n \"purchase_return_count\": 0,\n \"allocation_out_count\": 0,\n \"other_out_count\": 0,\n \"wfs_out_count\": 0,\n \"gifts_in_cost\": 0,\n \"gifts_in_count\": 0,\n \"day_early_count\": 119,\n \"day_end_count\": 119,\n \"allocation_in_transit_count\": 0,\n \"other_in_cost\": \"0.00\",\n \"purchase_in_cost\": \"0.00\",\n \"allocation_in_cost\": \"0.00\",\n \"outsourcing_in_cost\": \"0.00\",\n \"inventory_surplus_in_cost\": \"0.00\",\n \"change_of_standard_in_cost\": \"0.00\",\n \"processing_in_cost\": \"0.00\",\n \"split_in_cost\": \"0.00\",\n \"return_goods_in_cost\": \"0.00\",\n \"remove_in_cost\": \"0.00\",\n \"outsourcing_out_cost\": \"0.00\",\n \"inventory_deficit_out_cost\": \"0.00\",\n \"change_of_standard_out_cost\": \"0.00\",\n \"processing_out_cost\": \"0.00\",\n \"split_out_cost\": \"0.00\",\n \"fba_out_cost\": \"0.00\",\n \"fbm_out_cost\": \"0.00\",\n \"purchase_return_cost\": \"0.00\",\n \"allocation_out_cost\": \"0.00\",\n \"other_out_cost\": \"0.00\",\n \"wfs_out_cost\": \"0.00\",\n \"day_early_cost\": \"0.00\",\n \"day_end_cost\": \"0.00\",\n \"allocation_in_transit_cost\": \"0.00\",\n \"cost_adjustment\": \"0.00\",\n \"rotation_day_count\": \"0.00\",\n \"rotation_rate_count\": \"0.0000\",\n \"sales_ratio_count\": \"0.0000\",\n \"rotation_day_cost\": \"0.00\",\n \"rotation_rate_cost\": \"0.0000\",\n \"sales_ratio_cost\": \"0.0000\",\n \"sys_wid\": 4386,\n \"ware_house_name\": \"1213\",\n \"product_count\": 3,\n \"sales_rate\": \"0.0000\"\n }]\n}"
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | start_date | 开始时间 | string | — | Required | 开始时间,格式:Y-m-d |
| 2 | end_date | 结束时间 | string | — | Required | 结束时间,格式:Y-m-d |
| 3 | sys_wid | 系统仓库id | integer | — | Optional | 系统仓库id,多个用英文逗号分隔 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0 成功 |
| 2 | message | 消息提示 | string | success | Required | 消息提示 |
| 3 | error_details | 错误信息 | array<any> | — | Required | 错误信息 |
| 4 | request_id | 请求链路id | string | 8D680B8B-3C6F-3E16-F055-73DC70EAD977 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2020-05-18 11:23:47 | 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 | product_count | 商品数量 | number | 5935 | Required | 商品数量 |
| 6.4 | allocation_in_cost | 调拨入库-成本(精度 | number | 0 | Required | 调拨入库-成本(精度:2位小数点) |
| 6.5 | allocation_in_count | 调拨入库-数量 | number | — | Required | 调拨入库-数量 |
| 6.6 | allocation_in_transit_cost | 期末在途-成本(精度 | number | 0 | Required | 期末在途-成本(精度:2位小数点) |
| 6.7 | allocation_in_transit_count | 期末在途-数量 | number | — | Required | 期末在途-数量 |
| 6.8 | allocation_out_cost | 调拨出库-成本(精度 | number | 0 | Required | 调拨出库-成本(精度:2位小数点) |
| 6.9 | allocation_out_count | 调拨出库-数量 | number | — | Required | 调拨出库-数量 |
| 6.10 | change_of_standard_in_cost | 换标入库-成本(精度 | number | 0 | Required | 换标入库-成本(精度:2位小数点) |
| 6.11 | change_of_standard_in_count | 换标入库-数量 | number | — | Required | 换标入库-数量 |
| 6.12 | change_of_standard_out_cost | 换标出库-成本(精度 | number | 0 | Required | 换标出库-成本(精度:2位小数点) |
| 6.13 | change_of_standard_out_count | 换标出库-数量 | number | — | Required | 换标出库-数量 |
| 6.14 | cost_adjustment | 成本调整(精度 | number | 0 | Required | 成本调整(精度:2位小数点) |
| 6.15 | day_early_cost | 期初库存-成本(精度 | number | 0 | Required | 期初库存-成本(精度:2位小数点) |
| 6.16 | day_early_count | 期初库存-数量 | number | — | Required | 期初库存-数量 |
| 6.17 | day_end_cost | 期末库存-成本(精度 | number | 0 | Required | 期末库存-成本(精度:2位小数点) |
| 6.18 | day_end_count | 期末库存-数量 | number | — | Required | 期末库存-数量 |
| 6.19 | fba_out_cost | fba出库-成本(精度 | number | 0 | Required | fba出库-成本(精度:2位小数点) |
| 6.20 | fba_out_count | fba出库-数量 | number | — | Required | fba出库-数量 |
| 6.21 | fbm_out_cost | fbm出库-成本(精度 | number | 0 | Required | fbm出库-成本(精度:2位小数点) |
| 6.22 | fbm_out_count | fbm出库-数量 | number | — | Required | fbm出库-数量 |
| 6.23 | inventory_deficit_out_cost | 盘亏出库-成本(精度 | number | 0 | Required | 盘亏出库-成本(精度:2位小数点) |
| 6.24 | inventory_deficit_out_count | 盘亏出库-数量 | number | — | Required | 盘亏出库-数量 |
| 6.25 | inventory_surplus_in_cost | 盘盈入库-成本(精度 | number | 0 | Required | 盘盈入库-成本(精度:2位小数点) |
| 6.26 | inventory_surplus_in_count | 盘盈入库-数量 | number | — | Required | 盘盈入库-数量 |
| 6.27 | other_in_cost | 其他入库-成本(精度 | number | 0 | Required | 其他入库-成本(精度:2位小数点) |
| 6.28 | other_in_count | 其他入库-数量 | number | — | Required | 其他入库-数量 |
| 6.29 | other_out_cost | 其他出库-成本(精度 | number | 0 | Required | 其他出库-成本(精度:2位小数点) |
| 6.30 | other_out_count | 其他出库-数量 | number | — | Required | 其他出库-数量 |
| 6.31 | outsourcing_in_cost | 委外入库-成本(精度 | number | 0 | Required | 委外入库-成本(精度:2位小数点) |
| 6.32 | outsourcing_in_count | 委外入库-数量 | number | — | Required | 委外入库-数量 |
| 6.33 | outsourcing_out_cost | 委外出库-成本(精度 | number | 0 | Required | 委外出库-成本(精度:2位小数点) |
| 6.34 | outsourcing_out_count | 委外出库-数量 | number | — | Required | 委外出库-数量 |
| 6.35 | processing_in_cost | 加工入库-成本(精度 | number | 0 | Required | 加工入库-成本(精度:2位小数点) |
| 6.36 | processing_in_count | 加工入库-数量 | number | — | Required | 加工入库-数量 |
| 6.37 | processing_out_cost | 加工出库-成本(精度 | number | 0 | Required | 加工出库-成本(精度:2位小数点) |
| 6.38 | processing_out_count | 加工出库-数量 | number | — | Required | 加工出库-数量 |
| 6.39 | purchase_in_cost | 采购入库-成本(精度 | number | 0 | Required | 采购入库-成本(精度:2位小数点) |
| 6.40 | purchase_in_count | 采购入库-数量 | number | — | Required | 采购入库-数量 |
| 6.41 | purchase_return_cost | 退货出库-成本(精度 | number | 0 | Required | 退货出库-成本(精度:2位小数点) |
| 6.42 | purchase_return_count | 退货出库-数量 | number | — | Required | 退货出库-数量 |
| 6.43 | remove_in_cost | 移除入库-成本(精度 | number | 0 | Required | 移除入库-成本(精度:2位小数点) |
| 6.44 | remove_in_count | 移除入库-数量 | number | — | Required | 移除入库-数量 |
| 6.45 | return_goods_in_cost | 退货入库-成本(精度 | number | 0 | Required | 退货入库-成本(精度:2位小数点) |
| 6.46 | return_goods_in_count | 退货入库-数量 | number | — | Required | 退货入库-数量 |
| 6.47 | split_in_cost | 拆分入库-成本(精度 | number | 0 | Required | 拆分入库-成本(精度:2位小数点) |
| 6.48 | split_in_count | 拆分入库-数量 | number | — | Required | 拆分入库-数量 |
| 6.49 | split_out_cost | 拆分出库-成本(精度 | number | 0 | Required | 拆分出库-成本(精度:2位小数点) |
| 6.50 | split_out_count | 拆分出库-数量 | number | — | Required | 拆分出库-数量 |
| 6.51 | wfs_out_cost | WFS出库-成本(精度 | number | 0 | Required | WFS出库-成本(精度:2位小数点) |
| 6.52 | wfs_out_count | WFS出库-数量 | number | — | Required | WFS出库-数量 |
| 6.53 | gifts_in_cost | 赠品入库-成本(精度 | string | 0.00 | Required | 赠品入库-成本(精度:2位小数点) |
| 6.54 | gifts_in_count | 赠品入库-数量 | number | 0 | Required | 赠品入库-数量 |
| 6.55 | rotation_day_cost | 周转天数-成本(精度 | number | 0 | Required | 周转天数-成本(精度:2位小数点) |
| 6.56 | rotation_day_count | 周转天数-数量(精度 | number | 0 | Required | 周转天数-数量(精度:2位小数点) |
| 6.57 | rotation_rate_cost | 周转率-成本(精度 | number | 0 | Required | 周转率-成本(精度:4位小数点) |
| 6.58 | rotation_rate_count | 周转率-数量(精度 | number | 0 | Required | 周转率-数量(精度:4位小数点) |
| 6.59 | sales_ratio_cost | 存销比-成本(精度 | number | 0 | Required | 存销比-成本(精度:4位小数点) |
| 6.60 | sales_ratio_count | 存销比-数量(精度 | number | 0 | Required | 存销比-数量(精度:4位小数点) |
| 6.61 | sales_rate | 动销率(精度 | number | 0 | Required | 动销率(精度:4位小数点) |
The 库存报表 - 本地仓 - 新报表 - 汇总 API (/inventory/center/openapi/storageReport/local/aggregate/list) 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.