Qeasy Cloud
Get Started

领星ERP 库存报表 - 海外仓 - 历史报表 - 明细 API

Platform
领星ERP
Type
WebAPI
Effect
QUERY
API Version
1.0
Adapter
\Adapter\LingXing\LXQueryAdapter
Auth Mode
OTHER
Description
统计 · POST · 请求参数 5 个(必填 4) · 响应参数 64 个 · 限流令牌桶容量 1
Updated At
2026-11-21

库存报表 - 海外仓 - 历史报表 - 明细

POST/erp/sc/routing/inventoryLog/WareHouseReport/getOverSeaDetailList
Factory
{
  "operation": {
    "method": "POST",
    "path": "/erp/sc/routing/inventoryLog/WareHouseReport/getOverSeaDetailList"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 1,
    "text": ""
  },
  "requestExample": {
    "offset": 0,
    "length": 15,
    "start_date": "2022-01-01",
    "end_date": "2024-08-05",
    "sys_wid": "9"
  },
  "responseExample": "{\n    \"code\": 0,\n    \"message\": \"success\",    \n    \"error_details\": [],\n    \"request_id\": \"557581a380f4447b959d4adf777dfa09\",\n    \"response_time\": \"2022-12-21 18:44:54\"\n    \"request_id\": \"A42097F7-3400-BD9F-2A11-FED53ADD955A\",\n    \"data\": [{\n        \"id\": 4387598,\n        \"product_id\": 8,\n        \"ware_house_name\": \"西邮智仓 美国洛杉矶\",\n        \"date_locale\": \"2022-10-15\",\n        \"attribute\": 1,\n        \"purchase_in_count\": \"0\",\n        \"allocation_in_count\": \"0\",\n        \"return_goods_in_count\": \"0\",\n        \"pickout_in_count\": \"0\",\n        \"other_in_count\": \"0\",\n        \"adjustment_count\": \"0\",\n        \"fba_out_count\": \"0\",\n        \"fbm_out_count\": \"0\",\n        \"allocation_out_count\": \"0\",\n        \"purchase_return_count\": \"0\",\n        \"other_out_count\": \"0\",\n        \"cost_change_count\": \"0\",\n        \"fnsku\": \"\",\n        \"api_sku\": \"\",\n        \"sku\": \"123713811-11\",\n        \"product_name\": \"[演示数据]USB 壁式充电器 2.1A/5V 双端口 立方体电源适配器充电器插头充电块替换件\",\n        \"is_combo\": 0,\n        \"is_aux\": 0,\n        \"api_day_early_count\": 0,\n        \"api_day_end_count\": 0,\n        \"uk\": \"39-8-0--1\",\n        \"seller_id\": \"0\",\n        \"inventory_surplus_in\": \"0\",\n        \"wfs_out_count\": \"0\",\n        \"bid\": 1,\n        \"cid\": 3,\n        \"different_count\": -100,\n        \"global_tags\": \"\",\n        \"seller_name\": \"\",\n        \"brand\": \"\",\n        \"category\": \"缺失的品牌\\\\缺失的品牌\",\n        \"category1\": \"缺失的品牌\",\n        \"category2\": \"缺失的品牌\",\n        \"category3\": \"\",\n        \"attribute_text\": \"可售\",\n        \"day_early_count\": 100,\n        \"day_end_count\": 100,\n        \"product_type\": \"普通商品\",\n        \"sys_wid\": 39,\n        \"day_early_cost\": 0,\n        \"purchase_in_cost\": 0,\n        \"allocation_in_cost\": 0,\n        \"other_in_cost\": 0,\n        \"inventory_surplus_in_cost\": 0,\n        \"return_goods_in_cost\": 0,\n        \"pickout_in_cost\": 0,\n        \"adjustment_cost\": 0,\n        \"fba_out_cost\": 0,\n        \"fbm_out_cost\": 0,\n        \"other_out_cost\": 0,\n        \"allocation_out_cost\": 0,\n        \"purchase_return_cost\": 0,\n        \"inventory_deficit_out_cost\": 0,\n        \"cost_change_cost\": 0,\n        \"wfs_out_cost\": 0,\n        \"day_end_cost\": 0,\n        \"rotation_rate_cost\": 0,\n        \"rotation_day_cost\": 0,\n        \"stocking_in_transit_cost\": 0,\n        \"nventory_surplus_in_count\": \"0\",\n        \"inventory_deficit_out_count\": \"0\",\n        \"rotation_rate_count\": \"0.0000\",\n        \"rotation_day_count\": \"0.00\",\n        \"stocking_in_transit_counst\": 0,\n        \"product_count\": 0\n    }],\n    \"total\": 1\n}"
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1sys_wid系统仓库idinteger—Optional系统仓库id,多个用英文逗号分隔
2start_date开始时间string—Required开始时间,格式:Y-m-d
3end_date结束时间string—Required结束时间,格式:Y-m-d
4offset分页偏移量integer—Required分页偏移量,默认0
5length每页条数integer—Required每页条数,默认15

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer0Required状态码,0 成功
2message消息提示stringsuccessRequired消息提示
3error_details错误信息array<any>—Required错误信息
4request_id请求链路idstring8D680B8B-3C6F-3E16-F055-73DC70EAD977Required请求链路id
5response_time响应时间string2020-05-18 11:23:47Required响应时间
6data返回数据array<object>—Required返回数据
6.1skuskustringSKU-1RequiredSKU
6.2api_sku第三方SKUstringASVSDSA-1Required第三方SKU
6.3product_name品名string手机Required品名
6.4fnskufnskustringSDSADSV123RequiredFNSKU
6.5seller_name店铺string店铺1Required店铺
6.6sys_wid仓库idinteger23Required仓库id
6.7ware_house_name仓库名称string仓库1Required仓库名称
6.8category1一级分类string分类1Required一级分类
6.9category2二级分类string分类2Required二级分类
6.10category3三级分类string分类3Required三级分类
6.11brand品牌string某果Required品牌
6.12attribute_text库存属性string可售Required库存属性
6.13product_type产品类型string辅料Required产品类型
6.14day_early_count期初库存(数量)number2450424Required期初库存(数量)
6.15day_early_cost期初库存(成本)number723024419.45Required期初库存(成本)
6.16api_day_early_count第三方期初库存(数量)第三方只有数量number—Required第三方期初库存(数量)第三方只有数量
6.17api_day_end_count第三方期末库存(数量)第三方只有数量number—Required第三方期末库存(数量)第三方只有数量
6.18purchase_in_count采购入库(数量)number30Required采购入库(数量)
6.19purchase_in_cost采购入库(成本)number22.5Required采购入库(成本)
6.20allocation_in_count调拨入库(数量)number—Required调拨入库(数量)
6.21allocation_in_cost调拨入库(成本)number0Required调拨入库(成本)
6.22return_goods_in_count退货入库(数量)number—Required退货入库(数量)
6.23return_goods_in_cost退货入库(成本)number0Required退货入库(成本)
6.24other_in_count其他入库(数量)number1000Required其他入库(数量)
6.25other_in_cost其他入库(成本)number0Required其他入库(成本)
6.26inventory_surplus_in_count盘盈入库(数量)number—Required盘盈入库(数量)
6.27inventory_surplus_in_cost盘盈入库(成本)number0Required盘盈入库(成本)
6.28adjustment_count库存调整(数量)number—Required库存调整(数量)
6.29adjustment_cost库存调整(成本)number0Required库存调整(成本)
6.30fba_out_countFBA出库(数量)number—RequiredFBA出库(数量)
6.31fba_out_costFBA出库(成本)number0RequiredFBA出库(成本)
6.32fbm_out_countFBM出库(数量)number—RequiredFBM出库(数量)
6.33fbm_out_costFBM出库(成本)number0RequiredFBM出库(成本)
6.34allocation_out_count调拨出库(数量)number—Required调拨出库(数量)
6.35allocation_out_cost调拨出库(成本)number0Required调拨出库(成本)
6.36purchase_return_count采购退货(数量)number—Required采购退货(数量)
6.37purchase_return_cost采购退货(成本)number0Required采购退货(成本)
6.38other_out_count其他出库(数量)number—Required其他出库(数量)
6.39other_out_cost其他出库(成本)number0Required其他出库(成本)
6.40inventory_deficit_out_count盘亏出库(数量)number—Required盘亏出库(数量)
6.41inventory_deficit_out_cost盘亏出库(成本)number0Required盘亏出库(成本)
6.42wfs_out_countWFS出库(数量)number—RequiredWFS出库(数量)
6.43wfs_out_costWFS出库(成本)number0RequiredWFS出库(成本)
6.44allocation_in_transit_count期末在途(数量)number1Required期末在途(数量)
6.45allocation_in_transit_cost期末在途(成本)number13Required期末在途(成本)
6.46day_end_count期末库存(数量)number2451454Required期末库存(数量)
6.47day_end_cost期末库存(成本)number723024441.95Required期末库存(成本)
6.48stocking_in_transit_count期末在途(数量)number—Required期末在途(数量)
6.49stocking_in_transit_cost期末在途(成本)number0Required期末在途(成本)
6.50rotation_rate_count库存周转率(数量)number0Required库存周转率(数量)
6.51rotation_rate_cost库存周转率(成本)number0Required库存周转率(成本)
6.52rotation_day_count库存周转天数(数量)number—Required库存周转天数(数量)
6.53rotation_day_cost库存周转天数(成本)number—Required库存周转天数(成本)
6.54sales_ratio_count存销比(数量)number—Required存销比(数量)
6.55sales_ratio_cost存销比(成本)number—Required存销比(成本)
6.56cost_change_cost成本补录(成本)number0Required成本补录(成本)
6.57sales_rate动销率number—Required动销率
7total记录行数integer510Required记录行数

The 库存报表 - 海外仓 - 历史报表 - 明细 API (/erp/sc/routing/inventoryLog/WareHouseReport/getOverSeaDetailList) 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.

Need to integrate this API?

Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.