/bd/sp/api/open/settlement/summary/list{
"operation": {
"method": "POST",
"path": "/bd/sp/api/open/settlement/summary/list"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 10,
"text": ""
},
"requestExample": {
"offset": 0,
"length": 20,
"countryCodes": [
1
],
"sids": [
136
],
"currencyCode": "USD",
"dateType": 1,
"startDate": "2023-9-25",
"endDate": "2023-12-24",
"searchField": "id",
"searchValue": [
"LWCBG07Y55I3",
"D506VLLNX1VT"
]
},
"responseExample": {
"code": 0,
"msg": null,
"data": {
"total": 7,
"records": [
{
"id": "1C6CP3QMDVLHW",
"sid": 6,
"storeName": "XinghaiDirect-1567",
"countryCode": "US",
"customerCountryCode": "",
"sellerId": "xxxxxxxxxxxxxxxx",
"accountType": "Standard",
"processingStatus": "Closed",
"fundTransferStatus": "Succeeded",
"reconciliationResult": "未对账",
"reconciliationResultMap": {
"2022-09": {
"checkStatus": "未对账",
"checkUser": null,
"checkDate": null
},
"2022-08": {
"checkStatus": "未对账",
"checkUser": null,
"checkDate": null
}
},
"originalTotalCurrencyCode": "USD",
"originalTotalCurrencyAmount": 415.47,
"convertedTotalCurrencyCode": "USD",
"convertedTotalCurrencyAmount": 415.47,
"comment": null,
"financialEventGroupStartLocale": "2022-08-25T03:28:56-07:00",
"financialEventGroupEndLocale": "2022-09-08T03:28:56-07:00",
"fundTransferDate": "2022-09-09T10:37:53Z",
"fundTransferDateLocale": "2022-09-09T03:37:53-07:00",
"settlementId": "",
"accountTail": "225",
"traceId": "1BQR1QINCHA9LN9",
"financialEventGroupId": "xJorkEeGz7nDQ0Ul-fGDf_LjO1EQOzJN_j4oTYmY-GU",
"sale": {
"sale": 720.07,
"product": 718.91,
"freight": 3.81,
"packing": 0,
"other": -2.65,
"tax": 0
},
"refund": {
"refund": 0,
"saleRefund": 0,
"feeRefund": 0,
"tax": 0
},
"pay": {
"pay": -304.6,
"storage": 0,
"amazon": -304.6,
"ad": 0,
"promotion": 0,
"other": 0
},
"transfer": {
"convertedTotalCurrencyAmount": 415.47,
"beginningBalanceCurrencyAmount": 0,
"originalTotalCurrencyAmount": 415.47,
"previousReserveAmount": 0,
"currentReserveAmount": 0,
"creditCardDeduction": 0
},
"bucket": "",
"s3FileKey": "",
"originCurrencyIcon": "$",
"convertCurrencyIcon": "$",
"accountInfo": null
}
]
}
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | offset | 分页偏移量 | string | — | Optional | 分页偏移量 |
| 2 | length | 分页长度 | string | — | Optional | 分页长度 |
| 3 | countryCodes | 国家 | string | — | Optional | 国家,查询亚马逊市场列表接口对应字段mid |
| 4 | sids | 店铺id | string | — | Optional | 店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】 |
| 5 | currencyCode | 币种 | string | — | Optional | 币种 |
| 6 | dateType | 时间类型 | string | — | Optional | 时间类型: 0 结算开始时间 1 结算结束时间 2 转账时间 |
| 7 | startDate | 开始时间【时间间隔最长不得超过90天】 | string | — | Optional | 开始时间【时间间隔最长不得超过90天】 |
| 8 | endDate | 结束时间【时间间隔最长不得超过90天】 | string | — | Optional | 结束时间【时间间隔最长不得超过90天】 |
| 9 | searchField | 搜索字段 | string | — | Optional | 搜索字段: id 结算编号 settlement_id 账单编号 |
| 10 | searchValue | 搜索值 | string | — | Optional | 搜索值 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0 成功 |
| 2 | msg | 提示信息 | string | — | Required | 提示信息 |
| 3 | data | 响应数据 | array<object> | — | Required | 响应数据 |
| 3.1 | total | 总数 | integer | — | Required | 总数 |
| 3.2 | records | 列表 | array<object> | — | Required | 列表 |
| 3.2.1 | id | 结算编号 | string | — | Required | 结算编号 |
| 3.2.2 | sid | 店铺 | integer | — | Required | 店铺 |
| 3.2.3 | storeName | 店铺名 | string | — | Required | 店铺名 |
| 3.2.4 | countryCode | 国家 | string | — | Required | 国家 |
| 3.2.5 | customerCountryCode | 国家code | string | — | Required | 国家code |
| 3.2.6 | sellerId | 亚马逊账号id | string | — | Required | 亚马逊账号id |
| 3.2.7 | accountType | 报告类型 | string | — | Required | 报告类型 |
| 3.2.8 | processingStatus | 结算状态 | string | — | Required | 结算状态: Open 待结算 Pending 结算中 Closed 已结算 |
| 3.2.9 | fundTransferStatus | 转账状态 | string | — | Required | 转账状态: Succeeded 已转账 Failed 失败 Processing 转账中 Unknown 未知 |
| 3.2.10 | reconciliationResult | 对账结果 | string | — | Required | 对账结果 |
| 3.2.11 | reconciliationResultMap | 对账详情 | object | — | Required | 对账详情 |
| 3.2.11.1 | 【月份值】 | 【月份值】 | object | — | Optional | |
| 3.2.11.1.1 | checkStatus | 对账状态 | string | — | Required | 对账状态 |
| 3.2.11.1.2 | checkUser | 对账人 | string | — | Required | 对账人 |
| 3.2.11.1.3 | checkDate | 对账日期 | string | — | Required | 对账日期 |
| 3.2.12 | originalTotalCurrencyCode | 应收币种 | string | — | Required | 应收币种 |
| 3.2.13 | originalTotalCurrencyAmount | 应收金额 | number | — | Required | 应收金额 |
| 3.2.14 | convertedTotalCurrencyCode | 转账币种 | string | — | Required | 转账币种 |
| 3.2.15 | convertedTotalCurrencyAmount | 转账金额 | number | — | Required | 转账金额 |
| 3.2.16 | comment | 备注 | string | — | Required | 备注 |
| 3.2.17 | financialEventGroupStartLocale | 结算开始时间 | string | — | Required | 结算开始时间 |
| 3.2.18 | financialEventGroupEndLocale | 结算结束时间 | string | — | Required | 结算结束时间 |
| 3.2.19 | fundTransferDate | 转账日期 | string | — | Required | 转账日期 |
| 3.2.20 | fundTransferDateLocale | 转账日期-当地 | string | — | Required | 转账日期-当地 |
| 3.2.21 | settlementId | settlementId | string | — | Required | settlementId |
| 3.2.22 | accountTail | 银行尾号 | string | — | Required | 银行尾号 |
| 3.2.23 | traceId | 追踪编号 | string | — | Required | 追踪编号 |
| 3.2.24 | financialEventGroupId | 财务事件组id | string | — | Required | 财务事件组id |
| 3.2.25 | sale | 销售 | object | — | Required | 销售 |
| 3.2.25.1 | sale | 销售金额 | number | — | Required | 销售金额 |
| 3.2.25.2 | product | 产品销售 | number | — | Required | 产品销售 |
| 3.2.25.3 | freight | 买家运费 | number | — | Required | 买家运费 |
| 3.2.25.4 | packing | 包装 | number | — | Required | 包装 |
| 3.2.25.5 | other | 其他 | number | — | Required | 其他 |
| 3.2.25.6 | tax | 税 | number | — | Required | 税 |
| 3.2.26 | refund | 退款 | object | — | Required | 退款 |
| 3.2.26.1 | refund | 退款 | number | — | Required | 退款 |
| 3.2.26.2 | saleRefund | 收入退款 | number | — | Required | 收入退款 |
| 3.2.26.3 | feeRefund | 费用退款 | number | — | Required | 费用退款 |
| 3.2.26.4 | tax | 税退款 | number | — | Required | 税退款 |
| 3.2.27 | pay | 支出 | object | — | Required | 支出 |
| 3.2.27.1 | pay | 支出 | number | — | Required | 支出 |
| 3.2.27.2 | storage | 仓储费用 | number | — | Required | 仓储费用 |
| 3.2.27.3 | amazon | 亚马逊费用 | number | — | Required | 亚马逊费用 |
| 3.2.27.4 | ad | 广告费 | number | — | Required | 广告费 |
| 3.2.27.5 | promotion | 促销费 | number | — | Required | 促销费 |
| 3.2.27.6 | other | 其他 | number | — | Required | 其他 |
| 3.2.28 | transfer | 转账 | object | — | Required | 转账 |
| 3.2.28.1 | convertedTotalCurrencyAmount | 应收金额 | number | — | Required | 应收金额 |
| 3.2.28.2 | beginningBalanceCurrencyAmount | 期初余额 | number | — | Required | 期初余额 |
| 3.2.28.3 | originalTotalCurrencyAmount | 本期结算 | number | — | Required | 本期结算 |
| 3.2.28.4 | previousReserveAmount | 预留退回 | number | — | Required | 预留退回 |
| 3.2.28.5 | currentReserveAmount | 本期预留 | number | — | Required | 本期预留 |
| 3.2.28.6 | creditCardDeduction | 信用卡扣款 | number | — | Required | 信用卡扣款 |
| 3.2.29 | bucket | bucket | string | — | Required | bucket |
| 3.2.30 | s3FileKey | s3FileKey | string | — | Required | s3_file_key |
| 3.2.31 | originCurrencyIcon | 应收币种符号 | string | — | Required | 应收币种符号 |
| 3.2.32 | convertCurrencyIcon | 转账币种符号 | string | | Required | 转账币种符号 |
The 查询结算中心 - 结算汇总 API (/bd/sp/api/open/settlement/summary/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.