/erp/sc/routing/inventoryLog/WareHouseReport/getLocalWareHouseSummaryList{
"operation": {
"method": "POST",
"path": "/erp/sc/routing/inventoryLog/WareHouseReport/getLocalWareHouseSummaryList"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": {
"start_date": "2022-01-01",
"end_date": "2022-08-05",
"sys_wid": "1,5,8"
},
"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 \"total\": 1,\n \"data\": [\n {\n \"sys_wid\": 3879,\n \"ware_house_name\": \"dabing-test\",\n \"day_early_count\": 504,\n \"day_early_cost\": \"11904.61\",\n \"purchase_in_count\": 0,\n \"purchase_in_cost\": \"0.00\",\n \"allocation_in_count\": 0,\n \"allocation_in_cost\": \"0.00\",\n \"return_goods_in_count\": 0,\n \"return_goods_in_cost\": \"0.00\",\n \"other_in_count\": 0,\n \"other_in_cost\": \"0.00\",\n \"inventory_surplus_in_count\": 0,\n \"inventory_surplus_in_cost\": \"0.00\",\n \"adjustment_count\": 0,\n \"adjustment_cost\": \"0.00\",\n \"fba_out_count\": 0,\n \"fba_out_cost\": \"0.00\",\n \"fbm_out_count\": 0,\n \"fbm_out_cost\": \"0.00\",\n \"allocation_out_count\": 0,\n \"allocation_out_cost\": \"0.00\",\n \"purchase_return_count\": 0,\n \"purchase_return_cost\": \"0.00\",\n \"other_out_count\": 0,\n \"other_out_cost\": \"0.00\",\n \"inventory_deficit_out_count\": 0,\n \"inventory_deficit_out_cost\": \"0.00\",\n \"wfs_out_count\": 0,\n \"wfs_out_cost\": \"0.00\",\n \"allocation_in_transit_count\": 0,\n \"allocation_in_transit_cost\": \"0.00\",\n \"day_end_count\": 504,\n \"day_end_cost\": \"11904.61\",\n \"rotation_rate_count\": \"0.0000\",\n \"rotation_rate_cost\": \"0.0000\",\n \"rotation_day_count\": 0,\n \"rotation_day_cost\": \"-\",\n \"sales_ratio_count\": 0,\n \"sales_ratio_cost\": 0,\n \"cost_change_cost\": \"0.00\",\n \"product_count\": 11,\n \"sales_rate\": 0\n }\n ]\n}"
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | sys_wid | 领星系统仓库id | integer | — | Optional | 领星系统仓库id,多个用英文逗号分隔 |
| 2 | start_date | 开始时间 | string | — | Required | 开始时间,格式:Y-m-d |
| 3 | end_date | 结束时间 | string | — | Required | 结束时间,格式:Y-m-d |
| 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 | day_early_count | 期初库存(数量) | number | 2450424 | Required | 期初库存(数量) |
| 6.4 | day_early_cost | 期初库存(成本) | string | 723024419.45 | Required | 期初库存(成本) |
| 6.5 | purchase_in_count | 采购入库(数量) | number | 30 | Required | 采购入库(数量) |
| 6.6 | purchase_in_cost | 采购入库(成本) | string | 22.50 | Required | 采购入库(成本) |
| 6.7 | allocation_in_count | 调拨入库(数量) | number | — | Required | 调拨入库(数量) |
| 6.8 | allocation_in_cost | 调拨入库(成本) | string | 0.00 | Required | 调拨入库(成本) |
| 6.9 | return_goods_in_count | 退货入库(数量) | number | — | Required | 退货入库(数量) |
| 6.10 | return_goods_in_cost | 退货入库(成本) | string | 0.00 | Required | 退货入库(成本) |
| 6.11 | other_in_count | 其他入库(数量) | number | 1000 | Required | 其他入库(数量) |
| 6.12 | other_in_cost | 其他入库(成本) | string | 0.00 | Required | 其他入库(成本) |
| 6.13 | inventory_surplus_in_count | 盘盈入库(数量) | number | — | Required | 盘盈入库(数量) |
| 6.14 | inventory_surplus_in_cost | 盘盈入库(成本) | string | 0.00 | Required | 盘盈入库(成本) |
| 6.15 | adjustment_count | 库存调整(数量) | number | — | Required | 库存调整(数量) |
| 6.16 | adjustment_cost | 库存调整(成本) | string | 0.00 | Required | 库存调整(成本) |
| 6.17 | fba_out_count | FBA出库(数量) | number | — | Required | FBA出库(数量) |
| 6.18 | fba_out_cost | FBA出库(成本) | string | 0.00 | Required | FBA出库(成本) |
| 6.19 | fbm_out_count | FBM出库(数量) | number | — | Required | FBM出库(数量) |
| 6.20 | fbm_out_cost | FBM出库(成本) | string | 0.00 | Required | FBM出库(成本) |
| 6.21 | allocation_out_count | 调拨出库(数量) | number | — | Required | 调拨出库(数量) |
| 6.22 | allocation_out_cost | 调拨出库(成本) | string | 0.00 | Required | 调拨出库(成本) |
| 6.23 | purchase_return_count | 采购退货(数量) | number | — | Required | 采购退货(数量) |
| 6.24 | purchase_return_cost | 采购退货(成本) | string | 0.00 | Required | 采购退货(成本) |
| 6.25 | other_out_count | 其他出库(数量) | number | — | Required | 其他出库(数量) |
| 6.26 | other_out_cost | 其他出库(成本) | string | 0.00 | Required | 其他出库(成本) |
| 6.27 | inventory_deficit_out_count | 盘亏出库(数量) | number | — | Required | 盘亏出库(数量) |
| 6.28 | inventory_deficit_out_cost | 盘亏出库(成本) | string | 0.00 | Required | 盘亏出库(成本) |
| 6.29 | wfs_out_count | WFS出库(数量) | number | — | Required | WFS出库(数量) |
| 6.30 | wfs_out_cost | WFS出库(成本) | string | 0.00 | Required | WFS出库(成本) |
| 6.31 | allocation_in_transit_count | 期末在途(数量) | number | 1 | Required | 期末在途(数量) |
| 6.32 | allocation_in_transit_cost | 期末在途(成本) | string | 13.00 | Required | 期末在途(成本) |
| 6.33 | day_end_count | 期末库存(数量) | number | 2451454 | Required | 期末库存(数量) |
| 6.34 | day_end_cost | 期末库存(成本) | string | 723024441.95 | Required | 期末库存(成本) |
| 6.35 | rotation_rate_count | 库存周转率(数量) | string | — | Required | 库存周转率(数量) |
| 6.36 | rotation_rate_cost | 库存周转率(成本) | string | 0.0000 | Required | 库存周转率(成本) |
| 6.37 | rotation_day_count | 库存周转天数(数量) | string | — | Required | 库存周转天数(数量) |
| 6.38 | rotation_day_cost | 库存周转天数(成本) | string | — | Required | 库存周转天数(成本) |
| 6.39 | sales_ratio_count | 存销比(数量) | string | — | Required | 存销比(数量) |
| 6.40 | sales_ratio_cost | 存销比(成本) | string | — | Required | 存销比(成本) |
| 6.41 | cost_change_cost | 成本补录(成本) | string | 0.00 | Required | 成本补录(成本) |
| 6.42 | product_count | 商品种类 | number | — | Required | 商品种类 |
| 6.43 | sales_rate | 动销率 | number | — | Required | 动销率 |
| 7 | total | 总数 | integer | 1 | Required | 总数 |
The 库存报表 - 本地仓 - 历史报表 - 汇总 API (/erp/sc/routing/inventoryLog/WareHouseReport/getLocalWareHouseSummaryList) 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.