Walmart - 查询结算账单列表
POST
/basicOpen/multiplatformFinance/walmart/bill/statement/listWalmart-查询结算账单列表，支持按订单、商品、账期、交易类型、金额类型和时间范围查询 Walmart 结算账单明细。
接口信息
| API Path | 请求协议 | 请求方式 | 令牌桶容量 |
|---|---|---|---|
/basicOpen/multiplatformFinance/walmart/bill/statement/list | HTTPS | POST | 1 |
请求参数
amountTypesarray<any>currencyCodestringendDatestringfulfillmentTypesarray<any>lengthinteger必填offsetinteger必填searchExactlybooleansearchMultiValuearray<any>searchSingleValuestringsearchTypeintegersidsarray<any>sortFieldstringsortTypestringstartDatestringtransactionDescriptionsarray<any>transactionTypesarray<any>请求cURL示例
curl --location 'https://openapi.lingxing.com/basicOpen/multiplatformFinance/walmart/bill/statement/list?access_token=value×tamp=value&sign=value&app_key=value' \
--header 'Content-Type: application/json' \
--data '{
"sids": [],
"amountTypes": [],
"currencyCode": "",
"fulfillmentTypes": [],
"transactionDescriptions": [],
"transactionTypes": ["Other"],
"startDate": "2026-01-01",
"endDate": "2026-06-29",
"offset": 0,
"length": 20
}'返回结果
JSON Object
codeinteger必填messagestring必填error_detailsarray<any>必填request_idstring必填response_timestring必填dataobject必填隐藏子属性
listarray<object>必填隐藏子属性
amountnumber必填amountTypestring必填baseCommissionRatenumber必填campaignIdstring必填chargeSavingsnumber必填commissionIncentiveProgramstring必填commissionRatenumber必填commissionRulestring必填commissionSavingnumber必填companyIdinteger必填contractCategorystring必填currencystring必填currencyIconstring必填customerOrderLineNostring必填customerOrderNostring必填customerPromoTypestring必填deleteFlaginteger必填fulfillmentDetailsstring必填fulfillmentTypestring必填idinteger必填incentiveProgramNamestring必填itemConditionstring必填originalChargenumber必填originalCommissionnumber必填partnerGtinstring必填partnerItemIdstring必填partnerItemNamestring必填periodEndDatestring必填periodStartDatestring必填platformCodestring必填productTaxCodestring必填productTypestring必填purchaseOrderLineNostring必填purchaseOrderNostring必填remarkstring必填reportDatestring必填reportIdinteger必填reportKeystring必填shipQtyinteger必填shipToCitystring必填shipToCountrystring必填shipToStatestring必填shipToZipcodestring必填shippingMethodstring必填sitestring必填siteCodestring必填siteDisplaystring必填storeIdinteger必填storeNamestring必填totalPayablenumber必填totalWalmartFundedSavingsProgramnumber必填transactionDescriptionstring必填transactionKeystring必填transactionPostedTimestampstring必填transactionReasonDescriptionstring必填transactionTypestring必填uniqueNostring必填totalCountinteger必填totalSumobject必填隐藏子属性
amountnumber必填chargeSavingsnumber必填commissionSavingnumber必填currencystring必填currencyIconstring必填originalChargenumber必填originalCommissionnumber必填shipQtyinteger必填totalCountinteger必填totalPayablenumber必填totalWalmartFundedSavingsProgramnumber必填返回成功示例
{
"code": 0,
"message": "success",
"error_details": [],
"request_id": "a0d54debf93140f3b58d1ed81e8e3583",
"response_time": "2026-05-25 12:00:00",
"data": {
"list": [
{
"amount": 35.50,
"amountType": "Commission",
"baseCommissionRate": 0.15,
"campaignId": "C10001",
"chargeSavings": 2.00,
"commissionIncentiveProgram": "Incentive",
"commissionRate": 0.12,
"commissionRule": "Standard",
"commissionSaving": 1.50,
"companyId": 10001,
"contractCategory": "Electronics",
"currency": "USD",
"currencyIcon": "$",
"customerOrderLineNo": "COL-10001",
"customerOrderNo": "CO-10001",
"customerPromoType": "Coupon",
"deleteFlag": 0,
"fulfillmentDetails": "WFS fulfillment",
"fulfillmentType": "WFS",
"id": 100001,
"incentiveProgramName": "Pro Seller",
"itemCondition": "New",
"originalCharge": 10.00,
"originalCommission": 6.00,
"partnerGtin": "00012345678905",
"partnerItemId": "MSKU-001",
"partnerItemName": "Wireless Mouse",
"periodEndDate": "2026-01-31",
"periodStartDate": "2026-01-01",
"platformCode": "walmart",
"productTaxCode": "2038710",
"productType": "Mouse",
"purchaseOrderLineNo": "POL-10001",
"purchaseOrderNo": "PO-10001",
"remark": "normal",
"reportDate": "2026-01-31",
"reportId": 90001,
"reportKey": "RPT-202601",
"shipQty": 2,
"shipToCity": "Los Angeles",
"shipToCountry": "US",
"shipToState": "CA",
"shipToZipcode": "90001",
"shippingMethod": "Standard",
"site": "US",
"siteCode": "US",
"siteDisplay": "美国",
"storeId": 123456,
"storeName": "Walmart US Store",
"totalPayable": 120.50,
"totalWalmartFundedSavingsProgram": 3.00,
"transactionDescription": "Item Sale",
"transactionKey": "TXN-10001",
"transactionPostedTimestamp": "2026-01-15 10:30:00",
"transactionReasonDescription": "Product charge",
"transactionType": "Sales",
"uniqueNo": "UNQ-10001"
}
],
"totalCount": 1,
"totalSum": {
"amount": 35.50,
"chargeSavings": 2.00,
"commissionSaving": 1.50,
"currency": "USD",
"currencyIcon": "$",
"originalCharge": 10.00,
"originalCommission": 6.00,
"shipQty": 2,
"totalCount": 1,
"totalPayable": 120.50,
"totalWalmartFundedSavingsProgram": 3.00
}
}
}