查询利润报表 - 订单维度transaction视图
POST
/basicOpen/finance/profitReport/order/transcation/list接口信息
| API Path | 请求协议 | 请求方式 | 令牌桶容量 |
|---|---|---|---|
/basicOpen/finance/profitReport/order/transcation/list | HTTPS | POST | 1 |
请求参数
offsetintegerlengthintegermidsarray<any>sidsarray<any>searchDateFieldstringstartDatestring必填endDatestring必填gmtModifiedStartDatestringgmtModifiedEndDatestringcurrencyCodestringsearchFieldstringsearchValuearray<any>sortFieldstringsortTypestringsettlementStatusarray<any>fundTransferStatusarray<any>accountTypearray<any>eventSourcearray<any>fulfillmentarray<any>principalUidsarray<any>productDeveloperUidsarray<any>orderStatusstring请求示例
{
"offset": 0,
"length": 20,
"mids": [1,2],
"sids": [124,123],
"startDate": "2022-12-31",
"endDate": "2023-03-01",
"currencyCode": "USD",
"searchField": "order_id",
"searchValue": ["xxxx"],
"sortField": "postedDatetimeLocale",
"sortType": "desc",
"settlementStatus": ["Closed"],
"fundTransferStatus": ["Succeeded"],
"searchDateField": "posted_date_locale",
"accountType": ["Standard"],
"eventSource": ["Service Fee"],
"fulfillment": ["FBA"],
"principalUids": [106160],
"productDeveloperUids": [1],
"gmtModifiedStartDate": "2024-09-01 12:00:00",
"gmtModifiedEndDate": "2024-09-01 14:00:00",
"orderStatus": "Deferred",
"transactionStatus": [
"Disbursed",
"PreSettlement"
]
}返回结果
Json Object
codenumber必填messagestring必填error_detailsarray<any>必填request_idstring必填response_timestring必填dataobject必填隐藏子属性
recordsarray<object>必填隐藏子属性
idstring必填bizIdstring必填bizIdRowIndexnumber必填sidstring必填transactionIdstringstoreNamestring必填countrystring必填countryCodestring必填postedDatetimeLocalestring必填settlementStatusstring必填orderIdstring必填fulfillmentstring必填orderDatetimeLocalestring必填paymentDatetimeLocalestring必填shipmentDatetimeLocalestring必填fundTransferDatetimeLocalestring必填fundTransferStatusstring必填gmtModifiedstring必填accountTypestring必填eventSourcestring必填settlementIdstring必填fidstring必填smallImageUrlstring必填mskustring必填fnskustring必填asinstring必填parentAsinstring必填localNamestring必填localSkustring必填descriptionstring必填quantitynumber必填principalRealnamestring必填productDeveloperRealnamestring必填currencyCodestring必填currencyIconstring必填productSalesnumber必填productSalesTaxnumber必填shippingCreditsnumber必填shippingCreditsTaxnumber必填giftwrapCreditsnumber必填giftwrapCreditsTaxnumber必填amazonPointFeenumber必填promotionalRebatesnumber必填promotionalRebatesTaxnumber必填salesTaxCollectednumber必填lowValueGoodsnumber必填marketplaceWithheldTaxnumber必填tcsCgstnumber必填tcsSgstnumber必填tcsIgstnumber必填sellingFeesnumber必填fbaFeesnumber必填otherTransactionFeesnumber必填othernumber必填hiddenTaxnumber必填settlementTotalnumber必填purchaseCostsTotalnumber必填logisticsCostsTotalnumber必填otherCostsTotalnumber必填customOrderFeeTotalnumber必填settlementGrossProfitnumber必填settlementGrossProfitRatenumber必填promotionIdstring必填transactionStatusstring必填transactionStatusCodestring必填deferredSubStatusstring必填deferredSubStatusCodestring必填shipPromotionDiscountnumber必填itemPromotionDiscountnumber必填odsEventTypestring必填rowIndexnumber必填accountingTimestring必填totalnumber必填totalnumber必填返回成功示例
{
"code": 0,
"message": "success",
"error_details": [],
"request_id": "f898c15c933b40639f2250f96d9755be.1741745537314",
"response_time": "2025-03-12 10:12:18",
"data": {
"records": [
{
"id": "113221103598719651224501253105676405764357882259729528092821266977197534979600",
"bizId": "113221103598719651224501253105676405764357882259729528092821266977197534979600",
"bizIdRowIndex": 0,
"sid": "136",
"transactionId": "22dd24b86a464cf2a7541252dc462587.1760926323389",
"storeName": "韧啸-US",
"country": "美国",
"countryCode": "US",
"postedDatetimeLocale": "2024-11-13 01:24:24",
"settlementStatus": "Closed",
"orderId": "",
"fulfillment": "",
"orderDatetimeLocale": "",
"paymentDatetimeLocale": "",
"shipmentDatetimeLocale": "",
"fundTransferDatetimeLocale": "2024-11-18 23:29:21",
"fundTransferStatus": "Unknown",
"gmtModified": "2025-01-31 09:50:43",
"accountType": "Standard",
"eventSource": "FBA Inventory Fee",
"settlementId": "21164053811",
"fid": "QA0DQPFT4NVX",
"smallImageUrl": null,
"msku": "",
"fnsku": "",
"asin": "",
"parentAsin": "",
"localName": null,
"localSku": null,
"description": "FBA Inbound Transportation Fee",
"quantity": 0,
"principalRealname": null,
"productDeveloperRealname": null,
"currencyCode": "USD",
"currencyIcon": "$",
"productSales": 0.00,
"productSalesTax": 0.00,
"shippingCredits": 0.00,
"shippingCreditsTax": 0.00,
"giftwrapCredits": 0.00,
"giftwrapCreditsTax": 0.00,
"amazonPointFee": 0.00,
"promotionalRebates": 0.00,
"promotionalRebatesTax": 0.00,
"salesTaxCollected": 0.00,
"lowValueGoods": 0.00,
"marketplaceWithheldTax": 0.00,
"tcsCgst": 0.00,
"tcsSgst": 0.00,
"tcsIgst": 0.00,
"sellingFees": 0.00,
"fbaFees": 0.00,
"otherTransactionFees": 0.00,
"other": -7.64,
"hiddenTax": 0.00,
"settlementTotal": -7.64,
"purchaseCostsTotal": 0.00,
"logisticsCostsTotal": 0.00,
"otherCostsTotal": 0.00,
"customOrderFeeTotal": 0.00,
"settlementGrossProfit": -7.64,
"settlementGrossProfitRate": 0.0000,
"promotionId": "",
"transactionStatus": "已发放",
"transactionStatusCode": "Disbursed",
"shipPromotionDiscount": null,
"itemPromotionDiscount": null,
"odsEventType": "ServiceFeeEventList",
"rowIndex": 0
}
],
"total": 1
},
"total": 0
}