Qeasy Cloud
Get Started

领星ERP 账单明细 - LazadaSettlement API

Platform
领星ERP
Type
WebAPI
Effect
QUERY
API Version
1.0
Adapter
\Adapter\LingXing\LXQueryAdapter
Auth Mode
OTHER
Description
多平台 / 财务 / Lazada财务 · POST · 请求参数 28 个(必填 2) · 响应参数 59 个 · 限流令牌桶容量 1
Updated At
2026-11-21

账单明细 - LazadaSettlement

POST/basicOpen/finance/lazada/settlement/list
Factory
{
  "operation": {
    "method": "POST",
    "path": "/basicOpen/finance/lazada/settlement/list"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 1,
    "text": ""
  },
  "requestExample": "curl --location 'https://openapi.lingxing.com/basicOpen/finance/lazada/settlement/list?access_token=value&timestamp=value&sign=value&app_key=value' \\\n--header 'Content-Type: application/json' \\\n--data '{\n    \"compareLogic\": \"AND\",\n    \"currencyCode\": \"USD\",\n    \"startDate\": \"2026-03-01 00:00:00\",\n    \"endDate\": \"2026-03-17 23:59:59\",\n    \"length\": 20,\n    \"offset\": 0,\n    \"searchType\": 1,\n    \"searchSingleValue\": \"ORDER001\",\n    \"searchType1\": 12,\n    \"searchSingleValue1\": \"MSKU001\",\n    \"feeNames\": [\"Commission Fee\"],\n    \"transactionTypes\": [\"Payment\"],\n    \"sites\": [\"SG\",\"MY\"],\n    \"sids\": [10001,10002],\n    \"storeTypes\": [1,2],\n    \"timeType\": 1\n}'",
  "responseExample": {
    "code": 0,
    "message": "success",
    "error_details": [],
    "request_id": "ccafcc7d9a72484fac5a3889b5db2986.231.17611516492143035",
    "response_time": "2025-10-23 00:47:29",
    "data": {
      "totalCount": 2,
      "totalSum": {
        "amount": "1200.50",
        "currencyCode": "USD",
        "currencyIcon": "$",
        "refundQuantity": 2,
        "saleQuantity": 10,
        "totalCount": 2,
        "vatInAmount": "18.60",
        "whtAmount": "9.50"
      },
      "list": [
        {
          "uniqueNo": "LAZADA-SETTLEMENT-001",
          "isInSettlement": 1,
          "whtAmount": "4.50",
          "shippingSpeed": "Standard",
          "gmtModified": "2026-03-17 15:20:00",
          "whtIncludedInAmount": "Y",
          "statementStartTime": "2026-03-01 00:00:00",
          "currencyIcon": "$",
          "shipmentType": "Dropship",
          "reference": "REF20260317001",
          "paidStatus": "paid",
          "orderItemStatus": "delivered",
          "statement": "Statement",
          "lazadaSku": "LAZSKU001",
          "details": "Commission Fee",
          "storeName": "Lazada-SG",
          "id": 1001,
          "transactionDateOrigin": "2026-03-15",
          "sellerSku": "SELLER-SKU-001",
          "storeType": 1,
          "amount": "600.25",
          "orderNo": "ORDER001",
          "refundQuantity": 1,
          "saleQuantity": 5,
          "vatInAmount": "9.30",
          "transactionNumber": "TXN20260317001",
          "paidStatusDisplay": "已回款",
          "siteDisplay": "新加坡",
          "feeType": "Commission",
          "storeId": 10001,
          "transactionDate": "2026-03-15",
          "gmtCreate": "2026-03-17 12:00:00",
          "transactionType": "Payment",
          "site": "SG",
          "sourceType": 1,
          "storeTypeDisplay": "跨境店",
          "orderItemNo": "ORDER001-1",
          "feeName": "Commission Fee",
          "comment": "正常结算",
          "currencyCode": "USD",
          "platformCode": "lazada",
          "statementEndTime": "2026-03-15 23:59:59"
        }
      ]
    }
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1compareLogic字段比较条件逻辑关系string—Optional字段比较条件逻辑关系: AND 所有条件都满足 OR 满足任一条件 默认 AND
2currencyCode目标货币代码(为空则使用原币种)string—Optional目标货币代码(为空则使用原币种)
3endDate结束时间string—Optional结束时间,支持 yyyy-MM-dd 或 yyyy-MM-dd HH:mm:ss 格式,仅日期时自动补充 23:59:59
4envKey环境标识string—Optional环境标识
5exportFields导出字段值array<any>—Optional导出字段值
6feeNames费用名称数组array<any>—Optional费用名称数组
7fieldComparesfieldComparesarray<any>—Optional字段比较条件列表(多个条件之间的逻辑关系由 compareLogic 指定)
8isInSettlement是否计入结算number—Optional是否计入结算: 0 否 1 是 null 全部
9length分页大小number—Required分页大小,默认 20,最大不超过 200
10offset分页偏移number—Required分页偏移,默认 0
11paidStatuses回款状态数组array<any>—Optional回款状态数组
12platformCode平台码string—Optional平台码
13searchExactly是否精确匹配boolean—Optional是否精确匹配
14searchExactly1商品搜索是否精确匹配boolean—Optional商品搜索是否精确匹配
15searchMultiValue多个搜索值(精确匹配)array<any>—Optional多个搜索值(精确匹配)
16searchMultiValue1商品搜索值(多个array<any>—Optional商品搜索值(多个,精确匹配)
17searchSingleValue单个搜索值(支持模糊匹配string—Optional单个搜索值(支持模糊匹配,多个值用逗号分隔)
18searchSingleValue1商品搜索值(单个string—Optional商品搜索值(单个,支持模糊匹配,多个值用逗号分隔)
19searchType搜索类型number—Optional搜索类型: 1 平台单号 2 平台子单号 3 交易编号 4 支付参考编号 5 参考单号
20searchType1商品搜索类型number—Optional商品搜索类型: 11 MSKU ID 12 MSKU 13 商品名称
21sids店铺 ID 数组array<any>—Optional店铺 ID 数组
22sites站点数组array<any>—Optional站点数组
23sortField排序字段string—Optional排序字段
24sortType排序方向string—Optional排序方向: 1 升序/ASC 0 降序/DESC 默认 0
25startDate开始时间string—Optional开始时间,支持 yyyy-MM-dd 或 yyyy-MM-dd HH:mm:ss 格式,仅日期时自动补充 00:00:00
26storeTypes店铺类型数组array<any>—Optional店铺类型数组: 1 跨境店 2 本土店
27timeType时间类型number—Optional时间类型: 1 结算日期 2 结算周期 默认 1
28transactionTypes交易类型数组array<any>—Optional交易类型数组

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码number0Required状态码,0:成功
2message消息提示stringsuccessRequired消息提示
3error_details数据校验失败时的错误详情array<any>[]Required数据校验失败时的错误详情
4request_id请求链路idstringccafcc7d9a72484fac5a3889b5db2986.231.17611516492143035Required请求链路id
5response_time响应时间string2025-10-23 00:47:29Required响应时间
6data响应数据object—Required响应数据
6.1totalCount总记录数number2Required总记录数
6.2totalSum汇总数据object—Required汇总数据
6.2.1amount结算金额汇总string1200.50Required结算金额汇总
6.2.2currencyCode币种代码stringUSDRequired币种代码
6.2.3currencyIcon币种图标string$Required币种图标
6.2.4refundQuantity退款数量汇总number2Required退款数量汇总
6.2.5saleQuantity销售数量汇总number10Required销售数量汇总
6.2.6totalCount总记录数number2Required总记录数
6.2.7vatInAmount增值税金额汇总string18.60Required增值税金额汇总
6.2.8whtAmount预提税金额汇总string9.50Required预提税金额汇总
6.3list列表数据array<object>—Required列表数据
6.3.1uniqueNo业务唯一键stringLAZADA-SETTLEMENT-001Required业务唯一键
6.3.2isInSettlement是否计入结算number1Required是否计入结算
6.3.3whtAmount预提税金额string4.50Required预提税金额
6.3.4shippingSpeed配送时效stringStandardRequired配送时效
6.3.5gmtModified修改时间string2026-03-17 15:20:00Required修改时间
6.3.6whtIncludedInAmount是否已计入金额的预提税stringYRequired是否已计入金额的预提税
6.3.7statementStartTime结算周期开始时间string2026-03-01 00:00:00Required结算周期开始时间
6.3.8currencyIcon币种图标string$Required币种图标
6.3.9shipmentType发货类型stringDropshipRequired发货类型
6.3.10reference参考单号stringREF20260317001Required参考单号
6.3.11paidStatus回款状态值stringpaidRequired回款状态值
6.3.12orderItemStatus订单商品状态stringdeliveredRequired订单商品状态
6.3.13statement账单名称stringStatementRequired账单名称
6.3.14lazadaSkuLazada SKUstringLAZSKU001RequiredLazada SKU
6.3.15details明细说明stringCommission FeeRequired明细说明
6.3.16storeName店铺名stringLazada-SGRequired店铺名
6.3.17id主键 IDnumber1001Required主键 ID
6.3.18transactionDateOrigin原始交易日期string2026-03-15Required原始交易日期
6.3.19sellerSku卖家 SKUstringSELLER-SKU-001Required卖家 SKU
6.3.20storeType店铺类型number1Required店铺类型:1-跨境店, 2-本土店
6.3.21amount结算金额string600.25Required结算金额
6.3.22orderNo平台单号stringORDER001Required平台单号
6.3.23refundQuantity退款数量number1Required退款数量
6.3.24saleQuantity销售数量number5Required销售数量
6.3.25vatInAmount增值税金额string9.30Required增值税金额
6.3.26transactionNumber交易编号stringTXN20260317001Required交易编号
6.3.27paidStatusDisplay回款状态展示string已回款Required回款状态展示
6.3.28siteDisplay站点中文展示string新加坡Required站点中文展示
6.3.29feeType费用类型stringCommissionRequired费用类型
6.3.30storeId店铺 IDnumber10001Required店铺 ID
6.3.31transactionDate交易日期string2026-03-15Required交易日期
6.3.32gmtCreate创建时间string2026-03-17 12:00:00Required创建时间
6.3.33transactionType交易类型stringPaymentRequired交易类型
6.3.34site站点代码stringSGRequired站点代码
6.3.35sourceType数据来源number1Required数据来源:1-接口, 2-报表导入
6.3.36storeTypeDisplay店铺类型展示string跨境店Required店铺类型展示
6.3.37orderItemNo平台子单号stringORDER001-1Required平台子单号
6.3.38feeName费用名称stringCommission FeeRequired费用名称
6.3.39comment备注string正常结算Required备注
6.3.40currencyCode币种代码stringUSDRequired币种代码
6.3.41platformCode平台码stringlazadaRequired平台码
6.3.42statementEndTime结算周期结束时间string2026-03-15 23:59:59Required结算周期结束时间

The 账单明细 - LazadaSettlement API (/basicOpen/finance/lazada/settlement/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.