轻易云
注册体验

领星ERP查询利润报表 - 订单接口

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

查询利润报表 - 订单

POST/bd/profit/report/open/report/order/list
加工厂
{
  "operation": {
    "method": "POST",
    "path": "/bd/profit/report/open/report/order/list"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 10,
    "text": ""
  },
  "requestExample": {
    "offset": 0,
    "length": 20,
    "sids": [
      136
    ],
    "search_date_field": "fund_transfer_datetime_locale",
    "start_date": "2023-01-21",
    "end_date": "2024-07-20",
    "search_field": "order_id",
    "search_value": [
      ""
    ],
    "currency_code": "CNY",
    "account_type": "Standard",
    "settlement_status": [
      "Closed"
    ],
    "fund_transfer_status": [
      "Succeeded",
      "Unknown"
    ],
    "event_source": [
      "ServiceFee",
      "DebtRecovery"
    ],
    "description": [
      "Subscription",
      "RecoveryAmount"
    ]
  },
  "responseExample": {
    "code": 0,
    "message": "操作成功",
    "error_details": [],
    "request_id": "14316922-d968-49dc-af7f-ac3aa4e29d09.1682560729730",
    "response_time": "2023-04-27 09:58:50",
    "total": 11345,
    "data": [
      {
        "id": "4289099",
        "sid": "8",
        "country": "英国",
        "fid": "",
        "description": "PaidServicesFee",
        "msku": "",
        "asin": "",
        "fulfillment": "",
        "principal": 0,
        "commission": 0,
        "tax": 0,
        "other": 0,
        "store_name": "JHM Official-01",
        "country_code": "UK",
        "posted_datetime_locale": "2023-03-02 05:05:29",
        "currency_code": "CNY",
        "currency_icon": "¥",
        "order_id": "AMPSBilling_48155952912_1_2023_01_01",
        "event_source": "ServiceFee",
        "account_type": "Standard",
        "parent_asin": "",
        "local_name": "",
        "local_sku": "",
        "settlement_status": "",
        "fund_transfer_status": "",
        "fund_transfer_datetime_locale": "",
        "shipment_datetime_locale": "",
        "small_image_url": "",
        "cost_quantity": 0,
        "product_sales_quantity": 0,
        "shipping_charge": 0,
        "promotional_rebates": 0,
        "shipping_chargeback": 0,
        "gift_wrap": 0,
        "giftwrap_chargeback": 0,
        "fba_per_unit_fulfillment_fee": 0,
        "refund_commission": 0,
        "shipping_tax": 0,
        "sales_tax_withheld": 0,
        "marketplace_facilitator_vat_principal": 0,
        "marketplace_facilitator_vat_shipping": 0,
        "giftWrap_tax": 0,
        "promotion_discount_tax": 0,
        "shipping_discount_tax": 0,
        "restocking_fee": 0,
        "other_transaction_fees_total": -17483.7,
        "other_transaction_fees_detail": "{\"PaidServicesFee\":-17483.70}",
        "settlement_total": -17483.7,
        "purchase_costs_total": 0,
        "logistics_costs_total": 0,
        "other_costs_total": 0,
        "gross_profit": -17483.7
      }
    ]
  }
}

接口请求参数

序号字段名称类型默认值必填描述
1offset分页偏移量integer—可选分页偏移量,默认0
2length分页长度integer—可选分页长度,上限10000
3mids站点idarray<any>—可选站点id
4sids店铺idarray<any>—可选店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】
5search_date_field时间类型string—必填时间类型: posted_date_locale 结算时间 fund_transfer_datetime_locale 转账时间 shipment_datetime_locale 发货时间
6start_date开始时间string—必填开始时间
7end_date结束时间string—必填结束时间
8search_field搜索值类型string—可选搜索值类型: 亚马逊订单号:order_id MSKU:seller_sku Asin:asin 父asin:parent_asin SKU:local_sku 品名:local_name
9search_value搜索的值array<any>—可选搜索的值
10currency_code币种codestring—可选币种code
11account_type报告类型string—可选报告类型: Standard Invoiced Electronic COD PayWithAmazon
12settlement_status结算状态array<any>—可选结算状态: 待结算:["Open", "Pending"] 已结算:["Closed"]
13fund_transfer_status转账状态array<any>—可选转账状态: 已转帐 Succeeded 转帐中 Processing 失败 Failed 未知 Unknown
14event_source来源array<any>—可选来源: SellerDealPayment ServiceFee Adjustment Refund SellerReviewEnrollmentPayment RemovalShipmentAdjustment ProductAdsPayment Shipment DebtRecovery Liquidations Adjustments Retrocharge RemovalShipment
15description描述array<any>—可选描述

接口响应参数

序号字段名称类型默认值必填描述
1code状态码integer0必填状态码,0 成功
2message消息提示string操作成功必填消息提示
3error_details错误信息array<any>—必填错误信息
4request_id请求链路idstring14316922-d968-49dc-af7f-ac3aa4e29d09.1682560729730必填请求链路id
5response_time响应时间string2023-04-27 09:58:50必填响应时间
6total总数integer11345必填总数
7data响应数据array<object>—必填响应数据
7.1id记录id【非唯一值】string97860842859265346195179669414178955639632303349797920144362032035134467346451必填记录id【非唯一值】,唯一键参考
7.2sid店铺idinteger8必填店铺id
7.3store_name店铺名stringJHL Official-01必填店铺名
7.4country_code国家编码stringUK必填国家编码
7.5country国家string英国必填国家
7.6fid结算编号stringABC必填结算编号
7.7description描述stringPaidServicesFee,PointsAdjusted必填描述,返回该行对应描述的拼接字符串 【枚举见附加说明】
7.8mskumskustringJX-MPNS-QJZP必填MSKU
7.9asinasinstringB07H2PWQR2必填asin
7.10fulfillment订单类型stringFBA必填订单类型:FBA、FBM、''
7.11principal销售额number0必填销售额
7.12commission平台费number0必填平台费
7.13tax销售税额number0必填销售税额
7.14other平台收入中其他收入的其他费用number0必填平台收入中其他收入的其他费用
7.15posted_datetime_locale结算时间string2023-03-02 05:05:29必填结算时间
7.16currency_code选择转化后币种stringCNY必填选择转化后币种
7.17currency_icon选择转化后对应的币符string¥必填选择转化后对应的币符
7.18order_id订单号stringAMPSBilling_48155952912_3_2023_01_01必填订单号
7.19event_source来源stringServiceFee必填来源
7.20account_type报告类型stringStandard必填报告类型
7.21parent_asin父asinstringB07H2PWQR2必填父asin
7.22local_name品名stringlocal_name必填品名
7.23local_skulocal_skustringlocal_sku必填sku
7.24settlement_status结算状态array<any>["Closed"]必填结算状态
7.25fund_transfer_status转账状态array<any>["Succeeded"]必填转账状态
7.26fund_transfer_datetime_locale转账时间string2023-03-02 05:05:29必填转账时间
7.27shipment_datetime_locale发货时间string2023-03-02 05:05:29必填发货时间
7.28small_image_url图片stringhttps://www.amazon.com/dp/B07H2PWQR2必填图片
7.29cost_quantity成本数量number0必填成本数量
7.30product_sales_quantity订单数量number0必填订单数量
7.31shipping_charge买家运费number0必填买家运费
7.32promotional_rebates促销折扣number0必填促销折扣
7.33shipping_chargeback运费拒付number0必填运费拒付
7.34gift_wrap礼品包装number0必填礼品包装
7.35giftwrap_chargeback礼品包装拒付number0必填礼品包装拒付
7.36fba_per_unit_fulfillment_feeFBA费number0必填FBA费
7.37refund_commission交易费用退款额number0必填交易费用退款额
7.38shipping_tax运费税number0必填运费税
7.39sales_tax_withheld市场税number0必填市场税
7.40marketplace_facilitator_vat_principal市场税-销售额number0必填市场税-销售额
7.41marketplace_facilitator_vat_shipping市场税-买家运费number0必填市场税-买家运费
7.42giftWrap_tax礼物包装税number0必填礼物包装税
7.43promotion_discount_tax促销折扣税number0必填促销折扣税
7.44shipping_discount_tax运费折扣税number0必填运费折扣税
7.45restocking_fee补货费number0必填补货费
7.46other_transaction_fees_total其他交易费总计number-17483.7必填其他交易费总计
7.47other_transaction_fees_detail其他交易费明细string{"PaidServicesFee":-17483.70}必填其他交易费明细,所有未识别的明细汇总
7.48settlement_total亚马逊结算小结number-17483.7必填亚马逊结算小结
7.49purchase_costs_total采购成本number0必填采购成本
7.50logistics_costs_total头程成本number0必填头程成本
7.51other_costs_total其他成本number0必填其他成本
7.52gross_profit毛利润number-17483.7必填毛利润

领星ERP的接口:查询利润报表 - 订单(/bd/profit/report/open/report/order/list),由轻易云数据集成平台 API 资产管理模块整理收纳,并随领星ERP版本更新同步更新。

需要对接这个接口?

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