查询结算中心 - 交易明细
POST
/bd/sp/api/open/settlement/transaction/detail/list支持查询亚马逊结算中心内的交易明细
接口信息
| API Path | 请求协议 | 请求方式 | 令牌桶容量 |
|---|---|---|---|
/bd/sp/api/open/settlement/transaction/detail/list | HTTPS | POST | 10 |
请求参数
offsetintegerlengthintegercountryCodesarray<any>sidsarray<any>startDatestringendDatestringeventTypestringtypestringsearchFieldstringsearchValuearray<any>gmtModifiedStartstringgmtModifiedEndstring请求示例
{
"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必填msgstring必填dataarray<object>必填隐藏子属性
recordsarray<object>必填隐藏子属性
uniqueKeystring必填amazonOrderIdstring必填sidinteger必填storeNamestring必填sellerIdstring必填countryCodestring必填accountTypestring必填fulfillmentstring必填eventTypestring必填sellerSkustring必填typestring必填postedDateLocalestring必填currencyCodestring必填currencyAmountnumber必填quantityinteger必填processingStatusstring必填fundTransferStatusstring必填fidstring必填settlementIdstring必填localSkustring必填localNamestring必填idstring必填gmtModifiedstring必填sellerOrderIdstring必填marketplaceNamestring必填postedDatestringfinancialEventGroupIdstringfnskustringorderItemIdstringmerchantOrderIdstringmd5stringcompanyIdintegergmtCreatestringlevel1stringasinstringlevel2stringpromotionIdstringdealIdstringfeeTypestringdealDescriptionstringinvoiceIdstringtransactionTypestringfeeDescriptionstringfeeReasonstringcouponIdstringsellerCouponDescriptionstringclipOrRedemptionCountintegerpaymentEventIdstringenrollmentIdstringparentAsinstringdebtRecoveryTypestringgroupBeginDatestringgroupEndDatestringorderIdstringremovalShipmentItemIdstringtaxCollectionModelstringtaxWithholdingPeriodStartDatestringtaxWithholdingPeriodEndDatestringnetCoTransactionIdstringswapReasonstringmarketplaceIdstringadjustmentEventIdstringsafeTClaimIdstringreasonCodestringproductDescriptionstringsourceBusinessEventTypestringbusinessObjectTypestringamountDescriptionstringlevel1Indexintegerlevel2Indexintegertotalinteger必填返回成功示例
{
"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
}
}
附加说明
- eventType=servicefeeeventlist时,uniqueKey会变动
建议拉取数据时,针对eventTpye=servicefeeeventlist类型的数据,把这个类型的数据作单独的删除与写入操作。 - 当账单处于closed状态时uniqueKey不会变化。
eventType字段枚举
| 来源 | 传值 |
|---|---|
| Shipment | ShipmentEventList |
| Refund | RefundEventList |
| GuranteeClaim | GuranteeClaimEventList |
| Chargeback | ChargebackEventList |
| PayWithAmazon | PayWithAmazonEventList |
| ServiceProviderCredit | ServiceProviderCreditEventList |
| Retrocharge | RetrochargeEventList |
| RentalTransaction | RentalTransactionEventList |
| ProductAdsPayment | ProductAdsPaymentEventList |
| ServiceFee | ServiceFeeEventList |
| SellerDealPayment | SellerDealPaymentEventList |
| DebtRecovery | DebtRecoveryEventList |
| LoanServicing | LoanServicingEventList |
| Adjustment | AdjustmentEventList |
| SAFETReimbursement | SAFETReimbursementEventList |
| SellerReviewEnrollment | SellerReviewEnrollmentEventList |
| FBALiquidation | FBALiquidationEventList |
| CouponPayment | CouponPaymentEventList |
| ImagingServicesFee | ImagingServicesFeeEventList |
| NetworkComminglingTransaction | NetworkComminglingTransactionEventList |
| AffordabilityExpense | AffordabilityExpenseEventList |
| AffordabilityExpenseReversal | AffordabilityExpenseReversalEventList |
| RemovalShipment | RemovalShipmentEventList |