Lingxing
切换旧版

查询结算中心 - 交易明细

POST/bd/sp/api/open/settlement/transaction/detail/list

支持查询亚马逊结算中心内的交易明细

接口信息

API Path请求协议请求方式令牌桶容量
/bd/sp/api/open/settlement/transaction/detail/listHTTPSPOST10

请求参数

offsetinteger
分页偏移量
lengthinteger
分页长度,上限10000
countryCodesarray<any>
站点id
sidsarray<any>
店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】
startDatestring
开始时间【结算时间】,双闭区间,查询时间间隔不得超过7天,格式:Y-m-d
【无搜索值时,结算时间、修改时间二选一必填】
endDatestring
结束时间【结算时间】,双闭区间,查询时间间隔不得超过7天,格式:Y-m-d
【无搜索值时,结算时间、修改时间二选一必填】
eventTypestring
来源,多个英文用逗号隔开,枚举见附加说明
typestring
交易类型
searchFieldstring
搜索字段:
id 结算编号
amazon_order_id 订单编号
primary_id 主键编号【对应本接口返回id值】
settlement_id 账单编号【此项下,结算时间或更新时间必填】
searchValuearray<any>
搜索值
gmtModifiedStartstring
修改开始时间(北京时间),格式:Y-m-d H:i:s
【无搜索值时,结算时间、修改时间二选一必填】
gmtModifiedEndstring
修改结束时间(北京时间),格式:Y-m-d H:i:s
【无搜索值时,结算时间、修改时间二选一必填】

请求示例

{
    "offset": 0,
    "length": 20,
    "countryCodes": [
        1
    ],
    "sids": [
        136
    ],
    "startDate": "2023-09-24",
    "endDate": "2023-09-30",
    "eventType": "ShipmentEventList",
    "type": "Tax",
    "searchField": "id",
    "searchValue": [
        "LWCBG07Y55I3"
    ],
    "gmtModifiedStart": "2022-10-26 15:15:12",
    "gmtModifiedEnd": "2022-10-26 16:15:12"
}

返回结果

codeinteger必填
状态码,0 成功
示例 0
msgstring必填
返回信息
dataarray<object>必填
响应数据
隐藏子属性
recordsarray<object>必填
隐藏子属性
uniqueKeystring必填
交易明细唯一标识
备注:eventType=servicefeeeventlist时,uniqueKey会变动
amazonOrderIdstring必填
订单号
sidinteger必填
店铺id
storeNamestring必填
店铺名
sellerIdstring必填
亚马逊店铺id
countryCodestring必填
国家
accountTypestring必填
报告类型
fulfillmentstring必填
配送方式
eventTypestring必填
来源
备注:eventType=servicefeeeventlist时,uniqueKey会变动
sellerSkustring必填
MSKU
typestring必填
交易类型
postedDateLocalestring必填
结算时间(站点时间)
currencyCodestring必填
币种
currencyAmountnumber必填
金额
quantityinteger必填
数量
processingStatusstring必填
结算状态:
Open 未结算
Closed 已结算
Reconciled 已对账
fundTransferStatusstring必填
转账状态:
Succeeded 已转账
Processing 转账中
Failed 失败
Unknown 未知
fidstring必填
结算编号
settlementIdstring必填
settlement_id
localSkustring必填
sku
localNamestring必填
品名
idstring必填
主键编号【非唯一键】
gmtModifiedstring必填
修改时间
sellerOrderIdstring必填
卖方为订单定义的标识符
marketplaceNamestring必填
市场名称
postedDatestring
结算日期
0时区
示例 2024-06-06T08:29:00Z
financialEventGroupIdstring
groupID
示例 2bc77df899a347861b669e3b
fnskustring
FNSKU
示例 X00000STB1
orderItemIdstring
订单项ID
示例 40667527236852
merchantOrderIdstring
商家订单ID
示例 100119933999
md5string
MD5
示例 4fe4d6bb8d6b2b728f97acd9b11de94f
companyIdinteger
公司ID
示例 1039287
gmtCreatestring
创建时间
示例 2024-06-05 11:22:33
level1string
层级1
示例 一级分类
asinstring
ASIN
示例 B00EXAMPLE
level2string
层级2
示例 二级分类
promotionIdstring
促销ID
示例 PRM202406
dealIdstring
交易ID
示例 DEAL12345
feeTypestring
费用类型
示例 ShippingFee
dealDescriptionstring
交易描述
示例 订单退款
invoiceIdstring
发票ID
示例 INV202406
transactionTypestring
交易类型
示例 Refund
feeDescriptionstring
费用描述
示例 运费
feeReasonstring
费用原因
示例 活动促销
couponIdstring
优惠券ID
示例 QP123456
sellerCouponDescriptionstring
卖家优惠券描述
示例 满减优惠券
clipOrRedemptionCountinteger
剪辑或兑换计数
示例 2
paymentEventIdstring
支付事件ID
示例 PMT67890
enrollmentIdstring
注册ID
示例 ENR202406
parentAsinstring
父ASIN
示例 B00PARENT123
debtRecoveryTypestring
债务恢复类型
示例 DebtRecoveryTypeA
groupBeginDatestring
组开始日期
已废弃
示例 2024-06-01
groupEndDatestring
组结束日期
已废弃
示例 2024-06-07
orderIdstring
订单ID
示例 ORDER202406
removalShipmentItemIdstring
移除货件项ID
示例 RS12345
taxCollectionModelstring
税收模型
示例 MarketplaceFacilitator
taxWithholdingPeriodStartDatestring
预扣税期间开始日期
已废弃
示例 2024-06-01
taxWithholdingPeriodEndDatestring
预扣税期间结束日期
已废弃
示例 2024-06-05
netCoTransactionIdstring
净CO交易ID
示例 NCOTID123
swapReasonstring
交换原因
示例 换货
marketplaceIdstring
市场ID
示例 A1F83G8C2ARO7P
adjustmentEventIdstring
调整事件ID
示例 ADJ7890
safeTClaimIdstring
SafeT索赔ID
示例 STC202406
reasonCodestring
原因代码
示例 REASON123
productDescriptionstring
产品描述
示例 产品描述信息
sourceBusinessEventTypestring
源业务事件类型
示例 EVENT_TYPE_A
businessObjectTypestring
业务对象类型
示例 Order
amountDescriptionstring
金额描述
示例 实收金额
level1Indexinteger
层级1索引
示例 1
level2Indexinteger
层级2索引
示例 2
totalinteger必填
总数
示例 1335

返回成功示例

{
    "code": 0,
    "msg": null,
    "data": {
        "records": [
            {
                "uniqueKey": "",
                "amazonOrderId": "202-6458758-1434760",
                "sid": 8,
                "storeName": "JHL-Official-02",
                "countryCode": "UK",
                "accountType": "Standard",
                "fulfillment": "FBA",
                "eventType": "Shipment",
                "sellerId": "xxxxxxxxxxxxxxxx",
                "sellerSku": "1160U1139-A",
                "type": "Commission",
                "postedDateLocale": "2022-09-10T23:55:12+01:00",
                "currencyCode": "GBP",
                "currencyAmount": "-1.93",
                "quantity": 1,
                "processingStatus": "Closed",
                "fundTransferStatus": "Succeeded",
                "fid": "QA0DOY5ODNF8",
                "settlementId": "",
                "localSku": "",
                "localName": "",
                "id": "18327152",
                "gmtModified": "2022-09-11 07:06:37.401",
                "sellerOrderId": "",
                "marketplaceName": "Amazon.com",
                "postedDate": "2024-06-06T08:29:00Z",
                "financialEventGroupId": "2bc77df899a347861b669e3b",
                "fnsku": "X00000STB1",
                "orderItemId": "40667527236852",
                "merchantOrderId": "100119933999",
                "md5": "4fe4d6bb8d6b2b728f97acd9b11de94f",
                "companyId": 1039287,
                "gmtCreate": "",
                "level1": "一级分类",
                "asin": "B00EXAMPLE",
                "level2": "二级分类",
                "promotionId": "PRM202406",
                "dealId": "DEAL12345",
                "feeType": "ShippingFee",
                "dealDescription": "订单退款",
                "invoiceId": "INV202406",
                "transactionType": "Refund",
                "feeDescription": "运费",
                "feeReason": "活动促销",
                "couponId": "QP123456",
                "sellerCouponDescription": "满减优惠券",
                "clipOrRedemptionCount": 2,
                "paymentEventId": "PMT67890",
                "enrollmentId": "ENR202406",
                "parentAsin": "B00PARENT123",
                "debtRecoveryType": "DebtRecoveryTypeA",
                "groupBeginDate": "2024-06-01",
                "groupEndDate": "2024-06-07",
                "orderId": "ORDER202406",
                "removalShipmentItemId": "RS12345",
                "taxCollectionModel": "MarketplaceFacilitator",
                "taxWithholdingPeriodStartDate": "2024-06-01",
                "taxWithholdingPeriodEndDate": "2024-06-05",
                "netCoTransactionId": "NCOTID123",
                "swapReason": "换货",
                "marketplaceId": "A1F83G8C2ARO7P",
                "adjustmentEventId": "ADJ7890",
                "safeTClaimId": "STC202406",
                "reasonCode": "REASON123",
                "productDescription": "产品描述信息",
                "sourceBusinessEventType": "EVENT_TYPE_A",
                "businessObjectType": "Order",
                "amountDescription": "实收金额",
                "level1Index": 1,
                "level2Index": 2
            }
        ],
        "total": 1335
    }
}

附加说明

  1. eventType=servicefeeeventlist时,uniqueKey会变动
    建议拉取数据时,针对eventTpye=servicefeeeventlist类型的数据,把这个类型的数据作单独的删除与写入操作。
  2. 当账单处于closed状态时uniqueKey不会变化。

eventType字段枚举

来源传值
ShipmentShipmentEventList
RefundRefundEventList
GuranteeClaimGuranteeClaimEventList
ChargebackChargebackEventList
PayWithAmazonPayWithAmazonEventList
ServiceProviderCreditServiceProviderCreditEventList
RetrochargeRetrochargeEventList
RentalTransactionRentalTransactionEventList
ProductAdsPaymentProductAdsPaymentEventList
ServiceFeeServiceFeeEventList
SellerDealPaymentSellerDealPaymentEventList
DebtRecoveryDebtRecoveryEventList
LoanServicingLoanServicingEventList
AdjustmentAdjustmentEventList
SAFETReimbursementSAFETReimbursementEventList
SellerReviewEnrollmentSellerReviewEnrollmentEventList
FBALiquidationFBALiquidationEventList
CouponPaymentCouponPaymentEventList
ImagingServicesFeeImagingServicesFeeEventList
NetworkComminglingTransactionNetworkComminglingTransactionEventList
AffordabilityExpenseAffordabilityExpenseEventList
AffordabilityExpenseReversalAffordabilityExpenseReversalEventList
RemovalShipmentRemovalShipmentEventList