/bd/sp/api/open/monthly/receivable/report/list{
"operation": {
"method": "POST",
"path": "/bd/sp/api/open/monthly/receivable/report/list"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": {
"sids": [
109,
123
],
"mids": [
1
],
"currencyCode": "US",
"archiveStatus": "0",
"settleMonth": "2023-01",
"sortField": "beginningBalanceCurrencyAmount",
"sortType": "desc",
"receivedState": 1,
"offset": 0,
"length": 20
},
"responseExample": {
"code": 0,
"data": [
{
"storeName": "8P-US-2024",
"sid": 109,
"country": "美国",
"countryCode": "US",
"settlementDate": "2023-01",
"archiveStatus": 0,
"archiveStatusName": "未对账",
"currencyCode": "USD",
"currencyIcon": "$",
"beginningBalanceCurrencyAmount": -39.99,
"incomeAmount": 0,
"refundAmount": 0,
"spendAmount": -41.47,
"other": 40.03,
"card": 40.03,
"otherItem": 0,
"convertedSuccessAmount": 0,
"convertedFailedAmount": 0,
"receivedAmount": 0,
"endingBalance": -41.43,
"remark": null
}
],
"response_time": "2024-04-03 11:11:43",
"total": 9,
"error_details": [],
"message": "操作成功",
"request_id": "eca49f3b-0b81-4cbc-a08c-de6e11420190.1712113903371"
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | sids | 店铺id | array<any> | — | Optional | 店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】 |
| 2 | mids | 国家id | array<any> | — | Optional | 国家id |
| 3 | currencyCode | 币种code | string | — | Optional | 币种code |
| 4 | archiveStatus | 对账状态 | integer | — | Optional | 对账状态 : 1 已对账, 0 未对账 |
| 5 | settleMonth | 结算月 | string | — | Required | 结算月,格式:Y-m |
| 6 | sortField | 排序字段 | string | — | Optional | 排序字段: beginningBalanceCurrencyAmount 期初余额 incomeAmount 收入 refundAmount 退款 spendAmount 支出 other 其他 |
| 7 | sortType | 排序规则 | string | — | Optional | 排序规则: asc 升序 desc 降序 |
| 8 | receivedState | 转账/到账金额 | integer | — | Optional | 转账/到账金额: 0 不相符 1 相符 |
| 9 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量, 默认0 |
| 10 | length | 分页长度 | integer | — | Optional | 分页长度,默认20 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0 成功 |
| 2 | message | 提示信息 | string | 操作成功 | Required | 提示信息 |
| 3 | request_id | 请求链路id | string | ad9c1a8625c74f3ea0525e216374e31a1676514819613 | Required | 请求链路id |
| 4 | response_time | 响应时间 | string | 2023-02-16 10:33:40 | Required | 响应时间 |
| 5 | data | 响应数据 | array<object> | — | Required | 响应数据 |
| 5.1 | storeName | 店铺名称 | string | JHL Official-01 | Required | 店铺名称 |
| 5.2 | sid | 店铺id | integer | 8 | Required | 店铺id |
| 5.3 | country | 站点 | string | 英国 | Required | 站点 |
| 5.4 | countryCode | 国家编码 | string | UK | Required | 国家编码 |
| 5.5 | settlementDate | 结算月 | string | 2021-01 | Required | 结算月 |
| 5.6 | archiveStatus | 对账状态 | integer | 0 | Required | 对账状态: 已对账 1 未对账 0 |
| 5.7 | archiveStatusName | 对账状态名称 | string | 未对账 | Required | 对账状态名称 |
| 5.8 | currencyCode | 币种code | string | CNY | Required | 币种code |
| 5.9 | currencyIcon | 币种icon | string | ¥ | Required | 币种icon |
| 5.10 | beginningBalanceCurrencyAmount | 期初余额 | number | 98102.5 | Required | 期初余额 |
| 5.11 | incomeAmount | 收入 | number | 634711.85 | Required | 收入 |
| 5.12 | refundAmount | 退款 | number | -8548.59 | Required | 退款 |
| 5.13 | spendAmount | 支出 | number | -350595.94 | Required | 支出 |
| 5.14 | other | 其他 | number | 0 | Required | 其他 |
| 5.15 | card | 其他-信用卡(其他的子项) | number | 0 | Required | 其他-信用卡(其他的子项) |
| 5.16 | otherItem | 其他-其他项目(其他的子项) | number | 0 | Required | 其他-其他项目(其他的子项) |
| 5.17 | convertedSuccessAmount | 转账成功金额 | number | 167112.7 | Required | 转账成功金额 |
| 5.18 | convertedFailedAmount | 转账失败金额 | number | 0 | Required | 转账失败金额 |
| 5.19 | receivedAmount | 到账金额 | number | 0 | Required | 到账金额 |
| 5.20 | endingBalance | 期末 | number | 206557.12 | Required | 期末 |
| 5.21 | remark | 备注 | string | this is a remark | Optional | 备注 |
The 应收报告 - 列表查询 API (/bd/sp/api/open/monthly/receivable/report/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.