轻易云
注册体验

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

所属平台
领星ERP
类型
WebAPI
作用
QUERY
接口版本
1.0
适配器
\Adapter\LingXing\LXQueryAdapter
授权方式
OTHER
描述
统计 · POST · 请求参数 5 个(必填 5) · 响应参数 100 个 · 限流令牌桶容量 10
更新日期
2026-11-21

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

POST/cost/center/openApi/fba/detail/query
加工厂
{
  "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}"
}

接口请求参数

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

接口响应参数

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

领星ERP的接口:库存报表 - FBA - 新版 - 明细(/cost/center/openApi/fba/detail/query),由轻易云数据集成平台 API 资产管理模块整理收纳,并随领星ERP版本更新同步更新。

需要对接这个接口?

轻易云已预置该接口的适配能力,联系我们即可开始配置数据集成。