Qeasy Cloud
Get Started

领星ERP 库存报表 - FBA - 新版 - 明细 API

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

库存报表 - FBA - 新版 - 明细

POST/cost/center/openApi/fba/detail/query
Factory
{
  "operation": {
    "method": "POST",
    "path": "/cost/center/openApi/fba/detail/query"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 10,
    "text": ""
  },
  "requestExample": {
    "offset": 0,
    "length": 15,
    "start_date": "2020-01",
    "end_date": "2024-08",
    "seller_id": [
      "AQ7DSXSNF6NDP",
      "AJGRSY3EK14NJ"
    ]
  },
  "responseExample": "{\n    \"code\": 0,\n    \"msg\": \"操作成功\",\n    \"traceId\": \"7248e68e-e304-46b7-8ee7-4094dd57b61c.1673358502644\",\n    \"data\": {\n        \"row_data\": [\n            {\n                \"sid\": 6,\n                \"mid\": 1,\n                \"wid\": 19,\n                \"ware_house_name\": \"_xinghai_direct-1美国仓\",\n                \"parent_asin\": \"_b07_n_l8_p_k_f2\",\n                \"msku\": \"7501_x_h1856\",\n                \"asin\": \"_b07_n_l8_p_k_f2\",\n                \"disposition\": \"all\",\n                \"seller_id\": \"_a1_r1_a_a_b_f0_f_m_f_l8\",\n                \"country_code\": \"_u_s\",\n                \"fnsku\": \"_x0023_d_b_l_e_h\",\n                \"product_id\": null,\n                \"local_sku\": \"\",\n                \"local_name\": \"\",\n                \"cid\": null,\n                \"product_category_name\": \"\",\n                \"bid\": null,\n                \"brand_name\": \"\",\n                \"valuation_method\": null,\n                \"shipments_count\": 0,\n                \"shipments_total_amount\": \"0.00\",\n                \"shipments_logistic_amount\": \"0.00\",\n                \"shipments_other_amount\": \"0.00\",\n                \"whse_transfers_count\": 0,\n                \"whse_transfers_total_amount\": \"0.00\",\n                \"whse_transfers_logistic_amount\": \"0.00\",\n                \"whse_transfers_other_amount\": \"0.00\",\n                \"disposed_count\": 0,\n                \"disposed_total_amount\": \"0.00\",\n                \"disposed_logistic_amount\": \"0.00\",\n                \"disposed_other_amount\": \"0.00\",\n                \"found_count\": 0,\n                \"found_total_amount\": \"0.00\",\n                \"found_logistic_amount\": \"0.00\",\n                \"found_other_amount\": \"0.00\",\n                \"lost_count\": 0,\n                \"lost_total_amount\": \"0.00\",\n                \"lost_logistic_amount\": \"0.00\",\n                \"lost_other_amount\": \"0.00\",\n                \"other_events_count\": 0,\n                \"other_events_total_amount\": \"0.00\",\n                \"other_events_logistic_amount\": \"0.00\",\n                \"other_events_other_amount\": \"0.00\",\n                \"receipts_count\": 0,\n                \"receipts_total_amount\": \"0.00\",\n                \"receipts_logistic_amount\": \"0.00\",\n                \"receipts_other_amount\": \"0.00\",\n                \"customer_returns_count\": 0,\n                \"customer_returns_total_amount\": \"0.00\",\n                \"customer_returns_logistic_amount\": \"0.00\",\n                \"customer_returns_other_amount\": \"0.00\",\n                \"vendor_returns_count\": -1,\n                \"vendor_returns_total_amount\": \"0.00\",\n                \"vendor_returns_logistic_amount\": \"0.00\",\n                \"vendor_returns_other_amount\": \"0.00\",\n                \"difference_count\": 0,\n                \"difference_total_amount\": \"0.00\",\n                \"difference_logistic_amount\": \"0.00\",\n                \"difference_other_amount\": \"0.00\",\n                \"start_count\": 1,\n                \"start_total_amount\": \"0.00\",\n                \"start_logistic_amount\": \"0.00\",\n                \"start_other_amount\": \"0.00\",\n                \"end_count\": 0,\n                \"end_total_amount\": \"0.00\",\n                \"end_logistic_amount\": \"0.00\",\n                \"end_other_amount\": \"0.00\",\n                \"damaged_count\": 0,\n                \"damaged_total_amount\": \"0.00\",\n                \"damaged_logistic_amount\": \"0.00\",\n                \"damaged_other_amount\": \"0.00\",\n                \"end_on_way_count\": 0,\n                \"end_on_way_total_amount\": \"0.00\",\n                \"end_on_way_logistic_amount\": \"0.00\",\n                \"end_on_way_other_amount\": \"0.00\",\n                \"parent_node\": true,                \n                \"inventory_turnover_rate\": \"0.00\",\n                \"inventory_turnover_days\": \"0.00\",\n                \"stock_to_use_rate\": \"0.00\",\n                \"adjustments_count\": 0,\n                \"adjustments_total_amount\": \"0.00\",\n                \"adjustments_logistic_amount\": \"0.00\",\n                \"adjustments_other_amount\": \"0.00\",\n                \"transferring_out_count\": 0,\n                \"transferring_out_total_amount\": \"0.00\",\n                \"transferring_out_logistic_amount\": \"0.00\",\n                \"transferring_out_other_amount\": \"0.00\",\n                \"child_data\": [\n                    {\n                        \"sid\": 6,\n                        \"mid\": 1,\n                        \"wid\": 19,\n                        \"ware_house_name\": \"_xinghai_direct-1美国仓\",\n                        \"parent_asin\": \"_b07_n_l8_p_k_f2\",\n                        \"msku\": \"7501_x_h1856\",\n                        \"asin\": \"_b07_n_l8_p_k_f2\",\n                        \"disposition\": \"unsellable\",\n                        \"seller_id\": \"_a1_r1_a_a_b_f0_f_m_f_l8\",\n                        \"country_code\": \"_u_s\",\n                        \"fnsku\": \"_x0023_d_b_l_e_h\",\n                        \"product_id\": null,\n                        \"local_sku\": \"\",\n                        \"local_name\": \"\",\n                        \"cid\": null,\n                        \"product_category_name\": \"\",\n                        \"bid\": null,\n                        \"brand_name\": \"\",\n                        \"valuation_method\": null,\n                        \"shipments_count\": 0,\n                        \"shipments_total_amount\": \"0.00\",\n                        \"shipments_logistic_amount\": \"0.00\",\n                        \"shipments_other_amount\": \"0.00\",\n                        \"whse_transfers_count\": 0,\n                        \"whse_transfers_total_amount\": \"0.00\",\n                        \"whse_transfers_logistic_amount\": \"0.00\",\n                        \"whse_transfers_other_amount\": \"0.00\",\n                        \"disposed_count\": 0,\n                        \"disposed_total_amount\": \"0.00\",\n                        \"disposed_logistic_amount\": \"0.00\",\n                        \"disposed_other_amount\": \"0.00\",\n                        \"found_count\": 0,\n                        \"found_total_amount\": \"0.00\",\n                        \"found_logistic_amount\": \"0.00\",\n                        \"found_other_amount\": \"0.00\",\n                        \"lost_count\": 0,\n                        \"lost_total_amount\": \"0.00\",\n                        \"lost_logistic_amount\": \"0.00\",\n                        \"lost_other_amount\": \"0.00\",\n                        \"other_events_count\": 0,\n                        \"other_events_total_amount\": \"0.00\",\n                        \"other_events_logistic_amount\": \"0.00\",\n                        \"other_events_other_amount\": \"0.00\",\n                        \"receipts_count\": 0,\n                        \"receipts_total_amount\": \"0.00\",\n                        \"receipts_logistic_amount\": \"0.00\",\n                        \"receipts_other_amount\": \"0.00\",\n                        \"customer_returns_count\": 0,\n                        \"customer_returns_total_amount\": \"0.00\",\n                        \"customer_returns_logistic_amount\": \"0.00\",\n                        \"customer_returns_other_amount\": \"0.00\",\n                        \"vendor_returns_count\": -1,\n                        \"vendor_returns_total_amount\": \"0.00\",\n                        \"vendor_returns_logistic_amount\": \"0.00\",\n                        \"vendor_returns_other_amount\": \"0.00\",\n                        \"difference_count\": 0,\n                        \"difference_total_amount\": \"0.00\",\n                        \"difference_logistic_amount\": \"0.00\",\n                        \"difference_other_amount\": \"0.00\",\n                        \"start_count\": 1,\n                        \"start_total_amount\": \"0.00\",\n                        \"start_logistic_amount\": \"0.00\",\n                        \"start_other_amount\": \"0.00\",\n                        \"end_count\": 0,\n                        \"end_total_amount\": \"0.00\",\n                        \"end_logistic_amount\": \"0.00\",\n                        \"end_other_amount\": \"0.00\",\n                        \"damaged_count\": 0,\n                        \"damaged_total_amount\": \"0.00\",\n                        \"damaged_logistic_amount\": \"0.00\",\n                        \"damaged_other_amount\": \"0.00\",\n                        \"end_on_way_count\": 0,\n                        \"end_on_way_total_amount\": \"0.00\",\n                        \"end_on_way_logistic_amount\": \"0.00\",\n                        \"end_on_way_other_amount\": \"0.00\",\n                        \"parent_node\": false,\n                        \"child_data\": [],\n                        \"inventory_turnover_rate\": \"0.00\",\n                        \"inventory_turnover_days\": \"0.00\",\n                        \"stock_to_use_rate\": \"0.00\",\n                        \"adjustments_count\": 0,\n                        \"adjustments_total_amount\": \"0.00\",\n                        \"adjustments_logistic_amount\": \"0.00\",\n                        \"adjustments_other_amount\": \"0.00\",\n                        \"transferring_out_count\": 0,\n                        \"transferring_out_total_amount\": \"0.00\",\n                        \"transferring_out_logistic_amount\": \"0.00\",\n                        \"transferring_out_other_amount\": \"0.00\",\n                    }\n                ]\n            }\n        ],\n        \"start_date\": \"2022-08-01\",\n        \"end_date\": \"2022-08-31\",\n        \"day_interval\": 31,\n        \"total\": 1,\n        \"size\": 1,\n        \"current\": 1,\n        \"amount_type\": 0\n    }\n}"
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1offset分页偏移量integer—Required分页偏移量,默认0
2length分页长度integer—Required分页长度,默认15,最大2100
3start_date开始日期string—Required开始日期,格式:Y-m
4end_date结束日期string—Required结束日期,格式:Y-m
5seller_id亚马逊店铺idarray<any>—Required亚马逊店铺id ,对应查询亚马逊店铺列表接口对应字段【seller_id】

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer0Required状态码,0 成功
2msg提示消息string操作成功Required提示消息
3traceId请求链路idstring7248e68e-e304-46b7-8ee7-4094dd57b61c.1673358502644Required请求链路id
4data响应数据object—Required响应数据
4.1total总数integer22Required总数
4.2start_date统计开始月份string2022-08-01Required统计开始月份,格式:Y-m-d
4.3end_date统计结束月份string2022-08-31Required统计结束月份,格式:Y-m-d
4.4day_interval时间区间相隔天数integer31Required时间区间相隔天数
4.5amount_type计价类型integer—Required计价类型: 0 成本计价 1 固定值计价
4.6row_data明细数据array<object>—Required明细数据
4.6.1seller_id亚马逊店铺idstringxxxxxxxxxxxxxxxxRequired亚马逊店铺id
4.6.2sid店铺idinteger1Required店铺id
4.6.3wid系统仓库idinteger2Required系统仓库id
4.6.4ware_house_name仓库名称stringXinghaiDirect-1美国仓Required仓库名称
4.6.5start_count期初库存-数量integer—Required期初库存-数量
4.6.6start_other_amount期初库存-商品成本number0Required期初库存-商品成本 (精度:2位小数)
4.6.7start_logistic_amount期初库存-物流成本"string0.00Required期初库存-物流成本" (精度:2位小数)
4.6.8shipments_count订单发货-数量integer—Required订单发货-数量
4.6.9shipments_other_amount订单发货-商品成本number0Required订单发货-商品成本 (精度:2位小数)
4.6.10shipments_logistic_amount订单发货-物流成本number0Required订单发货-物流成本 (精度:2位小数)
4.6.11whse_transfers_count库房转运-数量integer—Required库房转运-数量
4.6.12whse_transfers_other_amount库房转运-商品成本number0Required库房转运-商品成本 (精度:2位小数)
4.6.13whse_transfers_logistic_amount库房转运-物流成本number0Required库房转运-物流成本 (精度:2位小数)
4.6.14disposed_count弃置-数量integer—Required弃置-数量
4.6.15disposed_other_amount弃置-商品成本number0Required弃置-商品成本 (精度:2位小数)
4.6.16disposed_logistic_amount弃置-物流成本number0Required弃置-物流成本 (精度:2位小数)
4.6.17found_count已找到-数量integer—Required已找到-数量
4.6.18found_other_amount已找到-商品成本number0Required已找到-商品成本 (精度:2位小数)
4.6.19found_logistic_amount已找到-物流成本number0Required已找到-物流成本 (精度:2位小数)
4.6.20lost_count丢失-数量integer—Required丢失-数量
4.6.21lost_other_amount丢失-商品成本number0Required丢失-商品成本 (精度:2位小数)
4.6.22lost_logistic_amount丢失-物流成本number0Required丢失-物流成本 (精度:2位小数)
4.6.23other_events_count其他-数量integer—Required其他-数量
4.6.24other_events_other_amount其他-商品成本number0Required其他-商品成本 (精度:2位小数)
4.6.25other_events_logistic_amount其他-物流成本number0Required其他-物流成本 (精度:2位小数)
4.6.26receipts_count货件补货-数量integer—Required货件补货-数量
4.6.27receipts_other_amount货件补货-商品成本number0Required货件补货-商品成本 (精度:2位小数)
4.6.28receipts_logistic_amount货件补货-物流成本number0Required货件补货-物流成本 (精度:2位小数)
4.6.29customer_returns_count买家退货-数量integer—Required买家退货-数量
4.6.30customer_returns_other_amount买家退货-商品成本number0Required买家退货-商品成本 (精度:2位小数)
4.6.31customer_returns_logistic_amount买家退货-物流成本number0Required买家退货-物流成本 (精度:2位小数)
4.6.32vendor_returns_count库存移除-数量integer—Required库存移除-数量
4.6.33vendor_returns_other_amount库存移除-商品成本number0Required库存移除-商品成本 (精度:2位小数)
4.6.34vendor_returns_logistic_amount库存移除-物流成本number0Required库存移除-物流成本 (精度:2位小数)
4.6.35difference_count库存差异-数量integer—Required库存差异-数量
4.6.36difference_other_amount库存差异-商品成本number0Required库存差异-商品成本 (精度:2位小数)
4.6.37difference_logistic_amount库存差异-物流成本number0Required库存差异-物流成本 (精度:2位小数)
4.6.38end_count期末库存-数量integer—Required期末库存-数量
4.6.39end_other_amount期末库存-商品成本number0Required期末库存-商品成本 (精度:2位小数)
4.6.40end_logistic_amount期末库存-物流成本number0Required期末库存-物流成本 (精度:2位小数)
4.6.41damaged_count残损-数量integer—Required残损-数量
4.6.42damaged_other_amount残损-商品成本number0Required残损-商品成本 (精度:2位小数)
4.6.43damaged_logistic_amount残损-物流成本number0Required残损-物流成本 (精度:2位小数)
4.6.44partition_index分区索引integer10202201Required分区索引
4.6.45end_on_way_count期末在途-数量integer—Required期末在途-数量
4.6.46end_on_way_other_amount期末在途-商品成本number0Required期末在途-商品成本 (精度:2位小数)
4.6.47end_on_way_logistic_amount期末在途-物流成本number0Required期末在途-物流成本 (精度:2位小数)
4.6.48category_count商品种类integer—Required商品种类
4.6.49parent_node是否父节点booleantrueRequired是否父节点
4.6.50inventory_turnover_rate库存周转率number0Required库存周转率 (精度:2位小数)
4.6.51inventory_turnover_days库存周转天数number0Required库存周转天数 (精度:2位小数)
4.6.52start_total_amount期初库存-总成本number0Required期初库存-总成本 (精度:2位小数)
4.6.53shipments_total_amount订单发货-总成本number0Required订单发货-总成本 (精度:2位小数)
4.6.54whse_transfers_total_amount库房转运-总成本number0Required库房转运-总成本 (精度:2位小数)
4.6.55disposed_total_amount弃置-总成本number0Required弃置-总成本 (精度:2位小数)
4.6.56found_total_amount已找到-总成本number0Required已找到-总成本 (精度:2位小数)
4.6.57lost_total_amount丢失-总成本number0Required丢失-总成本 (精度:2位小数)
4.6.58other_events_total_amount其他-总成本number0Required其他-总成本 (精度:2位小数)
4.6.59receipts_total_amount货件补货-总成本number0Required货件补货-总成本 (精度:2位小数)
4.6.60customer_returns_total_amount订单退货-总成本number0Required订单退货-总成本 (精度:2位小数)
4.6.61vendor_returns_total_amount库存移除-总成本number0Required库存移除-总成本 (精度:2位小数)
4.6.62difference_total_amount库存差异-总成本number0Required库存差异-总成本 (精度:2位小数)
4.6.63end_total_amount期末库存-总成本number0Required期末库存-总成本 (精度:2位小数)
4.6.64damaged_total_amount已残损-总成本number0Required已残损-总成本 (精度:2位小数)
4.6.65end_on_way_total_amount期末在途-总成本number0Required期末在途-总成本 (精度:2位小数)
4.6.66stock_to_use_rate存销比number0Required存销比 (精度:2位小数)
4.6.67adjustments_count成本调整-数量integer—Required成本调整-数量
4.6.68adjustments_total_amount成本调整-总成本number0Required成本调整-总成本 (精度:2位小数)
4.6.69adjustments_logistic_amount成本调整-物流成本number0Required成本调整-物流成本 (精度:2位小数)
4.6.70adjustments_other_amount成本调整-商品成本number0Required成本调整-商品成本 (精度:2位小数)
4.6.71transferring_out_count移仓在途-数量integer1Required移仓在途-数量
4.6.72transferring_out_total_amount移仓在途-总成本number0Required移仓在途-总成本 (精度:2位小数)
4.6.73transferring_out_logistic_amount移仓在途-物流成本number0Required移仓在途-物流成本 (精度:2位小数)
4.6.74transferring_out_other_amount移仓在途-商品成本number0Required移仓在途-商品成本 (精度:2位小数)
4.6.75mid站点idinteger1Required站点id
4.6.76parent_asin父AsinstringB07NL8PKF2Required父Asin
4.6.77mskumskustring7501_x_h1856Requiredmsku
4.6.78asinasinstringB07NL8PKF2Requiredasin
4.6.79disposition库存属性stringallRequired库存属性: sellable 可售 unsellable 不可售 all 全部
4.6.80country_code国家编码stringUSRequired国家编码
4.6.81fnskufnskustringX0023DBLEHRequiredfnsku
4.6.82product_id本地产品idinteger2Required本地产品id
4.6.83local_sku本地产品skustring7501XH1856Required本地产品sku
4.6.84local_name本地产品名称string本地产品名称12Required本地产品名称
4.6.85cid商品分类idinteger12Required商品分类id
4.6.86product_category_name产品分类名string产品分类名1Required产品分类名
4.6.87bid品牌idinteger2Required品牌id
4.6.88brand_name品牌名称string品牌名称2Required品牌名称
4.6.89valuation_method计价方法integer1Required计价方法: 1 先进先出 2 移动加权 3 月末加权
4.6.90child_data返回字段与上级row_data一致array<any>&nbsp;Required返回字段与上级row_data一致

The 库存报表 - FBA - 新版 - 明细 API (/cost/center/openApi/fba/detail/query) 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.