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 · 请求参数 19 个(必填 5) · 响应参数 35 个 · 限流令牌桶容量 1
Updated At
2026-11-21

Walmart - 查询回款明细列表

POST/basicOpen/multiplatformFinance/walmart/bill/payout/list
Factory
{
  "operation": {
    "method": "POST",
    "path": "/basicOpen/multiplatformFinance/walmart/bill/payout/list"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 1,
    "text": ""
  },
  "requestExample": "curl --location 'https://openapi.lingxing.com/basicOpen/multiplatformFinance/walmart/bill/payout/list?access_token=value&timestamp=value&sign=value&app_key=value' \\\n--header 'Content-Type: application/json' \\\n--data '{\n  \"offset\": 0,\n  \"length\": 20,\n  \"sids\": [123456],\n  \"siteCodes\": [\"US\"],\n  \"startDate\": \"2026-01-01\",\n  \"endDate\": \"2026-01-31\",\n  \"searchType\": 1,\n  \"searchSingleValue\": \"RPT-202601\",\n  \"sortField\": \"payoutDate\",\n  \"sortType\": \"0\"\n}'",
  "responseExample": {
    "code": 0,
    "message": "success",
    "error_details": [],
    "request_id": "a0d54debf93140f3b58d1ed81e8e3583",
    "response_time": "2026-05-25 12:00:00",
    "data": {
      "list": [
        {
          "companyId": 10001,
          "currency": "USD",
          "currencyIcon": "$",
          "id": 100001,
          "periodEndDate": "2026-01-31",
          "periodRange": "2026-01-01 ~ 2026-01-31",
          "periodStartDate": "2026-01-01",
          "platformCode": "walmart",
          "reportKey": "RPT-202601",
          "settlementCount": 18,
          "settlementDifference": 0,
          "site": "US",
          "siteCode": "US",
          "siteDisplay": "美国",
          "storeId": 123456,
          "storeName": "Walmart US Store",
          "totalPayable": 1250.3,
          "transactionDescription": "Settlement",
          "transactionPostedTimestamp": "2026-01-31 12:00:00",
          "transactionType": "Payout"
        }
      ],
      "totalCount": 1,
      "totalSum": {
        "currency": "USD",
        "currencyIcon": "$",
        "settlementCount": 18,
        "settlementDifference": 0,
        "totalCount": 1,
        "totalPayable": 1250.3
      }
    }
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1compareLogic字段比较条件逻辑关系string—Optional字段比较条件逻辑关系,默认 AND AND:且 OR:或
2currencyCode目标货币代码string—Optional目标货币代码
3endDate结束时间string—Optional结束时间,格式:yyyy-MM-dd
4fieldCompares字段比较条件列表array<object>—Optional字段比较条件列表
4.1field比较字段名称string—Required比较字段名称
4.2operator比较操作符string—Required比较操作符
4.3value比较值number—Required比较值
5hasDifference是否有差额boolean—Optional是否有差额
6length分页大小integer—Required分页大小,默认 20,最大 200
7offset分页偏移量integer—Required分页偏移量,默认 0
8searchExactly是否精确匹配boolean—Optional是否精确匹配
9searchMultiValue多个搜索值array<any>—Optional多个搜索值,精确匹配时使用
10searchSingleValue单个搜索值string—Optional单个搜索值
11searchType搜索类型integer—Optional搜索类型 1:账期ID(reportKey)
12sids店铺ID数组array<any>—Optional店铺ID数组
13siteCodes站点代码数组array<any>—Optional站点代码数组
14sortField排序字段string—Optional排序字段
15sortType排序方向string—Optional排序方向 1:升序 0:降序
16startDate开始时间string—Optional开始时间,格式:yyyy-MM-dd

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.1companyId公司IDinteger10001Required公司ID
6.1.2currency币种stringUSDRequired币种
6.1.3currencyIcon币种图标string$Required币种图标
6.1.4id主键IDinteger100001Required主键ID
6.1.5periodEndDate账期结束日期string2026-01-31Required账期结束日期
6.1.6periodRange账期时间范围string2026-01-01 ~ 2026-01-31Required账期时间范围
6.1.7periodStartDate账期开始日期string2026-01-01Required账期开始日期
6.1.8platformCode平台码stringwalmartRequired平台码
6.1.9reportKey账期ID/报告唯一键stringRPT-202601Required账期ID/报告唯一键
6.1.10settlementCount结算条数integer18Required结算条数
6.1.11settlementDifference结算明细差额number0Required结算明细差额
6.1.12site站点代码stringUSRequired站点代码
6.1.13siteCode站点代码stringUSRequired站点代码
6.1.14siteDisplay站点中文展示string美国Required站点中文展示
6.1.15storeId店铺IDinteger123456Required店铺ID
6.1.16storeName店铺名stringWalmart US StoreRequired店铺名
6.1.17totalPayable结算金额number1250.3Required结算金额
6.1.18transactionDescription交易说明stringSettlementRequired交易说明
6.1.19transactionPostedTimestamp结算时间string2026-01-31 12:00:00Required结算时间
6.1.20transactionType交易类型stringPayoutRequired交易类型
6.2totalCount总记录数integer1Required总记录数
6.3totalSum汇总数据object—Required汇总数据
6.3.1currency货币代码stringUSDRequired货币代码
6.3.2currencyIcon货币图标string$Required货币图标
6.3.3settlementCount结算条数汇总integer18Required结算条数汇总
6.3.4settlementDifference结算明细差额汇总number0Required结算明细差额汇总
6.3.5totalCount总记录数integer1Required总记录数
6.3.6totalPayable结算金额汇总number1250.3Required结算金额汇总

The Walmart - 查询回款明细列表 API (/basicOpen/multiplatformFinance/walmart/bill/payout/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.