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 · 请求参数 15 个(必填 3) · 响应参数 59 个 · 限流令牌桶容量 10
Updated At
2026-11-21

查询利润报表 - 订单

POST/bd/profit/report/open/report/order/list
Factory
{
  "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
      }
    ]
  }
}

Request Parameters

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

Response Parameters

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

The 查询利润报表 - 订单 API (/bd/profit/report/open/report/order/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.