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