/erp/sc/routing/inventoryLog/WareHouseReport/getOverSeaSummaryList{
"operation": {
"method": "POST",
"path": "/erp/sc/routing/inventoryLog/WareHouseReport/getOverSeaSummaryList"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": {
"start_date": "2022-01-01",
"end_date": "2024-08-05",
"sys_wid": "259,111"
},
"responseExample": "{\n \"code\": 0,\n \"message\": \"success\",\n \"error_details\": [],\n \"request_id\": \"557581a380f4447b959d4adf777dfa09\",\n \"response_time\": \"2022-12-21 18:44:54\"\n \"data\": [{\n \"product_type_count\": 0,\n \"api_product_type_count\": 0,\n \"ware_house_name\": \"仓库11\",\n \"date_locale\": \"2022-10-15\",\n \"purchase_in_count\": \"0.00\",\n \"allocation_in_count\": \"0.00\",\n \"other_in_count\": \"0.00\",\n \"adjustment_count\": \"0.00\",\n \"fba_out_count\": \"0.00\",\n \"fbm_out_count\": \"0.00\",\n \"allocation_out_count\": \"0.00\",\n \"purchase_return_count\": \"0.00\",\n \"other_out_count\": \"0.00\",\n \"cost_change_count\": \"0.00\",\n \"sales_count\": 0,\n \"api_day_early_count\": 0,\n \"api_day_end_count\": 0,\n \"sales_rate\": \"0.0000\",\n \"different_count\": \"-116562.00\",\n \"inventory_surplus_in\": \"0.00\",\n \"wfs_out_count\": \"0.00\",\n \"return_goods_in_count\": \"0.00\",\n \"pickout_in_count\": \"0.00\",\n \"ware_house_type\": \"第三方\",\n \"day_early_count\": \"116562.00\",\n \"day_end_count\": \"116562.00\",\n \"sys_wid\": 11,\n \"day_early_cost\": \"13890096.25\",\n \"purchase_in_cost\": \"0.00\",\n \"allocation_in_cost\": \"0.00\",\n \"other_in_cost\": \"0.00\",\n \"inventory_surplus_in_cost\": \"0.00\",\n \"return_goods_in_cost\": \"0.00\",\n \"pickout_in_cost\": \"0.00\",\n \"adjustment_cost\": \"0.00\",\n \"fba_out_cost\": \"0.00\",\n \"fbm_out_cost\": \"0.00\",\n \"other_out_cost\": \"0.00\",\n \"allocation_out_cost\": \"0.00\",\n \"purchase_return_cost\": \"0.00\",\n \"inventory_deficit_out_cost\": \"0.00\",\n \"cost_change_cost\": \"0.00\",\n \"wfs_out_cost\": \"0.00\",\n \"day_end_cost\": \"13890096.25\",\n \"rotation_rate_cost\": \"0.0000\",\n \"rotation_day_cost\": \"0.00\",\n \"stocking_in_transit_cost\": \"10737.09\",\n \"nventory_surplus_in_count\": \"0.00\",\n \"inventory_deficit_out_count\": \"0.00\",\n \"rotation_rate_count\": \"0.0000\",\n \"rotation_day_count\": \"0.00\",\n \"stocking_in_transit_counst\": \"1335.00\",\n \"product_count\": 0\n }],\n \"total\": 1\n}"
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | sys_wid | 领星仓库id | integer | — | Optional | 领星仓库id,多个用英文逗号分隔 |
| 2 | start_date | 开始时间 | string | — | Required | 开始时间 |
| 3 | end_date | 结束时间 | string | — | Required | 结束时间 |
| 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 | ware_house_type | 仓库类型 | string | 海外仓 | Required | 仓库类型 |
| 6.4 | day_early_count | 期初库存(数量) | number | 2450424 | Required | 期初库存(数量) |
| 6.5 | day_early_cost | 期初库存(成本) | number | 723024419.45 | Required | 期初库存(成本) |
| 6.6 | api_day_early_count | 第三方期初库存(数量)第三方只有数量 | number | — | Required | 第三方期初库存(数量)第三方只有数量 |
| 6.7 | api_day_end_count | 第三方期末库存(数量)第三方只有数量 | number | — | Required | 第三方期末库存(数量)第三方只有数量 |
| 6.8 | purchase_in_count | 采购入库(数量) | number | 30 | Required | 采购入库(数量) |
| 6.9 | purchase_in_cost | 采购入库(成本) | number | 22.5 | Required | 采购入库(成本) |
| 6.10 | allocation_in_count | 调拨入库(数量) | number | — | Required | 调拨入库(数量) |
| 6.11 | allocation_in_cost | 调拨入库(成本) | number | 0 | Required | 调拨入库(成本) |
| 6.12 | return_goods_in_count | 退货入库(数量) | number | — | Required | 退货入库(数量) |
| 6.13 | return_goods_in_cost | 退货入库(成本) | number | 0 | Required | 退货入库(成本) |
| 6.14 | other_in_count | 其他入库(数量) | number | 1000 | Required | 其他入库(数量) |
| 6.15 | other_in_cost | 其他入库(成本) | number | 0 | Required | 其他入库(成本) |
| 6.16 | inventory_surplus_in_count | 盘盈入库(数量) | number | — | Required | 盘盈入库(数量) |
| 6.17 | inventory_surplus_in_cost | 盘盈入库(成本) | number | 0 | Required | 盘盈入库(成本) |
| 6.18 | adjustment_count | 库存调整(数量) | number | — | Required | 库存调整(数量) |
| 6.19 | adjustment_cost | 库存调整(成本) | number | 0 | Required | 库存调整(成本) |
| 6.20 | fba_out_count | FBA出库(数量) | number | — | Required | FBA出库(数量) |
| 6.21 | fba_out_cost | FBA出库(成本) | number | 0 | Required | FBA出库(成本) |
| 6.22 | fbm_out_count | FBM出库(数量) | number | — | Required | FBM出库(数量) |
| 6.23 | fbm_out_cost | FBM出库(成本) | number | 0 | Required | FBM出库(成本) |
| 6.24 | allocation_out_count | 调拨出库(数量) | number | — | Required | 调拨出库(数量) |
| 6.25 | allocation_out_cost | 调拨出库(成本) | number | 0 | Required | 调拨出库(成本) |
| 6.26 | purchase_return_count | 采购退货(数量) | number | — | Required | 采购退货(数量) |
| 6.27 | purchase_return_cost | 采购退货(成本) | number | 0 | Required | 采购退货(成本) |
| 6.28 | other_out_count | 其他出库(数量) | number | — | Required | 其他出库(数量) |
| 6.29 | other_out_cost | 其他出库(成本) | number | 0 | Required | 其他出库(成本) |
| 6.30 | inventory_deficit_out_count | 盘亏出库(数量) | number | — | Required | 盘亏出库(数量) |
| 6.31 | inventory_deficit_out_cost | 盘亏出库(成本) | number | 0 | Required | 盘亏出库(成本) |
| 6.32 | wfs_out_count | WFS出库(数量) | number | — | Required | WFS出库(数量) |
| 6.33 | wfs_out_cost | WFS出库(成本) | number | 0 | Required | WFS出库(成本) |
| 6.34 | allocation_in_transit_count | 期末在途(数量) | number | 1 | Required | 期末在途(数量) |
| 6.35 | allocation_in_transit_cost | 期末在途(成本) | number | 13 | Required | 期末在途(成本) |
| 6.36 | day_end_count | 期末库存(数量) | number | 2451454 | Required | 期末库存(数量) |
| 6.37 | day_end_cost | 期末库存(成本) | number | 723024441.95 | Required | 期末库存(成本) |
| 6.38 | rotation_rate_count | 库存周转率(数量) | number | — | Required | 库存周转率(数量) |
| 6.39 | rotation_rate_cost | 库存周转率(成本) | number | 0 | Required | 库存周转率(成本) |
| 6.40 | rotation_day_count | 库存周转天数(数量) | number | — | Required | 库存周转天数(数量) |
| 6.41 | rotation_day_cost | 库存周转天数(成本) | number | — | Required | 库存周转天数(成本) |
| 6.42 | stocking_in_transit_count | 期末在途(数量) | number | — | Required | 期末在途(数量) |
| 6.43 | stocking_in_transit_cost | 期末在途(成本) | number | 0 | Required | 期末在途(成本) |
| 6.44 | sales_ratio_count | 存销比(数量) | number | — | Required | 存销比(数量) |
| 6.45 | sales_ratio_cost | 存销比(成本) | number | — | Required | 存销比(成本) |
| 6.46 | cost_change_cost | 成本补录(成本) | number | 0 | Required | 成本补录(成本) |
| 6.47 | product_count | 商品种类 | number | — | Required | 商品种类 |
| 6.48 | sales_rate | 动销率 | number | — | Required | 动销率 |
| 7 | total | 记录行数 | integer | 510 | Required | 记录行数 |
The 库存报表 - 海外仓 - 历史报表 - 汇总 API (/erp/sc/routing/inventoryLog/WareHouseReport/getOverSeaSummaryList) 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.