Qeasy Cloud
Get Started

领星ERP Walmart - 查询结算账单列表 API

Platform
领星ERP
Type
WebAPI
Effect
QUERY
API Version
1.0
Adapter
\Adapter\LingXing\LXQueryAdapter
Auth Mode
OTHER
Description
多平台 / 财务 / Walmart财务 · POST · 请求参数 16 个(必填 2) · 响应参数 77 个 · 限流令牌桶容量 1
Updated At
2026-11-21

Walmart - 查询结算账单列表

POST/basicOpen/multiplatformFinance/walmart/bill/statement/list
Factory
{
  "operation": {
    "method": "POST",
    "path": "/basicOpen/multiplatformFinance/walmart/bill/statement/list"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 1,
    "text": ""
  },
  "requestExample": "curl --location 'https://openapi.lingxing.com/basicOpen/multiplatformFinance/walmart/bill/statement/list?access_token=value&timestamp=value&sign=value&app_key=value' \\\n--header 'Content-Type: application/json' \\\n--data '{\n  \"sids\": [],\n  \"amountTypes\": [],\n  \"currencyCode\": \"\",\n  \"fulfillmentTypes\": [],\n  \"transactionDescriptions\": [],\n  \"transactionTypes\": [\"Other\"],\n  \"startDate\": \"2026-01-01\",\n  \"endDate\": \"2026-06-29\",\n  \"offset\": 0,\n  \"length\": 20\n}'",
  "responseExample": {
    "code": 0,
    "message": "success",
    "error_details": [],
    "request_id": "a0d54debf93140f3b58d1ed81e8e3583",
    "response_time": "2026-05-25 12:00:00",
    "data": {
      "list": [
        {
          "amount": 35.5,
          "amountType": "Commission",
          "baseCommissionRate": 0.15,
          "campaignId": "C10001",
          "chargeSavings": 2,
          "commissionIncentiveProgram": "Incentive",
          "commissionRate": 0.12,
          "commissionRule": "Standard",
          "commissionSaving": 1.5,
          "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,
          "originalCommission": 6,
          "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.5,
          "totalWalmartFundedSavingsProgram": 3,
          "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.5,
        "chargeSavings": 2,
        "commissionSaving": 1.5,
        "currency": "USD",
        "currencyIcon": "$",
        "originalCharge": 10,
        "originalCommission": 6,
        "shipQty": 2,
        "totalCount": 1,
        "totalPayable": 120.5,
        "totalWalmartFundedSavingsProgram": 3
      }
    }
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1amountTypes金额类型数组array<any>—Optional金额类型数组
2currencyCode目标货币代码string—Optional目标货币代码
3endDate结束时间string—Optional结束时间,格式:yyyy-MM-dd
4fulfillmentTypes发货类型数组array<any>—Optional发货类型数组
5length分页大小integer—Required分页大小,默认 20,最大 200
6offset分页偏移量integer—Required分页偏移量,默认 0
7searchExactly是否精确匹配boolean—Optional是否精确匹配
8searchMultiValue多个搜索值array<any>—Optional多个搜索值,精确匹配时使用
9searchSingleValue单个搜索值string—Optional单个搜索值
10searchType搜索类型integer—Optional搜索类型 1:平台单号 2:客户单号 3:MSKU 4:GTIN 5:商品标题 6:账期ID
11sids店铺ID数组array<any>—Optional店铺ID数组,数组元素为查询多平台店铺信息接口返回的沃尔玛店铺 store_id
12sortField排序字段string—Optional排序字段
13sortType排序方向string—Optional排序方向 1:升序 0:降序
14startDate开始时间string—Optional开始时间,格式:yyyy-MM-dd
15transactionDescriptions交易描述数组array<any>—Optional交易描述数组
16transactionTypes交易类型数组array<any>—Optional交易类型数组 Sale Refund Campaigns Adjustment Service Fee Customer Fee Misc Adjustment Dispute Settlement Prepaid Prepaid Recouped Rewards Other

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer0Required状态码,0:成功
2message消息提示stringsuccessRequired消息提示
3error_details数据校验失败时的错误详情array<any>—Required数据校验失败时的错误详情
4request_id请求链路idstringa0d54debf93140f3b58d1ed81e8e3583Required请求链路id
5response_time响应时间string2026-05-25 12:00:00Required响应时间
6data响应数据object—Required响应数据
6.1list列表数据array<object>—Required列表数据
6.1.1amount金额number35.5Required金额
6.1.2amountType费用名称stringCommissionRequired费用名称
6.1.3baseCommissionRate基础佣金费率number0.15Required基础佣金费率
6.1.4campaignId广告活动IDstringC10001Required广告活动ID
6.1.5chargeSavings费用补贴number2Required费用补贴
6.1.6commissionIncentiveProgram平台激励项目stringIncentiveRequired平台激励项目
6.1.7commissionRate佣金费率number0.12Required佣金费率
6.1.8commissionRule佣金规则stringStandardRequired佣金规则
6.1.9commissionSaving佣金折扣number1.5Required佣金折扣
6.1.10companyId公司IDinteger10001Required公司ID
6.1.11contractCategory品类大类stringElectronicsRequired品类大类
6.1.12currency币种stringUSDRequired币种
6.1.13currencyIcon币种图标string$Required币种图标
6.1.14customerOrderLineNo客户子单号stringCOL-10001Required客户子单号
6.1.15customerOrderNo客户单号stringCO-10001Required客户单号
6.1.16customerPromoType卖家促销类型stringCouponRequired卖家促销类型
6.1.17deleteFlag删除标识integer0Required删除标识
6.1.18fulfillmentDetails发货说明stringWFS fulfillmentRequired发货说明
6.1.19fulfillmentType发货类型stringWFSRequired发货类型
6.1.20id主键IDinteger100001Required主键ID
6.1.21incentiveProgramName激励项目名称stringPro SellerRequired激励项目名称
6.1.22itemCondition商品属性stringNewRequired商品属性
6.1.23originalCharge费用原值number10Required费用原值
6.1.24originalCommission佣金原值number6Required佣金原值
6.1.25partnerGtinpartnerGtinstring00012345678905RequiredGTIN
6.1.26partnerItemIdpartnerItemIdstringMSKU-001RequiredMSKU
6.1.27partnerItemName商品标题stringWireless MouseRequired商品标题
6.1.28periodEndDate周期结束日期string2026-01-31Required周期结束日期
6.1.29periodStartDate周期开始日期string2026-01-01Required周期开始日期
6.1.30platformCode平台码stringwalmartRequired平台码
6.1.31productTaxCode商品税代码string2038710Required商品税代码
6.1.32productType品类小类stringMouseRequired品类小类
6.1.33purchaseOrderLineNo平台子单号stringPOL-10001Required平台子单号
6.1.34purchaseOrderNo平台单号stringPO-10001Required平台单号
6.1.35remark备注stringnormalRequired备注
6.1.36reportDate报告日期string2026-01-31Required报告日期
6.1.37reportId报告IDinteger90001Required报告ID
6.1.38reportKey报告唯一键stringRPT-202601Required报告唯一键
6.1.39shipQty发货量integer2Required发货量
6.1.40shipToCity收货城市stringLos AngelesRequired收货城市
6.1.41shipToCountry收货国stringUSRequired收货国
6.1.42shipToState收货省州stringCARequired收货省州
6.1.43shipToZipcode收货邮编string90001Required收货邮编
6.1.44shippingMethod发货方式stringStandardRequired发货方式
6.1.45site站点代码stringUSRequired站点代码
6.1.46siteCode站点stringUSRequired站点
6.1.47siteDisplay站点中文展示string美国Required站点中文展示
6.1.48storeId店铺IDinteger123456Required店铺ID
6.1.49storeName店铺名stringWalmart US StoreRequired店铺名
6.1.50totalPayable结算金额number120.5Required结算金额
6.1.51totalWalmartFundedSavingsProgram平台补贴number3Required平台补贴
6.1.52transactionDescription交易描述stringItem SaleRequired交易描述
6.1.53transactionKey结算IDstringTXN-10001Required结算ID
6.1.54transactionPostedTimestamp结算时间string2026-01-15 10:30:00Required结算时间
6.1.55transactionReasonDescription交易说明stringProduct chargeRequired交易说明
6.1.56transactionType交易类型stringSalesRequired交易类型
6.1.57uniqueNo唯一标识stringUNQ-10001Required唯一标识
6.2totalCount总记录数integer1Required总记录数
6.3totalSum汇总数据object—Required汇总数据
6.3.1amount交易金额汇总number35.5Required交易金额汇总
6.3.2chargeSavings收费节省汇总number2Required收费节省汇总
6.3.3commissionSaving佣金节省汇总number1.5Required佣金节省汇总
6.3.4currency货币代码stringUSDRequired货币代码
6.3.5currencyIcon货币图标string$Required货币图标
6.3.6originalCharge原始收费汇总number10Required原始收费汇总
6.3.7originalCommission原始佣金汇总number6Required原始佣金汇总
6.3.8shipQty发货数量汇总integer2Required发货数量汇总
6.3.9totalCount总记录数integer1Required总记录数
6.3.10totalPayable应付总额number120.5Required应付总额
6.3.11totalWalmartFundedSavingsProgramWalmart补贴总额number3RequiredWalmart补贴总额

The Walmart - 查询结算账单列表 API (/basicOpen/multiplatformFinance/walmart/bill/statement/list) of 领星ERP is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with 领星ERP version updates.

Need to integrate this API?

Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.