Qeasy Cloud
Get Started

领星ERP 查询利润报表 - 订单维度transaction视图 API

Platform
领星ERP
Type
WebAPI
Effect
QUERY
API Version
1.0
Adapter
\Adapter\LingXing\LXQueryAdapter
Auth Mode
OTHER
Description
财务 · POST · 请求参数 22 个(必填 2) · 响应参数 81 个 · 限流令牌桶容量 1
Updated At
2026-11-21

查询利润报表 - 订单维度transaction视图

POST/basicOpen/finance/profitReport/order/transcation/list
Factory
{
  "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
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1offset分页偏移量integer—Optional分页偏移量,默认0
2length分页长度integer—Optional分页长度,默认20,上限1000
3mids站点idarray<any>—Optional站点id
4sids店铺idarray<any>—Optional店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】
5searchDateField时间筛选类型string—Optional时间筛选类型: posted_date_locale 结算时间【默认】 fund_transfer_datetime_locale 转账时间 shipment_datetime_locale 发货时间 order_datetime_locale 下单时间 accounting_time 入账时间
6startDate开始时间string—Required开始时间
7endDate结束时间string—Required结束时间
8gmtModifiedStartDate修改开始时间string—Optional修改开始时间,格式:yyyy-MM-dd HH:mm:ss
9gmtModifiedEndDate修改结束时间string—Optional修改结束时间,格式:yyyy-MM-dd HH:mm:ss
10currencyCode货币种类string—Optional货币种类: 原币种【默认】 CNY USD EUR JPY AUD CAD MXN GBP INR AED SGD SAR BRL SEK PLN TRY HKD
11searchField查询索引字段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 结算编号
12searchValue查询索引字段值array<any>—Optional查询索引字段值
13sortField参与排序字段string—Optional参与排序字段
14sortType排序方式string—Optional排序方式
15settlementStatus结算状态array<any>—Optional结算状态 Open 待结算 Pending 结算中 Closed 已结算 Reconciled 已对账
16fundTransferStatus转账状态array<any>—Optional转账状态: Succeeded 已转账 Processing 转帐中 Failed 失败 Unknown 未知
17accountType账单类型array<any>—Optional账单类型: Standard Invoiced Electronic COD PayWithAmazon
18eventSource费用类型array<any>—Optional费用类型: Transfer Adjustment Debt Refund FBA Inventory Fee Service Fee Order
19fulfillment订单类型array<any>—Optional订单类型: FBA FBA FBM FBM
20principalUidslisting负责人array<any>—Optionallisting负责人
21productDeveloperUids开发负责人array<any>—Optional开发负责人
22orderStatus交易状态string—Optional交易状态 Deferred 已推迟(结束时间必须要今天才能获取已推迟数据) Disbursed 已发放【默认】 DisbursedAndPreSettled 已发放(含预结算) All 全部

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码number0Required状态码,0:成功
2message消息提示stringsuccessRequired消息提示
3error_details错误详情array<any>—Required错误详情
4request_id请求链路idstring6f66d7b3602a4bb48563dc2eedace8e0.236.17255404176056375Required请求链路id
5response_time响应时间string2024-09-05 20:46:58Required响应时间
6datadataobject—Required
6.1recordsrecordsarray<object>—Required
6.1.1ididstring38959929246716175543322278226548439778262302539968746850187907781625596404240Requiredid
6.1.2bizId业务IDstring—Required业务ID
6.1.3bizIdRowIndex业务ID行索引number0Required业务ID行索引
6.1.4sid店铺idstring6Required店铺id
6.1.5transactionIdtransactionIdstring22dd24b86a464cf2a7541252dc462587.1760926323389OptionaltransactionId,已发放状态不返回
6.1.6storeName店铺string篮球Required店铺
6.1.7country国家string美国Required国家
6.1.8countryCode国家编码stringUSRequired国家编码
6.1.9postedDatetimeLocale结算时间string2023-02-24 23:02:52Required结算时间
6.1.10settlementStatus结算状态stringClosedRequired结算状态
6.1.11orderId订单号string—Required订单号
6.1.12fulfillment订单类型string—Required订单类型
6.1.13orderDatetimeLocale下单时间string—Required下单时间
6.1.14paymentDatetimeLocale付款时间string—Required付款时间
6.1.15shipmentDatetimeLocale发货时间string—Required发货时间
6.1.16fundTransferDatetimeLocale转账时间string2023-03-03 15:31:52Required转账时间
6.1.17fundTransferStatus转账状态stringUnknownRequired转账状态
6.1.18gmtModified修改时间string2023-03-03 15:31:52Required修改时间
6.1.19accountType账单类型stringStandardRequired账单类型
6.1.20eventSource费用类型stringService FeeRequired费用类型
6.1.21settlementIdSettlement IDstring17449132851RequiredSettlement ID
6.1.22fid结算编号string8RC4KL1HB615Required结算编号
6.1.23smallImageUrl图片string—Required图片
6.1.24mskumskustring—RequiredMSKU
6.1.25fnskufnskustring—RequiredFNSKU
6.1.26asinasinstring—RequiredASIN
6.1.27parentAsin父ASINstring—Required父ASIN
6.1.28localName品名string—Required品名
6.1.29localSkulocalSkustring—RequiredSKU
6.1.30description描述stringSubscriptionRequired描述
6.1.31quantity数量number0Required数量
6.1.32principalRealnameListing负责人string—RequiredListing负责人
6.1.33productDeveloperRealname开发负责人string—Required开发负责人
6.1.34currencyCode币种stringUSDRequired币种
6.1.35currencyIcon币种符号string$Required币种符号
6.1.36productSales销售额number0Required销售额
6.1.37productSalesTax销售税number0Required销售税
6.1.38shippingCredits买家运费number0Required买家运费
6.1.39shippingCreditsTax买家运费税number0Required买家运费税
6.1.40giftwrapCredits礼品包装number0Required礼品包装
6.1.41giftwrapCreditsTax礼品包装税number0Required礼品包装税
6.1.42amazonPointFee积分number0Required积分
6.1.43promotionalRebates促销折扣number0Required促销折扣
6.1.44promotionalRebatesTax促销折扣费number0Required促销折扣费
6.1.45salesTaxCollected代扣代缴增值税number0Required代扣代缴增值税
6.1.46lowValueGoods低价值商品税number0Required低价值商品税
6.1.47marketplaceWithheldTax市场预扣税number0Required市场预扣税
6.1.48tcsCgsttcsCgstnumber0RequiredTCS_CGST
6.1.49tcsSgsttcsSgstnumber0RequiredTCS_SGST
6.1.50tcsIgsttcsIgstnumber0RequiredTCS_IGST
6.1.51sellingFees平台费number0Required平台费
6.1.52fbaFeesFBA费number0RequiredFBA费
6.1.53otherTransactionFees其他交易费number0Required其他交易费
6.1.54other其他number-39.99Required其他
6.1.55hiddenTax隐藏税number0Required隐藏税
6.1.56settlementTotal亚马逊结算小计number-39.99Required亚马逊结算小计
6.1.57purchaseCostsTotal采购成本number0Required采购成本
6.1.58logisticsCostsTotal头程成本number0Required头程成本
6.1.59otherCostsTotal其他成本number0Required其他成本
6.1.60customOrderFeeTotal站外推广费number0Required站外推广费
6.1.61settlementGrossProfit结算订单毛利润number-39.99Required结算订单毛利润
6.1.62settlementGrossProfitRate结算订单毛利率number0Required结算订单毛利率
6.1.63promotionId促销编码string—Required促销编码
6.1.64transactionStatus交易状态string—Required交易状态
6.1.65transactionStatusCode交易状态码string—Required交易状态码
6.1.66deferredSubStatus已推迟订单状态string—Required已推迟订单状态: 已推迟 预结算 当月结算 估实差异 入账冲销
6.1.67deferredSubStatusCode已推迟订单状态码string—Required已推迟订单状态码: Deferred PreSettlement RegularSettlement PreSettlementReversal deferredReversal Disbursed
6.1.68shipPromotionDiscount配送促销折扣number9Required配送促销折扣
6.1.69itemPromotionDiscount商品促销折扣number9Required商品促销折扣
6.1.70odsEventTypeodsEventTypestringServiceFeeEventListRequiredodsEventType
6.1.71rowIndexrowIndexnumber9RequiredrowIndex
6.1.72accountingTime入账时间string"2025-07-15 03:31:10"Required入账时间
6.2total总数number9Required总数
7total总数number0Required总数

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.

Need to integrate this API?

Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.