Lingxing
切换旧版

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

POST/erp/sc/data/mws_report/transaction

查询领星插件下载的 Transaction 报表数据 >本接口即将下线，建议使用查询结算中心 - 交易明细

接口信息

API Path请求协议请求方式令牌桶容量
/erp/sc/data/mws_report/transactionHTTPSPOST1

请求参数

sidinteger必填
店铺id ，对应查询亚马逊店铺列表接口对应字段【sid】
event_datestring必填
报表日期，格式：Y-m-d【每月３日后支持查询上月数据】
offsetinteger
分页偏移量，默认0
lengthinteger
分页长度，默认1000

请求示例

{
    "sid": 109,
    "event_date": "2020-06-07",
    "offset": 0,
    "length": 1000
}

返回结果

Json Object

codeinteger必填
状态码，0 成功
示例 0
messagestring必填
消息提示
示例 success
error_detailsarray<any>必填
错误信息
request_idstring必填
请求链路id
示例 2C1A1C68-395F-C1A0-5639-9AF0A5BE08A4
response_timestring必填
响应时间
示例 2020-05-18 11:23:47
dataarray<object>必填
响应数据
隐藏子属性
sidinteger必填
店铺id
示例 1
is_to_binteger必填
是否为B2B订单：0 否【2c】，1 是
示例 0
report_date_monthstring必填
client_task的月份
示例 2019-03
report_indexinteger必填
报表行索引
date_strstring必填
原本的日期字符串
示例 1 Mar 2019 00:00:45 GMT+00:00
date_localestring必填
当地日期
示例 2019-03-01
date_isostring必填
ISO时间
示例 2019-03-01T00:00:45+00:00
settlement_idstring必填
结算编号
示例 11376876372
typeinteger必填
类型：
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
示例 1
type_strstring必填
类型说明
order_idstring必填
订单号
示例 205-0598548-1768342
skustring必填
SKU
示例 4H-3NL6-GL1I
descriptionstring必填
商品描述
quantitynumber必填
商品数量
示例 1
marketplacestring必填
销售市场
示例 amazon.co.uk
fulfillmentstring必填
发货方式
示例 Amazon
order_citystring必填
城市
示例 MIDDLESBROUGH
order_statestring必填
州
示例 Cleveland
order_postalstring必填
邮编
示例 TS6 9JN
product_salesstring必填
销售价格
示例 12.4900
product_sales_taxstring必填
销售税
currencystring必填
币种
示例 USD
shipping_creditsstring必填
运费
示例 1.8700
shipping_credits_taxstring
运费税（荷兰，瑞典，沙特，阿联酋无该税费）
gift_wrap_creditsstring必填
礼品包装费
示例 0.0000
gift_wrap_credits_taxstring
礼品包装税（荷兰，瑞典，沙特，阿联酋无该税费）
promotional_rebatesstring必填
促销返点
示例 -1.8700
promotional_rebates_taxstring
促销返点税（荷兰，瑞典，沙特，阿联酋无该税费）
sales_tax_collectedstring
销售税（仅荷兰，瑞典，沙特，阿联酋有该税费）
示例 0.0000
marketplace_facilitator_taxstring必填
市场税
示例 0.0000
selling_feesstring必填
平台费（佣金）
示例 -2.2500
fba_feesstring必填
FBA发货费
示例 -2.1700
other_transaction_feesstring必填
其他交易费
示例 0.0000
otherstring必填
其他费
示例 0.0000
totalstring必填
总计
示例 10.5700

返回成功示例

{
    "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
}