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

查询亚马逊源报表 - 交易明细

POST/erp/sc/data/mws_report/transaction
Factory
{
  "operation": {
    "method": "POST",
    "path": "/erp/sc/data/mws_report/transaction"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 1,
    "text": ""
  },
  "requestExample": {
    "sid": 109,
    "event_date": "2020-06-07",
    "offset": 0,
    "length": 1000
  },
  "responseExample": {
    "code": 0,
    "message": "success",
    "error_details": [],
    "request_id": "38AA9D9A-5936-FD62-9901-C415C1951111",
    "response_time": "2021-07-02 11:23:08",
    "data": [
      {
        "sid": 103,
        "is_to_b": 0,
        "report_date_month": "2021-05",
        "report_index": 736,
        "date_str": "May 31, 2021 11:56:23 AM PDT",
        "date_locale": "2021-05-31",
        "date_iso": "2021-05-31T11:56:23-07:00",
        "settlement_id": "142111161",
        "type": 1,
        "order_id": "113-1111111111111111-9121025",
        "sku": "200J",
        "description_str": "KOo",
        "quantity": 1,
        "marketplace": "amazon.com",
        "fulfillment": "Amazon",
        "order_city": "REDWOOD CITY",
        "order_state": "CA",
        "order_postal": "9401142",
        "product_sales": "19.9900",
        "currency": "USD",
        "shipping_credits": "0.0000",
        "shipping_credits_tax": "0.0000",
        "gift_wrap_credits": "0.0000",
        "gift_wrap_credits_tax": "0.0000",
        "promotional_rebates": "-10.0000",
        "promotional_rebates_tax": "0.0000",
        "sales_tax_collected": "0.0000",
        "marketplace_facilitator_tax": "-0.9700",
        "selling_fees": "-1.5000",
        "fba_fees": "-5.4200",
        "other_transaction_fees": "-0.7000",
        "other": "0.0000",
        "total": "2.3700",
        "description": "KORsy to",
        "type_str": "Order"
      },
      {
        "sid": 103,
        "is_to_b": 0,
        "report_date_month": "2021-05",
        "report_index": 741,
        "date_str": "May 31, 2021 2:00:44 PM PDT",
        "date_locale": "2021-05-31",
        "date_iso": "2021-05-31T14:00:44-07:00",
        "settlement_id": "1426581161",
        "type": 1,
        "order_id": "113-111111111111-5120241",
        "sku": "200J",
        "description_str": "KO",
        "quantity": 1,
        "marketplace": "amazon.com",
        "fulfillment": "Amazon",
        "order_city": "HOUSTON",
        "order_state": "TX",
        "order_postal": "77044-6581",
        "product_sales": "19.9900",
        "currency": "USD",
        "shipping_credits": "0.0000",
        "shipping_credits_tax": "0.0000",
        "gift_wrap_credits": "0.0000",
        "gift_wrap_credits_tax": "0.0000",
        "promotional_rebates": "0.0000",
        "promotional_rebates_tax": "0.0000",
        "sales_tax_collected": "0.0000",
        "marketplace_facilitator_tax": "-1.4500",
        "selling_fees": "-3.0000",
        "fba_fees": "-5.4200",
        "other_transaction_fees": "-1.4000",
        "other": "0.0000",
        "total": "10.1700",
        "description": "11111sy to",
        "type_str": "Order"
      }
    ],
    "total": 0
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1sid店铺idinteger—Required店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】
2event_date报表日期string—Required报表日期,格式:Y-m-d【每月3日后支持查询上月数据】
3offset分页偏移量integer—Optional分页偏移量,默认0
4length分页长度integer—Optional分页长度,默认1000

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer0Required状态码,0 成功
2message消息提示stringsuccessRequired消息提示
3error_details错误信息array<any>—Required错误信息
4request_id请求链路idstring2C1A1C68-395F-C1A0-5639-9AF0A5BE08A4Required请求链路id
5response_time响应时间string2020-05-18 11:23:47Required响应时间
6data响应数据array<object>—Required响应数据
6.1sid店铺idinteger1Required店铺id
6.2is_to_b是否为B2B订单integer0Required是否为B2B订单:0 否【2c】,1 是
6.3report_date_monthclient_task的月份string2019-03Requiredclient_task的月份
6.4report_index报表行索引integer—Required报表行索引
6.5date_str原本的日期字符串string1 Mar 2019 00:00:45 GMT+00:00Required原本的日期字符串
6.6date_locale当地日期string2019-03-01Required当地日期
6.7date_isoISO时间string2019-03-01T00:00:45+00:00RequiredISO时间
6.8settlement_id结算编号string11376876372Required结算编号
6.9type类型integer1Required类型: 1 ORDER 2 REFUND 3 ADJUSTMENT 4 A_TO_Z_GUARANTEE_CLAIM 5 CHARGEBACK_REFUND 6 FBA_INVENTORY_FEE 7 SERVICE_FEE 8 LIGHTNING_DEAL_FEE 9 TRANSFER 10 ORDER_RETROCHARGE 11 REFUND_RETROCHARGE 12 CHARGES_TO_CREDIT_CARD 13 FBA_CUSTOMER_RETURN_FEE 14 DEBT 15 NULL【其他类型】 16 FEE_ADJUSTMENT 17 LIQUIDATIONS 18 Shipping Services 19 Electronic Transactions 20 COD Transactions 21 Reimbursements 22 Tax Withheld 23 Liquidations Adjustments 24 PW Order Payment 25 PW Trial Shipment 26 Fulfilment Fee Refund 27 TBYB Order Payment 28 TBYB Trial Shipment
6.10type_str类型说明string—Required类型说明
6.11order_id订单号string205-0598548-1768342Required订单号
6.12skuskustring4H-3NL6-GL1IRequiredSKU
6.13description商品描述string—Required商品描述
6.14quantity商品数量number1Required商品数量
6.15marketplace销售市场stringamazon.co.ukRequired销售市场
6.16fulfillment发货方式stringAmazonRequired发货方式
6.17order_city城市stringMIDDLESBROUGHRequired城市
6.18order_state州stringClevelandRequired州
6.19order_postal邮编stringTS6 9JNRequired邮编
6.20product_sales销售价格string12.4900Required销售价格
6.21product_sales_tax销售税string—Required销售税
6.22currency币种stringUSDRequired币种
6.23shipping_credits运费string1.8700Required运费
6.24shipping_credits_tax运费税(荷兰string—Optional运费税(荷兰,瑞典,沙特,阿联酋无该税费)
6.25gift_wrap_credits礼品包装费string0.0000Required礼品包装费
6.26gift_wrap_credits_tax礼品包装税(荷兰string—Optional礼品包装税(荷兰,瑞典,沙特,阿联酋无该税费)
6.27promotional_rebates促销返点string-1.8700Required促销返点
6.28promotional_rebates_tax促销返点税(荷兰string—Optional促销返点税(荷兰,瑞典,沙特,阿联酋无该税费)
6.29sales_tax_collected销售税(仅荷兰string0.0000Optional销售税(仅荷兰,瑞典,沙特,阿联酋有该税费)
6.30marketplace_facilitator_tax市场税string0.0000Required市场税
6.31selling_fees平台费(佣金)string-2.2500Required平台费(佣金)
6.32fba_feesFBA发货费string-2.1700RequiredFBA发货费
6.33other_transaction_fees其他交易费string0.0000Required其他交易费
6.34other其他费string0.0000Required其他费
6.35total总计string10.5700Required总计

The 查询亚马逊源报表 - 交易明细 API (/erp/sc/data/mws_report/transaction) 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.