Qeasy Cloud
Get Started

领星ERP 查询结算中心 - 结算汇总 API

Platform
领星ERP
Type
WebAPI
Effect
QUERY
API Version
1.0
Adapter
\Adapter\LingXing\LXQueryAdapter
Auth Mode
OTHER
Description
财务 · POST · 请求参数 10 个(必填 0) · 响应参数 63 个 · 限流令牌桶容量 10
Updated At
2026-11-21

查询结算中心 - 结算汇总

POST/bd/sp/api/open/settlement/summary/list
Factory
{
  "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
        }
      ]
    }
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1offset分页偏移量string—Optional分页偏移量
2length分页长度string—Optional分页长度
3countryCodes国家string—Optional国家,查询亚马逊市场列表接口对应字段mid
4sids店铺idstring—Optional店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】
5currencyCode币种string—Optional币种
6dateType时间类型string—Optional时间类型: 0 结算开始时间 1 结算结束时间 2 转账时间
7startDate开始时间【时间间隔最长不得超过90天】string—Optional开始时间【时间间隔最长不得超过90天】
8endDate结束时间【时间间隔最长不得超过90天】string—Optional结束时间【时间间隔最长不得超过90天】
9searchField搜索字段string—Optional搜索字段: id 结算编号 settlement_id 账单编号
10searchValue搜索值string—Optional搜索值

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer0Required状态码,0 成功
2msg提示信息string—Required提示信息
3data响应数据array<object>—Required响应数据
3.1total总数integer—Required总数
3.2records列表array<object>—Required列表
3.2.1id结算编号string—Required结算编号
3.2.2sid店铺integer—Required店铺
3.2.3storeName店铺名string—Required店铺名
3.2.4countryCode国家string—Required国家
3.2.5customerCountryCode国家codestring—Required国家code
3.2.6sellerId亚马逊账号idstring—Required亚马逊账号id
3.2.7accountType报告类型string—Required报告类型
3.2.8processingStatus结算状态string—Required结算状态: Open 待结算 Pending 结算中 Closed 已结算
3.2.9fundTransferStatus转账状态string—Required转账状态: Succeeded 已转账 Failed 失败 Processing 转账中 Unknown 未知
3.2.10reconciliationResult对账结果string—Required对账结果
3.2.11reconciliationResultMap对账详情object—Required对账详情
3.2.11.1【月份值】【月份值】object—Optional
3.2.11.1.1checkStatus对账状态string—Required对账状态
3.2.11.1.2checkUser对账人string—Required对账人
3.2.11.1.3checkDate对账日期string—Required对账日期
3.2.12originalTotalCurrencyCode应收币种string—Required应收币种
3.2.13originalTotalCurrencyAmount应收金额number—Required应收金额
3.2.14convertedTotalCurrencyCode转账币种string—Required转账币种
3.2.15convertedTotalCurrencyAmount转账金额number—Required转账金额
3.2.16comment备注string—Required备注
3.2.17financialEventGroupStartLocale结算开始时间string—Required结算开始时间
3.2.18financialEventGroupEndLocale结算结束时间string—Required结算结束时间
3.2.19fundTransferDate转账日期string—Required转账日期
3.2.20fundTransferDateLocale转账日期-当地string—Required转账日期-当地
3.2.21settlementIdsettlementIdstring—RequiredsettlementId
3.2.22accountTail银行尾号string—Required银行尾号
3.2.23traceId追踪编号string—Required追踪编号
3.2.24financialEventGroupId财务事件组idstring—Required财务事件组id
3.2.25sale销售object—Required销售
3.2.25.1sale销售金额number—Required销售金额
3.2.25.2product产品销售number—Required产品销售
3.2.25.3freight买家运费number—Required买家运费
3.2.25.4packing包装number—Required包装
3.2.25.5other其他number—Required其他
3.2.25.6tax税number—Required税
3.2.26refund退款object—Required退款
3.2.26.1refund退款number—Required退款
3.2.26.2saleRefund收入退款number—Required收入退款
3.2.26.3feeRefund费用退款number—Required费用退款
3.2.26.4tax税退款number—Required税退款
3.2.27pay支出object—Required支出
3.2.27.1pay支出number—Required支出
3.2.27.2storage仓储费用number—Required仓储费用
3.2.27.3amazon亚马逊费用number—Required亚马逊费用
3.2.27.4ad广告费number—Required广告费
3.2.27.5promotion促销费number—Required促销费
3.2.27.6other其他number—Required其他
3.2.28transfer转账object—Required转账
3.2.28.1convertedTotalCurrencyAmount应收金额number—Required应收金额
3.2.28.2beginningBalanceCurrencyAmount期初余额number—Required期初余额
3.2.28.3originalTotalCurrencyAmount本期结算number—Required本期结算
3.2.28.4previousReserveAmount预留退回number—Required预留退回
3.2.28.5currentReserveAmount本期预留number—Required本期预留
3.2.28.6creditCardDeduction信用卡扣款number—Required信用卡扣款
3.2.29bucketbucketstring—Requiredbucket
3.2.30s3FileKeys3FileKeystring—Requireds3_file_key
3.2.31originCurrencyIcon应收币种符号string—Required应收币种符号
3.2.32convertCurrencyIcon转账币种符号string&nbsp;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.

Need to integrate this API?

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