轻易云
注册体验

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

所属平台
领星ERP
类型
WebAPI
作用
QUERY
接口版本
1.0
适配器
\Adapter\LingXing\LXQueryAdapter
授权方式
OTHER
描述
财务 · POST · 请求参数 10 个(必填 0) · 响应参数 63 个 · 限流令牌桶容量 10
更新日期
2026-11-21

查询结算中心 - 结算汇总

POST/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
        }
      ]
    }
  }
}

接口请求参数

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

接口响应参数

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

领星ERP的接口:查询结算中心 - 结算汇总(/bd/sp/api/open/settlement/summary/list),由轻易云数据集成平台 API 资产管理模块整理收纳,并随领星ERP版本更新同步更新。

需要对接这个接口?

轻易云已预置该接口的适配能力,联系我们即可开始配置数据集成。