/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}"
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | offset | 分页偏移量 | integer | — | Required | 分页偏移量,默认0 |
| 2 | length | 分页长度 | integer | — | Required | 分页长度,默认15,最大2100 |
| 3 | start_date | 开始日期 | string | — | Required | 开始日期,格式:Y-m |
| 4 | end_date | 结束日期 | string | — | Required | 结束日期,格式:Y-m |
| 5 | seller_id | 亚马逊店铺id | array<any> | — | Required | 亚马逊店铺id ,对应查询亚马逊店铺列表接口对应字段【seller_id】 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0 成功 |
| 2 | msg | 提示消息 | string | 操作成功 | Required | 提示消息 |
| 3 | traceId | 请求链路id | string | 7248e68e-e304-46b7-8ee7-4094dd57b61c.1673358502644 | Required | 请求链路id |
| 4 | data | 响应数据 | object | — | Required | 响应数据 |
| 4.1 | total | 总数 | integer | 22 | Required | 总数 |
| 4.2 | start_date | 统计开始月份 | string | 2022-08-01 | Required | 统计开始月份,格式:Y-m-d |
| 4.3 | end_date | 统计结束月份 | string | 2022-08-31 | Required | 统计结束月份,格式:Y-m-d |
| 4.4 | day_interval | 时间区间相隔天数 | integer | 31 | Required | 时间区间相隔天数 |
| 4.5 | amount_type | 计价类型 | integer | — | Required | 计价类型: 0 成本计价 1 固定值计价 |
| 4.6 | row_data | 明细数据 | array<object> | — | Required | 明细数据 |
| 4.6.1 | seller_id | 亚马逊店铺id | string | xxxxxxxxxxxxxxxx | Required | 亚马逊店铺id |
| 4.6.2 | sid | 店铺id | integer | 1 | Required | 店铺id |
| 4.6.3 | wid | 系统仓库id | integer | 2 | Required | 系统仓库id |
| 4.6.4 | ware_house_name | 仓库名称 | string | XinghaiDirect-1美国仓 | Required | 仓库名称 |
| 4.6.5 | start_count | 期初库存-数量 | integer | — | Required | 期初库存-数量 |
| 4.6.6 | start_other_amount | 期初库存-商品成本 | number | 0 | Required | 期初库存-商品成本 (精度:2位小数) |
| 4.6.7 | start_logistic_amount | 期初库存-物流成本" | string | 0.00 | Required | 期初库存-物流成本" (精度:2位小数) |
| 4.6.8 | shipments_count | 订单发货-数量 | integer | — | Required | 订单发货-数量 |
| 4.6.9 | shipments_other_amount | 订单发货-商品成本 | number | 0 | Required | 订单发货-商品成本 (精度:2位小数) |
| 4.6.10 | shipments_logistic_amount | 订单发货-物流成本 | number | 0 | Required | 订单发货-物流成本 (精度:2位小数) |
| 4.6.11 | whse_transfers_count | 库房转运-数量 | integer | — | Required | 库房转运-数量 |
| 4.6.12 | whse_transfers_other_amount | 库房转运-商品成本 | number | 0 | Required | 库房转运-商品成本 (精度:2位小数) |
| 4.6.13 | whse_transfers_logistic_amount | 库房转运-物流成本 | number | 0 | Required | 库房转运-物流成本 (精度:2位小数) |
| 4.6.14 | disposed_count | 弃置-数量 | integer | — | Required | 弃置-数量 |
| 4.6.15 | disposed_other_amount | 弃置-商品成本 | number | 0 | Required | 弃置-商品成本 (精度:2位小数) |
| 4.6.16 | disposed_logistic_amount | 弃置-物流成本 | number | 0 | Required | 弃置-物流成本 (精度:2位小数) |
| 4.6.17 | found_count | 已找到-数量 | integer | — | Required | 已找到-数量 |
| 4.6.18 | found_other_amount | 已找到-商品成本 | number | 0 | Required | 已找到-商品成本 (精度:2位小数) |
| 4.6.19 | found_logistic_amount | 已找到-物流成本 | number | 0 | Required | 已找到-物流成本 (精度:2位小数) |
| 4.6.20 | lost_count | 丢失-数量 | integer | — | Required | 丢失-数量 |
| 4.6.21 | lost_other_amount | 丢失-商品成本 | number | 0 | Required | 丢失-商品成本 (精度:2位小数) |
| 4.6.22 | lost_logistic_amount | 丢失-物流成本 | number | 0 | Required | 丢失-物流成本 (精度:2位小数) |
| 4.6.23 | other_events_count | 其他-数量 | integer | — | Required | 其他-数量 |
| 4.6.24 | other_events_other_amount | 其他-商品成本 | number | 0 | Required | 其他-商品成本 (精度:2位小数) |
| 4.6.25 | other_events_logistic_amount | 其他-物流成本 | number | 0 | Required | 其他-物流成本 (精度:2位小数) |
| 4.6.26 | receipts_count | 货件补货-数量 | integer | — | Required | 货件补货-数量 |
| 4.6.27 | receipts_other_amount | 货件补货-商品成本 | number | 0 | Required | 货件补货-商品成本 (精度:2位小数) |
| 4.6.28 | receipts_logistic_amount | 货件补货-物流成本 | number | 0 | Required | 货件补货-物流成本 (精度:2位小数) |
| 4.6.29 | customer_returns_count | 买家退货-数量 | integer | — | Required | 买家退货-数量 |
| 4.6.30 | customer_returns_other_amount | 买家退货-商品成本 | number | 0 | Required | 买家退货-商品成本 (精度:2位小数) |
| 4.6.31 | customer_returns_logistic_amount | 买家退货-物流成本 | number | 0 | Required | 买家退货-物流成本 (精度:2位小数) |
| 4.6.32 | vendor_returns_count | 库存移除-数量 | integer | — | Required | 库存移除-数量 |
| 4.6.33 | vendor_returns_other_amount | 库存移除-商品成本 | number | 0 | Required | 库存移除-商品成本 (精度:2位小数) |
| 4.6.34 | vendor_returns_logistic_amount | 库存移除-物流成本 | number | 0 | Required | 库存移除-物流成本 (精度:2位小数) |
| 4.6.35 | difference_count | 库存差异-数量 | integer | — | Required | 库存差异-数量 |
| 4.6.36 | difference_other_amount | 库存差异-商品成本 | number | 0 | Required | 库存差异-商品成本 (精度:2位小数) |
| 4.6.37 | difference_logistic_amount | 库存差异-物流成本 | number | 0 | Required | 库存差异-物流成本 (精度:2位小数) |
| 4.6.38 | end_count | 期末库存-数量 | integer | — | Required | 期末库存-数量 |
| 4.6.39 | end_other_amount | 期末库存-商品成本 | number | 0 | Required | 期末库存-商品成本 (精度:2位小数) |
| 4.6.40 | end_logistic_amount | 期末库存-物流成本 | number | 0 | Required | 期末库存-物流成本 (精度:2位小数) |
| 4.6.41 | damaged_count | 残损-数量 | integer | — | Required | 残损-数量 |
| 4.6.42 | damaged_other_amount | 残损-商品成本 | number | 0 | Required | 残损-商品成本 (精度:2位小数) |
| 4.6.43 | damaged_logistic_amount | 残损-物流成本 | number | 0 | Required | 残损-物流成本 (精度:2位小数) |
| 4.6.44 | partition_index | 分区索引 | integer | 10202201 | Required | 分区索引 |
| 4.6.45 | end_on_way_count | 期末在途-数量 | integer | — | Required | 期末在途-数量 |
| 4.6.46 | end_on_way_other_amount | 期末在途-商品成本 | number | 0 | Required | 期末在途-商品成本 (精度:2位小数) |
| 4.6.47 | end_on_way_logistic_amount | 期末在途-物流成本 | number | 0 | Required | 期末在途-物流成本 (精度:2位小数) |
| 4.6.48 | category_count | 商品种类 | integer | — | Required | 商品种类 |
| 4.6.49 | parent_node | 是否父节点 | boolean | true | Required | 是否父节点 |
| 4.6.50 | inventory_turnover_rate | 库存周转率 | number | 0 | Required | 库存周转率 (精度:2位小数) |
| 4.6.51 | inventory_turnover_days | 库存周转天数 | number | 0 | Required | 库存周转天数 (精度:2位小数) |
| 4.6.52 | start_total_amount | 期初库存-总成本 | number | 0 | Required | 期初库存-总成本 (精度:2位小数) |
| 4.6.53 | shipments_total_amount | 订单发货-总成本 | number | 0 | Required | 订单发货-总成本 (精度:2位小数) |
| 4.6.54 | whse_transfers_total_amount | 库房转运-总成本 | number | 0 | Required | 库房转运-总成本 (精度:2位小数) |
| 4.6.55 | disposed_total_amount | 弃置-总成本 | number | 0 | Required | 弃置-总成本 (精度:2位小数) |
| 4.6.56 | found_total_amount | 已找到-总成本 | number | 0 | Required | 已找到-总成本 (精度:2位小数) |
| 4.6.57 | lost_total_amount | 丢失-总成本 | number | 0 | Required | 丢失-总成本 (精度:2位小数) |
| 4.6.58 | other_events_total_amount | 其他-总成本 | number | 0 | Required | 其他-总成本 (精度:2位小数) |
| 4.6.59 | receipts_total_amount | 货件补货-总成本 | number | 0 | Required | 货件补货-总成本 (精度:2位小数) |
| 4.6.60 | customer_returns_total_amount | 订单退货-总成本 | number | 0 | Required | 订单退货-总成本 (精度:2位小数) |
| 4.6.61 | vendor_returns_total_amount | 库存移除-总成本 | number | 0 | Required | 库存移除-总成本 (精度:2位小数) |
| 4.6.62 | difference_total_amount | 库存差异-总成本 | number | 0 | Required | 库存差异-总成本 (精度:2位小数) |
| 4.6.63 | end_total_amount | 期末库存-总成本 | number | 0 | Required | 期末库存-总成本 (精度:2位小数) |
| 4.6.64 | damaged_total_amount | 已残损-总成本 | number | 0 | Required | 已残损-总成本 (精度:2位小数) |
| 4.6.65 | end_on_way_total_amount | 期末在途-总成本 | number | 0 | Required | 期末在途-总成本 (精度:2位小数) |
| 4.6.66 | stock_to_use_rate | 存销比 | number | 0 | Required | 存销比 (精度:2位小数) |
| 4.6.67 | adjustments_count | 成本调整-数量 | integer | — | Required | 成本调整-数量 |
| 4.6.68 | adjustments_total_amount | 成本调整-总成本 | number | 0 | Required | 成本调整-总成本 (精度:2位小数) |
| 4.6.69 | adjustments_logistic_amount | 成本调整-物流成本 | number | 0 | Required | 成本调整-物流成本 (精度:2位小数) |
| 4.6.70 | adjustments_other_amount | 成本调整-商品成本 | number | 0 | Required | 成本调整-商品成本 (精度:2位小数) |
| 4.6.71 | transferring_out_count | 移仓在途-数量 | integer | 1 | Required | 移仓在途-数量 |
| 4.6.72 | transferring_out_total_amount | 移仓在途-总成本 | number | 0 | Required | 移仓在途-总成本 (精度:2位小数) |
| 4.6.73 | transferring_out_logistic_amount | 移仓在途-物流成本 | number | 0 | Required | 移仓在途-物流成本 (精度:2位小数) |
| 4.6.74 | transferring_out_other_amount | 移仓在途-商品成本 | number | 0 | Required | 移仓在途-商品成本 (精度:2位小数) |
| 4.6.75 | mid | 站点id | integer | 1 | Required | 站点id |
| 4.6.76 | parent_asin | 父Asin | string | B07NL8PKF2 | Required | 父Asin |
| 4.6.77 | msku | msku | string | 7501_x_h1856 | Required | msku |
| 4.6.78 | asin | asin | string | B07NL8PKF2 | Required | asin |
| 4.6.79 | disposition | 库存属性 | string | all | Required | 库存属性: sellable 可售 unsellable 不可售 all 全部 |
| 4.6.80 | country_code | 国家编码 | string | US | Required | 国家编码 |
| 4.6.81 | fnsku | fnsku | string | X0023DBLEH | Required | fnsku |
| 4.6.82 | product_id | 本地产品id | integer | 2 | Required | 本地产品id |
| 4.6.83 | local_sku | 本地产品sku | string | 7501XH1856 | Required | 本地产品sku |
| 4.6.84 | local_name | 本地产品名称 | string | 本地产品名称12 | Required | 本地产品名称 |
| 4.6.85 | cid | 商品分类id | integer | 12 | Required | 商品分类id |
| 4.6.86 | product_category_name | 产品分类名 | string | 产品分类名1 | Required | 产品分类名 |
| 4.6.87 | bid | 品牌id | integer | 2 | Required | 品牌id |
| 4.6.88 | brand_name | 品牌名称 | string | 品牌名称2 | Required | 品牌名称 |
| 4.6.89 | valuation_method | 计价方法 | integer | 1 | Required | 计价方法: 1 先进先出 2 移动加权 3 月末加权 |
| 4.6.90 | child_data | 返回字段与上级row_data一致 | array<any> | | 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.
Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.