/basicOpen/multiplatformFinance/walmart/bill/payout/list{
"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×tamp=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
}
}
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | compareLogic | 字段比较条件逻辑关系 | string | — | Optional | 字段比较条件逻辑关系,默认 AND AND:且 OR:或 |
| 2 | currencyCode | 目标货币代码 | string | — | Optional | 目标货币代码 |
| 3 | endDate | 结束时间 | string | — | Optional | 结束时间,格式:yyyy-MM-dd |
| 4 | fieldCompares | 字段比较条件列表 | array<object> | — | Optional | 字段比较条件列表 |
| 4.1 | field | 比较字段名称 | string | — | Required | 比较字段名称 |
| 4.2 | operator | 比较操作符 | string | — | Required | 比较操作符 |
| 4.3 | value | 比较值 | number | — | Required | 比较值 |
| 5 | hasDifference | 是否有差额 | boolean | — | Optional | 是否有差额 |
| 6 | length | 分页大小 | integer | — | Required | 分页大小,默认 20,最大 200 |
| 7 | offset | 分页偏移量 | integer | — | Required | 分页偏移量,默认 0 |
| 8 | searchExactly | 是否精确匹配 | boolean | — | Optional | 是否精确匹配 |
| 9 | searchMultiValue | 多个搜索值 | array<any> | — | Optional | 多个搜索值,精确匹配时使用 |
| 10 | searchSingleValue | 单个搜索值 | string | — | Optional | 单个搜索值 |
| 11 | searchType | 搜索类型 | integer | — | Optional | 搜索类型 1:账期ID(reportKey) |
| 12 | sids | 店铺ID数组 | array<any> | — | Optional | 店铺ID数组 |
| 13 | siteCodes | 站点代码数组 | array<any> | — | Optional | 站点代码数组 |
| 14 | sortField | 排序字段 | string | — | Optional | 排序字段 |
| 15 | sortType | 排序方向 | string | — | Optional | 排序方向 1:升序 0:降序 |
| 16 | startDate | 开始时间 | string | — | Optional | 开始时间,格式:yyyy-MM-dd |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0:成功 |
| 2 | message | 消息提示 | string | success | Required | 消息提示 |
| 3 | error_details | 数据校验失败时的错误详情 | array<any> | — | Required | 数据校验失败时的错误详情 |
| 4 | request_id | 请求链路id | string | a0d54debf93140f3b58d1ed81e8e3583 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2026-05-25 12:00:00 | Required | 响应时间 |
| 6 | data | 响应数据 | object | — | Required | 响应数据 |
| 6.1 | list | 列表数据 | array<object> | — | Required | 列表数据 |
| 6.1.1 | companyId | 公司ID | integer | 10001 | Required | 公司ID |
| 6.1.2 | currency | 币种 | string | USD | Required | 币种 |
| 6.1.3 | currencyIcon | 币种图标 | string | $ | Required | 币种图标 |
| 6.1.4 | id | 主键ID | integer | 100001 | Required | 主键ID |
| 6.1.5 | periodEndDate | 账期结束日期 | string | 2026-01-31 | Required | 账期结束日期 |
| 6.1.6 | periodRange | 账期时间范围 | string | 2026-01-01 ~ 2026-01-31 | Required | 账期时间范围 |
| 6.1.7 | periodStartDate | 账期开始日期 | string | 2026-01-01 | Required | 账期开始日期 |
| 6.1.8 | platformCode | 平台码 | string | walmart | Required | 平台码 |
| 6.1.9 | reportKey | 账期ID/报告唯一键 | string | RPT-202601 | Required | 账期ID/报告唯一键 |
| 6.1.10 | settlementCount | 结算条数 | integer | 18 | Required | 结算条数 |
| 6.1.11 | settlementDifference | 结算明细差额 | number | 0 | Required | 结算明细差额 |
| 6.1.12 | site | 站点代码 | string | US | Required | 站点代码 |
| 6.1.13 | siteCode | 站点代码 | string | US | Required | 站点代码 |
| 6.1.14 | siteDisplay | 站点中文展示 | string | 美国 | Required | 站点中文展示 |
| 6.1.15 | storeId | 店铺ID | integer | 123456 | Required | 店铺ID |
| 6.1.16 | storeName | 店铺名 | string | Walmart US Store | Required | 店铺名 |
| 6.1.17 | totalPayable | 结算金额 | number | 1250.3 | Required | 结算金额 |
| 6.1.18 | transactionDescription | 交易说明 | string | Settlement | Required | 交易说明 |
| 6.1.19 | transactionPostedTimestamp | 结算时间 | string | 2026-01-31 12:00:00 | Required | 结算时间 |
| 6.1.20 | transactionType | 交易类型 | string | Payout | Required | 交易类型 |
| 6.2 | totalCount | 总记录数 | integer | 1 | Required | 总记录数 |
| 6.3 | totalSum | 汇总数据 | object | — | Required | 汇总数据 |
| 6.3.1 | currency | 货币代码 | string | USD | Required | 货币代码 |
| 6.3.2 | currencyIcon | 货币图标 | string | $ | Required | 货币图标 |
| 6.3.3 | settlementCount | 结算条数汇总 | integer | 18 | Required | 结算条数汇总 |
| 6.3.4 | settlementDifference | 结算明细差额汇总 | number | 0 | Required | 结算明细差额汇总 |
| 6.3.5 | totalCount | 总记录数 | integer | 1 | Required | 总记录数 |
| 6.3.6 | totalPayable | 结算金额汇总 | number | 1250.3 | Required | 结算金额汇总 |
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.
Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.