轻易云
注册体验

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

所属平台
领星ERP
类型
WebAPI
作用
QUERY
接口版本
1.0
适配器
\Adapter\LingXing\LXQueryAdapter
授权方式
OTHER
描述
财务 · POST · 请求参数 22 个(必填 2) · 响应参数 81 个 · 限流令牌桶容量 1
更新日期
2026-11-21

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

POST/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
  }
}

接口请求参数

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

接口响应参数

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

领星ERP的接口:查询利润报表 - 订单维度transaction视图(/basicOpen/finance/profitReport/order/transcation/list),由轻易云数据集成平台 API 资产管理模块整理收纳,并随领星ERP版本更新同步更新。

需要对接这个接口?

轻易云已预置该接口的适配能力,联系我们即可开始配置数据集成。