Qeasy Cloud
Get Started

领星ERP 利润报表 - 明细列表查询 API

Platform
领星ERP
Type
WebAPI
Effect
QUERY
API Version
1.0
Adapter
\Adapter\LingXing\LXQueryAdapter
Auth Mode
OTHER
Description
多平台 / 财务 / 利润报表 · POST · 请求参数 25 个(必填 3) · 响应参数 61 个 · 限流令牌桶容量 1
Updated At
2026-11-21

利润报表 - 明细列表查询

POST/basicOpen/finance/settlement/profitList
Factory
{
  "operation": {
    "method": "POST",
    "path": "/basicOpen/finance/settlement/profitList"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 1,
    "text": ""
  },
  "requestExample": "curl --location 'https://openapi.lingxing.com/basicOpen/finance/settlement/profitList?access_token=value&timestamp=value&sign=value&app_key=value' \\\n--header 'Content-Type: application/json' \\\n--data '{\n    \"summaryField\": \"1\",\n    \"pageNum\": 1,\n    \"pageSize\": 20,\n    \"startDate\": \"2025-11-01\",\n    \"endDate\": \"2025-11-30\",\n    \"fulfilmentTypes\": [1]\n}'",
  "responseExample": {
    "code": 0,
    "message": "success",
    "error_details": [],
    "request_id": "example-request-id-query-mode-1",
    "response_time": "2026-09-04 09:22:59",
    "data": {
      "configList": [
        {
          "displayFormat": 2,
          "displayFormatName": "金额",
          "fields": null,
          "itemField": "platformSettlement",
          "itemName": "平台结算",
          "itemType": 5,
          "itemTypeName": "利润",
          "parentItemName": "利润",
          "sortOrder": 1000,
          "tooltip": ""
        },
        {
          "displayFormat": 2,
          "displayFormatName": "金额",
          "fields": [
            {
              "displayName": "商品金额",
              "fieldName": "commonProductAmount",
              "platformCodes": [
                "10011"
              ]
            }
          ],
          "itemField": "salesAmount",
          "itemName": "销售额",
          "itemType": 1,
          "itemTypeName": "收入",
          "parentItemName": "平台收入",
          "sortOrder": 3000,
          "tooltip": ""
        }
      ],
      "dataList": [
        {
          "area": "美国",
          "asin": null,
          "brand": "示例品牌",
          "category": "示例分类",
          "costSource": "固定值",
          "country": "美国",
          "currency": "USD",
          "currencyIcon": "$",
          "developer": "示例开发人",
          "hasOriginalOrder": true,
          "localSku": "SKU-001",
          "msku": "MSKU-001",
          "mskuId": "example-msku-id",
          "orderItemNo": "",
          "packageNo": null,
          "platformCode": "10011",
          "platformName": "TikTok",
          "platformOrderNo": "example-platform-order-no",
          "productName": "示例商品",
          "profitItems": {
            "platformSettlement": 75.25,
            "salesAmount": 100,
            "platformCommission": -5,
            "platformDeliveryFee": -10,
            "productCost": -20,
            "profit": 30,
            "profitMargin": "30.00%"
          },
          "purchaseDate": "2026-08-01",
          "purchaseTime": "2026-08-01 10:00:00",
          "settlementTime": "2026-08-03",
          "shipmentDate": null,
          "shipmentTime": "2026-08-02 08:00:00",
          "skc": "",
          "spuId": "example-spu-id",
          "stockOrderNo": null,
          "storeId": "example-store-id",
          "storeName": "示例店铺",
          "transactionType": "销售",
          "uniqueId": "example-unique-id",
          "waybillNo": "",
          "fulfilmentType": "平台发货"
        }
      ],
      "total": {
        "currency": "USD",
        "currencyIcon": "$",
        "profitItems": {
          "platformSettlement": 150.5,
          "salesAmount": 200,
          "platformCommission": -10,
          "platformDeliveryFee": -20,
          "productCost": -40,
          "profit": 60,
          "profitMargin": "30.00%"
        }
      },
      "totalCount": 2
    },
    "total": 2
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1summaryField汇总维度string—Required汇总维度: 1=订单 2=店铺 3=MSKU 4=SKU 5=开发者 6=负责人 11=SPU
2summaryType时间汇总维度integer—Optional时间汇总维度,仅非订单维度(summaryField!=1)时生效: null/0=默认(不按时间聚合) 1=按月 2=按天 3=按周
3pageNum当前页码integer—Required当前页码,默认1
4pageSize每页大小integer—Required每页大小,默认20,最大200
5startDate开始日期 yyyy-MM-ddstring—Optional开始日期 yyyy-MM-dd
6endDate结束日期 yyyy-MM-ddstring—Optional结束日期 yyyy-MM-dd
7dateRangeType日期范围类型integer—Optional日期范围类型: 0=结算时间 1=下单时间 默认为0
8sids店铺ID列表array<any>—Optional店铺ID列表
9platformCodes平台代码列表array<any>—Optional平台代码列表: 10002=Shopify 10003=eBay 10006=Shopee 10008=Walmart 10011=TikTok 10012=MercadoLibre 10021=SHEIN平台模式 10028=SHEIN半托管 10007=Lazada 10024=Temu半托管 10022=Temu全托管 10027=SHEIN代运营
10areas站点/区域列表array<any>—Optional站点/区域列表
11countries国家列表array<any>—Optional国家列表
12brands品牌ID列表array<any>—Optional品牌ID列表
13categories分类ID列表array<any>—Optional分类ID列表
14developers开发人UID列表array<any>—Optional开发人UID列表
15currency币种string—Optional币种,默认为空展示原币种
16queryMode查询模式integer—Optional查询模式: 1=列表 2=明细
17transactionTypes交易类型array<any>—Optional交易类型: order=销售 refund=退款 return=退货 manual=手工 reshipment=补发 manual_add=加购 other=其他
18fulfilmentTypes发货类型筛选array<any>—Optional发货类型筛选,仅汇总维度为订单(summaryField=1)时生效: 1=自发货 2=平台发货 3=部分自发货
19hasOriginalOrder有无源单integer—Optional有无源单,仅汇总维度为订单时生效: 1=有源单 0=无源单 不传则不过滤
20searchField商品筛选字段integer—Optional商品筛选字段: 1=MSKU 2=MSKU ID 3=品名 4=系统SKU
21searchValues商品筛选值列表array<any>—Optional商品筛选值列表,支持批量搜索
22orderSearchField单据筛选字段integer—Optional单据筛选字段: 1=平台订单号 2=平台子单号 3=备货单号 4=业务单号 5=运单号 6=包裹
23orderSearchValues单据筛选值列表array<any>—Optional单据筛选值列表,支持批量搜索
24sortField排序字段string—Optional排序字段
25sortType排序类型string—Optional排序类型:asc升序、desc降序

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer0Required状态码,0:成功
2message消息提示stringsuccessRequired消息提示
3error_details数据校验失败时的错误详情array<any>—Required数据校验失败时的错误详情
4request_id请求链路idstringa0d54debf93140f3b58d1ed81e8e3583Required请求链路id
5response_time响应时间string2026-04-09 12:00:00Required响应时间
6data响应数据object—Required响应数据
6.1configList利润配置项列表array<object>—Required利润配置项列表,用于前端渲染动态列
6.1.1itemType类型integer1Required类型:1=收入,2=税费,3=费用,4=成本,5=利润
6.1.2itemTypeName类型名称string收入Required类型名称
6.1.3itemField二级利润项目字段名stringsalesAmountRequired二级利润项目字段名
6.1.4itemName二级利润项目string销售额Required二级利润项目
6.1.5parentItemName一级利润项目string平台收入Required一级利润项目
6.1.6displayFormat显示格式integer2Required显示格式:1=整数,2=金额,3=百分比
6.1.7displayFormatName显示格式名称string金额Required显示格式名称
6.1.8sortOrder排序顺序integer1Required排序顺序
6.1.9tooltip气泡注释string—Required气泡注释
6.1.10fields关联的明细字段列表array<object>—Required关联的明细字段列表
6.1.10.1fieldName字段名称stringsalesAmountRequired字段名称
6.1.10.2displayName显示名称string销售额Required显示名称
6.1.10.3platformCodes适用的平台代码列表array<any>["AMAZON"]Required适用的平台代码列表
6.2dataList数据列表array<object>—Required数据列表
6.2.1platformCode平台代码stringAMAZONRequired平台代码
6.2.2platformName平台名称string亚马逊Required平台名称
6.2.3storeId多平台店铺IDstring123Required多平台店铺ID
6.2.4storeName店铺名称string店铺ARequired店铺名称
6.2.5area站点(区域)stringUSRequired站点(区域)
6.2.6country国家stringUSRequired国家
6.2.7currency币种stringUSDRequired币种
6.2.8currencyIcon币种图标string$Required币种图标
6.2.9mskumskustringMSKU001RequiredMSKU
6.2.10mskuIdMSKU IDstring123456RequiredMSKU ID
6.2.11asinasinstringB0ABC12345RequiredASIN
6.2.12localSkulocalSkustringSKU001RequiredSKU
6.2.13spuIdSPU IDstring789RequiredSPU ID
6.2.14skcskcstringSKC001RequiredSKC
6.2.15productName品名string示例产品Required品名
6.2.16brand品牌string品牌ARequired品牌
6.2.17category分类string分类ARequired分类
6.2.18developer开发人string张三Required开发人
6.2.19costSource成本来源string固定值Required成本来源: 固定值 销售出库单 WFS批次成本 平台发货仓 取消单无成本 多渠道配送 退货入库单
6.2.20platformOrderNo平台单号string111-1234567-1234567Required平台单号
6.2.21orderItemNo平台子单号string12345678901234Required平台子单号
6.2.22packageNo包裹号stringBG202501001Required包裹号
6.2.23stockOrderNo备货单号stringBH202501001Required备货单号
6.2.24waybillNo运单号stringYD202501001Required运单号
6.2.25transactionType交易类型stringorderRequired交易类型: order=销售 refund=退款 return=退货 manual=手工 reshipment=补发 manual_add=加购 other=其他
6.2.26uniqueId订单维度唯一键string123456789Required订单维度唯一键
6.2.27purchaseDate下单时间string2025-11-01Required下单时间
6.2.28purchaseTime下单时间string2025-11-01 12:00:00Required下单时间,格式:yyyy-MM-dd HH:mm:ss
6.2.29settlementTime结算日期string2025-11-15Required结算日期
6.2.30shipmentDate发货日期string2025-11-02Required发货日期
6.2.31shipmentTime标发时间string2025-11-02 12:00:00Required标发时间,格式:yyyy-MM-dd HH:mm:ss
6.2.32hasOriginalOrder是否有原始订单booleantrueRequired是否有原始订单
6.2.33fulfilmentType发货类型string1Required发货类型: 1=自发货 2=平台发货 3=部分自发货
6.2.34profitItems利润项object{"salesAmount":"100.00"}Required利润项,key为小写驼峰字段名,value为格式化后的值
6.3total汇总数据object—Required汇总数据
6.3.1currency币种stringUSDRequired币种
6.3.2currencyIcon币种图标string$Required币种图标
6.3.3profitItems利润项object{"salesAmount":"1000.00"}Required利润项,key为小写驼峰字段名,value为格式化后的值
6.4totalCount总记录数integer100Required总记录数
7total总数integer100Required总数

The 利润报表 - 明细列表查询 API (/basicOpen/finance/settlement/profitList) 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.