/cost/center/api/cost/stream{
"operation": {
"method": "POST",
"path": "/cost/center/api/cost/stream"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 10,
"text": ""
},
"requestExample": {
"wh_names": [
"8P-US-2024美国仓"
],
"shop_names": [
"8P-US-2024"
],
"skus": [
"LX-0035",
"00000000001",
"SKU9988"
],
"mskus": [
"HOLDER001",
"Pink_Head_Rope_1"
],
"disposition_types": [
1,
2,
3
],
"business_types": [
1
],
"query_type": "01",
"start_date": "2023-06-01",
"end_date": "2023-06-30",
"business_numbers": [
"FBA176M2LL9C",
"FCInboundRoutingService-FTW1-GYR1-81d2e262-7a9b-459b-8878-2708f6f3e789"
],
"origin_accounts": [
"SP230413004(无源单取最近签收成本),业务编号:FBA16V31K78D,流水编号:20220903J0001X"
],
"offset": 0,
"length": 200
},
"responseExample": {
"code": 0,
"data": {
"current": 0,
"records": [
{
"balance_logistics_amount": "1.11",
"balance_logistics_unit_price": "40.2469",
"balance_other_amount": "1.11",
"balance_other_unit_price": "40.2469",
"balance_purchase_amount": "1.11",
"balance_purchase_unit_price": "40.2469",
"balance_quantity": 297,
"business_number": "pock-Executor-BHX1-LCY2-1647210652366-627a54b1-37a9-4fbd-9e46-ffb58a3be20c",
"business_type": "1",
"business_type_desc": "期初库存-FBA上月结存",
"change_logistics_amount": "1.11",
"change_logistics_unit_price": "40.2469",
"change_other_amount": "1.11",
"change_other_unit_price": "40.2469",
"change_purchase_amount": "1.11",
"change_purchase_unit_price": "40.2469",
"change_quantity": 297,
"cost_source": "上月结存",
"data_version": "1672053502119",
"disposition_type": "可用",
"msku": "1160U1152-A",
"origin_account": "FBA15FN6XK4L",
"reason": "原因",
"sales_platform": "销售平台A",
"settlement_date": "结算日期",
"shop_name": "JHL Official-02",
"sku": "sku003",
"source_data_time": "2022-12-26 19:19:28",
"streamDate": "2022-06-01",
"unique_key": "null",
"wh_name": "JHL Official-02"
}
],
"size": 5,
"total": 1
},
"msg": "操作成功",
"success": true,
"traceId": "320aba4f-6af1-4cac-aa0c-6b27bc77bae1.1673003238583"
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | wh_names | 仓库名 | array<any> | — | Optional | 仓库名 |
| 2 | shop_names | 店铺名 | array<any> | — | Optional | 店铺名 |
| 3 | skus | skus | array<any> | — | Optional | sku |
| 4 | mskus | mskus | array<any> | — | Optional | msku |
| 5 | disposition_types | 库存属性 | array<any> | — | Optional | 库存属性: 1 可用在途 2 可用 3 次品 |
| 6 | business_types | 出入库类型 | array<any> | — | Required | 出入库类型: 1 期初库存-FBA上月结存 10 调拨入库-FBA补货入库 11 调拨入库-FBA途损补回 12 调拨入库-FBA超签入库 13 调拨入库-FBA超签入库(close后) 14 调拨入库-FBA补货入库(无发货单) 20 调拨入库-FBA调仓入库 35 调拨入库-FBA发货在途入库 25 盘点入库-FBA盘点入库 30 FBA退货-FBA无源单销售退货 31 FBA退货-FBA有源单销售退货 200 销售出库-FBA补发货销售 201 销售出库-FBA多渠道销售订单 202 销售出库-FBA亚马逊销售订单 205 其他出库-FBA补货出库 220 盘点出库-FBA盘点出库 15 调拨出库-FBA调仓出库 215 调拨出库-FBA移除 225 调拨出库-FBA发货在途出库 226 调拨出库-FBA发货途损 227 调拨出库-后补发货单在途出库 5 调整单- FBA对账差异入库调整 210 调整单-FBA对账差异出库调整 400 调整单-尾差调整 420 调整单-负库存数量调整 405 调整单-期初成本录入 |
| 7 | query_type | 日期查询类型 | string | — | Required | 日期查询类型: 01 库存动作日期【对应成本计价详情页面单据日期,即在FBA仓库内发生各项库存动作的日期】 02 结算日期【仅销售、退货场景会存在结算日期,其他库存动作结算日期为空】 |
| 8 | start_date | 起始日期 | string | — | Required | 起始日期,Y-m-d,不允许跨月 |
| 9 | end_date | 结束日期 | string | — | Required | 结束日期,Y-m-d,不允许跨月 |
| 10 | business_numbers | 业务编号 | array<any> | — | Optional | 业务编号 |
| 11 | origin_accounts | 源头单据号 | array<any> | — | Optional | 源头单据号 |
| 12 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量,默认0 |
| 13 | length | 分页长度 | integer | — | Optional | 分页长度,默认200条 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | — | Required | 状态码,0 成功 |
| 2 | msg | 响应信息 | string | — | Required | 响应信息 |
| 3 | success | 操作是否成功 | boolean | — | Required | 操作是否成功 |
| 4 | traceId | 请求链路Id | string | — | Required | 请求链路Id |
| 5 | data | 汇总数据 | object | — | Required | 汇总数据 |
| 5.1 | total | 总记录条数 | number | — | Required | 总记录条数 |
| 5.2 | size | 每个数据页大小 | number | — | Required | 每个数据页大小 |
| 5.3 | current | 当前所在数据页 | number | — | Required | 当前所在数据页 |
| 5.4 | records | 分页数据列表 | array<object> | — | Required | 分页数据列表 |
| 5.4.1 | stream_date | 库存动作日期 | string | 2022-12-01 | Required | 库存动作日期 |
| 5.4.2 | settlement_date | 结算日期 | string | 2022-12-01 | Optional | 结算日期 |
| 5.4.3 | source_data_time | 数据源更新时间 | string | 2022-12-28 00:13:21 | Optional | 数据源更新时间 |
| 5.4.4 | unique_key | 主键 | string | 主键 | Optional | 主键 |
| 5.4.5 | data_version | 计算版本号 | string | 1672156800661 | Required | 计算版本号 |
| 5.4.6 | business_number | 业务编号 | string | FBA15F9VZ512 | Optional | 业务编号 |
| 5.4.7 | origin_account | 源头单据号 | string | SP220210001 | Optional | 源头单据号 |
| 5.4.8 | sku | sku | string | 测试sku001 | Required | sku |
| 5.4.9 | msku | msku | string | 1160U1713 | Required | msku |
| 5.4.10 | wh_name | 仓库名称 | string | xxxxxxx | Required | 仓库名称 |
| 5.4.11 | shop_name | 店铺名称 | string | xxxxxxx | Optional | 店铺名称 |
| 5.4.12 | disposition_type | 库存属性 | string | 可用在途 | Required | 库存属性 |
| 5.4.13 | business_type | 出入库类型编码 | string | 1 | Required | 出入库类型编码 |
| 5.4.14 | business_type_desc | 出入库类型名称 | string | 期初库存-FBA上月结存 | Required | 出入库类型名称 |
| 5.4.15 | cost_source | 成本取值来源 | string | 上月结存 | Required | 成本取值来源 |
| 5.4.16 | change_quantity | 变动数量 | number | 0 | Required | 变动数量 |
| 5.4.17 | change_purchase_unit_price | 变动采购单价 | string | 0 | Required | 变动采购单价 |
| 5.4.18 | change_purchase_amount | 变动采购成本 | string | 0 | Required | 变动采购成本 |
| 5.4.19 | change_logistics_unit_price | 变动头程单价 | string | 0 | Required | 变动头程单价 |
| 5.4.20 | change_logistics_amount | 变动头程成本 | string | 0 | Required | 变动头程成本 |
| 5.4.21 | change_other_unit_price | 变动其他单价 | string | 0 | Required | 变动其他单价 |
| 5.4.22 | change_other_amount | 变动其他成本 | string | 0 | Required | 变动其他成本 |
| 5.4.23 | balance_quantity | 结存数量 | number | 70 | Required | 结存数量 |
| 5.4.24 | balance_purchase_unit_price | 结存采购成本单价 | string | 5.5815 | Required | 结存采购成本单价 |
| 5.4.25 | balance_purchase_amount | 结存采购成本 | string | 390.71 | Required | 结存采购成本 |
| 5.4.26 | balance_logistics_unit_price | 结存头程成本单价 | string | 20.0000 | Required | 结存头程成本单价 |
| 5.4.27 | balance_logistics_amount | 结存头程成本 | string | 1400.00 | Required | 结存头程成本 |
| 5.4.28 | balance_other_unit_price | 结存其他成本单价 | string | 2.4712 | Required | 结存其他成本单价 |
| 5.4.29 | balance_other_amount | 结存其他成本 | string | 172.98 | Required | 结存其他成本 |
| 5.4.30 | sales_platform | 销售平台 | string | — | Optional | 销售平台 |
| 5.4.31 | reason | 盘点原因 | string | | Optional | 盘点原因 |
The 查询FBA成本计价流水 API (/cost/center/api/cost/stream) 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.