/basicOpen/finance/profitReport/order/transcation/list{
"operation": {
"method": "POST",
"path": "/basicOpen/finance/profitReport/order/transcation/list"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": {
"offset": 0,
"length": 20,
"mids": [
1,
2
],
"sids": [
124,
123
],
"startDate": "2022-12-31",
"endDate": "2023-03-01",
"currencyCode": "USD",
"searchField": "order_id",
"searchValue": [
"xxxx"
],
"sortField": "postedDatetimeLocale",
"sortType": "desc",
"settlementStatus": [
"Closed"
],
"fundTransferStatus": [
"Succeeded"
],
"searchDateField": "posted_date_locale",
"accountType": [
"Standard"
],
"eventSource": [
"Service Fee"
],
"fulfillment": [
"FBA"
],
"principalUids": [
106160
],
"productDeveloperUids": [
1
],
"gmtModifiedStartDate": "2024-09-01 12:00:00",
"gmtModifiedEndDate": "2024-09-01 14:00:00",
"orderStatus": "Deferred",
"transactionStatus": [
"Disbursed",
"PreSettlement"
]
},
"responseExample": {
"code": 0,
"message": "success",
"error_details": [],
"request_id": "f898c15c933b40639f2250f96d9755be.1741745537314",
"response_time": "2025-03-12 10:12:18",
"data": {
"records": [
{
"id": "113221103598719651224501253105676405764357882259729528092821266977197534979600",
"bizId": "113221103598719651224501253105676405764357882259729528092821266977197534979600",
"bizIdRowIndex": 0,
"sid": "136",
"transactionId": "22dd24b86a464cf2a7541252dc462587.1760926323389",
"storeName": "韧啸-US",
"country": "美国",
"countryCode": "US",
"postedDatetimeLocale": "2024-11-13 01:24:24",
"settlementStatus": "Closed",
"orderId": "",
"fulfillment": "",
"orderDatetimeLocale": "",
"paymentDatetimeLocale": "",
"shipmentDatetimeLocale": "",
"fundTransferDatetimeLocale": "2024-11-18 23:29:21",
"fundTransferStatus": "Unknown",
"gmtModified": "2025-01-31 09:50:43",
"accountType": "Standard",
"eventSource": "FBA Inventory Fee",
"settlementId": "21164053811",
"fid": "QA0DQPFT4NVX",
"smallImageUrl": null,
"msku": "",
"fnsku": "",
"asin": "",
"parentAsin": "",
"localName": null,
"localSku": null,
"description": "FBA Inbound Transportation Fee",
"quantity": 0,
"principalRealname": null,
"productDeveloperRealname": null,
"currencyCode": "USD",
"currencyIcon": "$",
"productSales": 0,
"productSalesTax": 0,
"shippingCredits": 0,
"shippingCreditsTax": 0,
"giftwrapCredits": 0,
"giftwrapCreditsTax": 0,
"amazonPointFee": 0,
"promotionalRebates": 0,
"promotionalRebatesTax": 0,
"salesTaxCollected": 0,
"lowValueGoods": 0,
"marketplaceWithheldTax": 0,
"tcsCgst": 0,
"tcsSgst": 0,
"tcsIgst": 0,
"sellingFees": 0,
"fbaFees": 0,
"otherTransactionFees": 0,
"other": -7.64,
"hiddenTax": 0,
"settlementTotal": -7.64,
"purchaseCostsTotal": 0,
"logisticsCostsTotal": 0,
"otherCostsTotal": 0,
"customOrderFeeTotal": 0,
"settlementGrossProfit": -7.64,
"settlementGrossProfitRate": 0,
"promotionId": "",
"transactionStatus": "已发放",
"transactionStatusCode": "Disbursed",
"shipPromotionDiscount": null,
"itemPromotionDiscount": null,
"odsEventType": "ServiceFeeEventList",
"rowIndex": 0
}
],
"total": 1
},
"total": 0
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量,默认0 |
| 2 | length | 分页长度 | integer | — | Optional | 分页长度,默认20,上限1000 |
| 3 | mids | 站点id | array<any> | — | Optional | 站点id |
| 4 | sids | 店铺id | array<any> | — | Optional | 店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】 |
| 5 | searchDateField | 时间筛选类型 | string | — | Optional | 时间筛选类型: posted_date_locale 结算时间【默认】 fund_transfer_datetime_locale 转账时间 shipment_datetime_locale 发货时间 order_datetime_locale 下单时间 accounting_time 入账时间 |
| 6 | startDate | 开始时间 | string | — | Required | 开始时间 |
| 7 | endDate | 结束时间 | string | — | Required | 结束时间 |
| 8 | gmtModifiedStartDate | 修改开始时间 | string | — | Optional | 修改开始时间,格式:yyyy-MM-dd HH:mm:ss |
| 9 | gmtModifiedEndDate | 修改结束时间 | string | — | Optional | 修改结束时间,格式:yyyy-MM-dd HH:mm:ss |
| 10 | currencyCode | 货币种类 | string | — | Optional | 货币种类: 原币种【默认】 CNY USD EUR JPY AUD CAD MXN GBP INR AED SGD SAR BRL SEK PLN TRY HKD |
| 11 | searchField | 查询索引字段 | string | — | Optional | 查询索引字段: order_id 订单号【默认】 seller_sku MSKU asin ASIN parent_asin 父ASIN local_sku SKU local_name 品名gmt_modified 修改时间【不再建议使用】settlement_id Settlement ID description 描述 fid 结算编号 |
| 12 | searchValue | 查询索引字段值 | array<any> | — | Optional | 查询索引字段值 |
| 13 | sortField | 参与排序字段 | string | — | Optional | 参与排序字段 |
| 14 | sortType | 排序方式 | string | — | Optional | 排序方式 |
| 15 | settlementStatus | 结算状态 | array<any> | — | Optional | 结算状态 Open 待结算 Pending 结算中 Closed 已结算 Reconciled 已对账 |
| 16 | fundTransferStatus | 转账状态 | array<any> | — | Optional | 转账状态: Succeeded 已转账 Processing 转帐中 Failed 失败 Unknown 未知 |
| 17 | accountType | 账单类型 | array<any> | — | Optional | 账单类型: Standard Invoiced Electronic COD PayWithAmazon |
| 18 | eventSource | 费用类型 | array<any> | — | Optional | 费用类型: Transfer Adjustment Debt Refund FBA Inventory Fee Service Fee Order |
| 19 | fulfillment | 订单类型 | array<any> | — | Optional | 订单类型: FBA FBA FBM FBM |
| 20 | principalUids | listing负责人 | array<any> | — | Optional | listing负责人 |
| 21 | productDeveloperUids | 开发负责人 | array<any> | — | Optional | 开发负责人 |
| 22 | orderStatus | 交易状态 | string | — | Optional | 交易状态 Deferred 已推迟(结束时间必须要今天才能获取已推迟数据) Disbursed 已发放【默认】 DisbursedAndPreSettled 已发放(含预结算) All 全部 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | number | 0 | Required | 状态码,0:成功 |
| 2 | message | 消息提示 | string | success | Required | 消息提示 |
| 3 | error_details | 错误详情 | array<any> | — | Required | 错误详情 |
| 4 | request_id | 请求链路id | string | 6f66d7b3602a4bb48563dc2eedace8e0.236.17255404176056375 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2024-09-05 20:46:58 | Required | 响应时间 |
| 6 | data | data | object | — | Required | |
| 6.1 | records | records | array<object> | — | Required | |
| 6.1.1 | id | id | string | 38959929246716175543322278226548439778262302539968746850187907781625596404240 | Required | id |
| 6.1.2 | bizId | 业务ID | string | — | Required | 业务ID |
| 6.1.3 | bizIdRowIndex | 业务ID行索引 | number | 0 | Required | 业务ID行索引 |
| 6.1.4 | sid | 店铺id | string | 6 | Required | 店铺id |
| 6.1.5 | transactionId | transactionId | string | 22dd24b86a464cf2a7541252dc462587.1760926323389 | Optional | transactionId,已发放状态不返回 |
| 6.1.6 | storeName | 店铺 | string | 篮球 | Required | 店铺 |
| 6.1.7 | country | 国家 | string | 美国 | Required | 国家 |
| 6.1.8 | countryCode | 国家编码 | string | US | Required | 国家编码 |
| 6.1.9 | postedDatetimeLocale | 结算时间 | string | 2023-02-24 23:02:52 | Required | 结算时间 |
| 6.1.10 | settlementStatus | 结算状态 | string | Closed | Required | 结算状态 |
| 6.1.11 | orderId | 订单号 | string | — | Required | 订单号 |
| 6.1.12 | fulfillment | 订单类型 | string | — | Required | 订单类型 |
| 6.1.13 | orderDatetimeLocale | 下单时间 | string | — | Required | 下单时间 |
| 6.1.14 | paymentDatetimeLocale | 付款时间 | string | — | Required | 付款时间 |
| 6.1.15 | shipmentDatetimeLocale | 发货时间 | string | — | Required | 发货时间 |
| 6.1.16 | fundTransferDatetimeLocale | 转账时间 | string | 2023-03-03 15:31:52 | Required | 转账时间 |
| 6.1.17 | fundTransferStatus | 转账状态 | string | Unknown | Required | 转账状态 |
| 6.1.18 | gmtModified | 修改时间 | string | 2023-03-03 15:31:52 | Required | 修改时间 |
| 6.1.19 | accountType | 账单类型 | string | Standard | Required | 账单类型 |
| 6.1.20 | eventSource | 费用类型 | string | Service Fee | Required | 费用类型 |
| 6.1.21 | settlementId | Settlement ID | string | 17449132851 | Required | Settlement ID |
| 6.1.22 | fid | 结算编号 | string | 8RC4KL1HB615 | Required | 结算编号 |
| 6.1.23 | smallImageUrl | 图片 | string | — | Required | 图片 |
| 6.1.24 | msku | msku | string | — | Required | MSKU |
| 6.1.25 | fnsku | fnsku | string | — | Required | FNSKU |
| 6.1.26 | asin | asin | string | — | Required | ASIN |
| 6.1.27 | parentAsin | 父ASIN | string | — | Required | 父ASIN |
| 6.1.28 | localName | 品名 | string | — | Required | 品名 |
| 6.1.29 | localSku | localSku | string | — | Required | SKU |
| 6.1.30 | description | 描述 | string | Subscription | Required | 描述 |
| 6.1.31 | quantity | 数量 | number | 0 | Required | 数量 |
| 6.1.32 | principalRealname | Listing负责人 | string | — | Required | Listing负责人 |
| 6.1.33 | productDeveloperRealname | 开发负责人 | string | — | Required | 开发负责人 |
| 6.1.34 | currencyCode | 币种 | string | USD | Required | 币种 |
| 6.1.35 | currencyIcon | 币种符号 | string | $ | Required | 币种符号 |
| 6.1.36 | productSales | 销售额 | number | 0 | Required | 销售额 |
| 6.1.37 | productSalesTax | 销售税 | number | 0 | Required | 销售税 |
| 6.1.38 | shippingCredits | 买家运费 | number | 0 | Required | 买家运费 |
| 6.1.39 | shippingCreditsTax | 买家运费税 | number | 0 | Required | 买家运费税 |
| 6.1.40 | giftwrapCredits | 礼品包装 | number | 0 | Required | 礼品包装 |
| 6.1.41 | giftwrapCreditsTax | 礼品包装税 | number | 0 | Required | 礼品包装税 |
| 6.1.42 | amazonPointFee | 积分 | number | 0 | Required | 积分 |
| 6.1.43 | promotionalRebates | 促销折扣 | number | 0 | Required | 促销折扣 |
| 6.1.44 | promotionalRebatesTax | 促销折扣费 | number | 0 | Required | 促销折扣费 |
| 6.1.45 | salesTaxCollected | 代扣代缴增值税 | number | 0 | Required | 代扣代缴增值税 |
| 6.1.46 | lowValueGoods | 低价值商品税 | number | 0 | Required | 低价值商品税 |
| 6.1.47 | marketplaceWithheldTax | 市场预扣税 | number | 0 | Required | 市场预扣税 |
| 6.1.48 | tcsCgst | tcsCgst | number | 0 | Required | TCS_CGST |
| 6.1.49 | tcsSgst | tcsSgst | number | 0 | Required | TCS_SGST |
| 6.1.50 | tcsIgst | tcsIgst | number | 0 | Required | TCS_IGST |
| 6.1.51 | sellingFees | 平台费 | number | 0 | Required | 平台费 |
| 6.1.52 | fbaFees | FBA费 | number | 0 | Required | FBA费 |
| 6.1.53 | otherTransactionFees | 其他交易费 | number | 0 | Required | 其他交易费 |
| 6.1.54 | other | 其他 | number | -39.99 | Required | 其他 |
| 6.1.55 | hiddenTax | 隐藏税 | number | 0 | Required | 隐藏税 |
| 6.1.56 | settlementTotal | 亚马逊结算小计 | number | -39.99 | Required | 亚马逊结算小计 |
| 6.1.57 | purchaseCostsTotal | 采购成本 | number | 0 | Required | 采购成本 |
| 6.1.58 | logisticsCostsTotal | 头程成本 | number | 0 | Required | 头程成本 |
| 6.1.59 | otherCostsTotal | 其他成本 | number | 0 | Required | 其他成本 |
| 6.1.60 | customOrderFeeTotal | 站外推广费 | number | 0 | Required | 站外推广费 |
| 6.1.61 | settlementGrossProfit | 结算订单毛利润 | number | -39.99 | Required | 结算订单毛利润 |
| 6.1.62 | settlementGrossProfitRate | 结算订单毛利率 | number | 0 | Required | 结算订单毛利率 |
| 6.1.63 | promotionId | 促销编码 | string | — | Required | 促销编码 |
| 6.1.64 | transactionStatus | 交易状态 | string | — | Required | 交易状态 |
| 6.1.65 | transactionStatusCode | 交易状态码 | string | — | Required | 交易状态码 |
| 6.1.66 | deferredSubStatus | 已推迟订单状态 | string | — | Required | 已推迟订单状态: 已推迟 预结算 当月结算 估实差异 入账冲销 |
| 6.1.67 | deferredSubStatusCode | 已推迟订单状态码 | string | — | Required | 已推迟订单状态码: Deferred PreSettlement RegularSettlement PreSettlementReversal deferredReversal Disbursed |
| 6.1.68 | shipPromotionDiscount | 配送促销折扣 | number | 9 | Required | 配送促销折扣 |
| 6.1.69 | itemPromotionDiscount | 商品促销折扣 | number | 9 | Required | 商品促销折扣 |
| 6.1.70 | odsEventType | odsEventType | string | ServiceFeeEventList | Required | odsEventType |
| 6.1.71 | rowIndex | rowIndex | number | 9 | Required | rowIndex |
| 6.1.72 | accountingTime | 入账时间 | string | "2025-07-15 03:31:10" | Required | 入账时间 |
| 6.2 | total | 总数 | number | 9 | Required | 总数 |
| 7 | total | 总数 | number | 0 | Required | 总数 |
The 查询利润报表 - 订单维度transaction视图 API (/basicOpen/finance/profitReport/order/transcation/list) 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.