/basicOpen/multiplatformFinance/lineBill/statement/list{
"operation": {
"method": "POST",
"path": "/basicOpen/multiplatformFinance/lineBill/statement/list"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": "curl --location 'https://openapi.lingxing.com/basicOpen/multiplatformFinance/lineBill/statement/list?access_token=value×tamp=value&sign=value&app_key=value' \\\n--header 'Content-Type: application/json' \\\n--data '{\n \"sids\": [],\n \"currencyCode\": \"\",\n \"settlementStatuses\": [],\n \"orderStatuses\": [],\n \"startDate\": \"2026-09-01\",\n \"endDate\": \"2026-10-22\",\n \"searchType\": 1,\n \"searchMultiValue\": [],\n \"searchType1\": 11,\n \"searchMultiValue1\": [],\n \"offset\": 0,\n \"length\": 20\n}'",
"responseExample": {
"code": 0,
"message": "success",
"error_details": [],
"request_id": "example-request-id",
"response_time": "2026-10-22 12:00:00",
"data": {
"list": [
{
"id": 1234567890123457,
"storeId": 1234567890123456,
"storeName": "Example Store",
"settlementIds": "EXAMPLE-001",
"settlementStatus": "",
"settlementStatusName": "",
"settlementDate": "2026-10-22 12:00:00",
"orderNumber": "EXAMPLE-001",
"lineItemId": "EXAMPLE-001",
"msku": "",
"mskuId": "EXAMPLE-001",
"quantity": 1,
"orderStatus": "",
"shipmentStatus": "",
"itemAmount": 0,
"itemDiscountAmount": 0,
"buyerShippingFee": 0,
"orderDiscountAmount": 0,
"buyerPaymentAmount": 0,
"platformSubsidyAmount": 0,
"withholdingTaxAmount": 0,
"transactionFeeAmount": 0,
"serviceFeeAmount": 0,
"vatAmount": 0,
"otherAmount": 0,
"sellerReceivableAmount": 0,
"currency": "USD",
"currencyIcon": "$",
"isMasterRow": true,
"children": [
{
"id": 1234567890123458,
"storeId": 1234567890123456,
"storeName": "Example Store",
"settlementIds": "EXAMPLE-001",
"settlementStatus": "",
"settlementStatusName": "",
"settlementDate": "2026-10-22 12:00:00",
"orderNumber": "EXAMPLE-001",
"lineItemId": "EXAMPLE-001",
"msku": "",
"mskuId": "EXAMPLE-001",
"quantity": 1,
"orderStatus": "",
"shipmentStatus": "",
"itemAmount": 0,
"itemDiscountAmount": 0,
"buyerShippingFee": 0,
"orderDiscountAmount": 0,
"buyerPaymentAmount": 0,
"platformSubsidyAmount": 0,
"withholdingTaxAmount": 0,
"transactionFeeAmount": 0,
"serviceFeeAmount": 0,
"vatAmount": 0,
"otherAmount": 0,
"sellerReceivableAmount": 0,
"currency": "USD",
"currencyIcon": "$",
"isMasterRow": false,
"children": null
}
]
}
],
"totalCount": 1,
"totalSum": {
"totalCount": 1,
"currency": "USD",
"currencyIcon": "$",
"quantity": 1,
"itemAmount": 0,
"itemDiscountAmount": 0,
"buyerShippingFee": 0,
"orderDiscountAmount": 0,
"buyerPaymentAmount": 0,
"platformSubsidyAmount": 0,
"withholdingTaxAmount": 0,
"transactionFeeAmount": 0,
"serviceFeeAmount": 0,
"vatAmount": 0,
"otherAmount": 0,
"sellerReceivableAmount": 0
}
},
"total": 1
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | sids | 店铺ID列表 | array<any> | — | Optional | 店铺ID列表,不传或空数组表示不按店铺筛选;不是枚举 |
| 2 | currencyCode | 目标币种代码 | string | — | Optional | 目标币种代码,不传或空字符串使用原币种 |
| 3 | settlementStatuses | 结算状态 | array<any> | — | Optional | 结算状态 COMPLETED:已结算 PENDING_SETTLEMENT:待结算 OTHER:其他 |
| 4 | orderStatuses | 订单状态 | array<any> | — | Optional | 订单状态 FINALIZED:FINALIZED COMPLETED:COMPLETED EXPIRED:EXPIRED CANCELED:CANCELED OTHER:其他 |
| 5 | startDate | 结算日期开始日期 | string | — | Optional | 结算日期开始日期,格式yyyy-MM-dd;可不传,与页面清空日期时一致 |
| 6 | endDate | 结算日期结束日期 | string | — | Optional | 结算日期结束日期,格式yyyy-MM-dd;可不传,与页面清空日期时一致 |
| 7 | searchType | 单据搜索类型 | integer | — | Optional | 单据搜索类型 1:平台订单 2:平台子单 3:结算编号 |
| 8 | searchSingleValue | 单据单值搜索内容 | string | — | Optional | 单据单值搜索内容,与searchMultiValue互斥 |
| 9 | searchMultiValue | 单据批量搜索内容 | array<any> | — | Optional | 单据批量搜索内容,最多500个;与searchSingleValue互斥 |
| 10 | searchType1 | 商品搜索类型 | integer | — | Optional | 商品搜索类型 11:MSKU 12:MSKU ID |
| 11 | searchSingleValue1 | 商品单值搜索内容 | string | — | Optional | 商品单值搜索内容,与searchMultiValue1互斥 |
| 12 | searchMultiValue1 | 商品批量搜索内容 | array<any> | — | Optional | 商品批量搜索内容,最多500个;与searchSingleValue1互斥 |
| 13 | sortField | 排序字段 | string | — | Optional | 排序字段 settlementDate:结算日期 quantity:数量 itemAmount:商品金额 itemDiscountAmount:商品折扣 buyerShippingFee:买家运费 orderDiscountAmount:订单折扣 buyerPaymentAmount:买家付款金额 platformSubsidyAmount:平台补贴 withholdingTaxAmount:预提税 transactionFeeAmount:交易费 serviceFeeAmount:服务费 vatAmount:增值税 otherAmount:其他 sellerReceivableAmount:卖家应收 |
| 14 | sortType | 排序方向 | string | — | Optional | 排序方向:0降序,1升序 使用字符串编码 |
| 15 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量,默认0 |
| 16 | length | 每页条数 | integer | — | Optional | 每页条数,默认20,范围1至200 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0表示成功 |
| 2 | message | 消息提示 | string | success | Required | 消息提示 |
| 3 | error_details | 数据校验失败时的错误详情 | array<any> | [] | Required | 数据校验失败时的错误详情 |
| 4 | request_id | 请求链路ID | string | example-request-id | Required | 请求链路ID |
| 5 | response_time | 响应时间 | string | 2026-10-22 12:00:00 | Required | 响应时间 |
| 6 | data | 响应数据 | object | — | Required | 响应数据 |
| 6.1 | list | 列表数据 | array<object> | — | Required | 列表数据 |
| 6.1.1 | id | 主键ID | integer | — | Required | 主键ID |
| 6.1.2 | storeId | 店铺ID | integer | — | Required | 店铺ID |
| 6.1.3 | storeName | 店铺 | string | — | Required | 店铺 |
| 6.1.4 | settlementIds | 结算编号 | string | — | Required | 结算编号 |
| 6.1.5 | settlementStatus | 结算状态编码 | string | — | Required | 结算状态编码 |
| 6.1.6 | settlementStatusName | 结算状态 | string | — | Required | 结算状态 |
| 6.1.7 | settlementDate | 结算日期 | string | — | Required | 结算日期 |
| 6.1.8 | orderNumber | 平台订单 | string | — | Required | 平台订单 |
| 6.1.9 | lineItemId | 平台子单 | string | — | Required | 平台子单 |
| 6.1.10 | msku | msku | string | — | Required | MSKU |
| 6.1.11 | mskuId | MSKU ID | string | — | Required | MSKU ID |
| 6.1.12 | quantity | 数量 | integer | — | Required | 数量 |
| 6.1.13 | orderStatus | 订单状态 | string | — | Required | 订单状态 |
| 6.1.14 | shipmentStatus | 发货状态 | string | — | Required | 发货状态 |
| 6.1.15 | itemAmount | 商品金额 | number | — | Required | 商品金额 |
| 6.1.16 | itemDiscountAmount | 商品折扣 | number | — | Required | 商品折扣 |
| 6.1.17 | buyerShippingFee | 买家运费 | number | — | Required | 买家运费 |
| 6.1.18 | orderDiscountAmount | 订单折扣 | number | — | Required | 订单折扣 |
| 6.1.19 | buyerPaymentAmount | 买家付款金额 | number | — | Required | 买家付款金额 |
| 6.1.20 | platformSubsidyAmount | 平台补贴 | number | — | Required | 平台补贴 |
| 6.1.21 | withholdingTaxAmount | 预提税 | number | — | Required | 预提税 |
| 6.1.22 | transactionFeeAmount | 交易费 | number | — | Required | 交易费 |
| 6.1.23 | serviceFeeAmount | 服务费 | number | — | Required | 服务费 |
| 6.1.24 | vatAmount | 增值税 | number | — | Required | 增值税 |
| 6.1.25 | otherAmount | 其他 | number | — | Required | 其他 |
| 6.1.26 | sellerReceivableAmount | 卖家应收 | number | — | Required | 卖家应收 |
| 6.1.27 | currency | 币种 | string | — | Required | 币种 |
| 6.1.28 | currencyIcon | 币种符号 | string | — | Required | 币种符号 |
| 6.1.29 | isMasterRow | 是否主行 | boolean | — | Required | 是否主行 |
| 6.1.30 | children | 子行列表 | array<any> | — | Required | 子行列表,字段结构与当前列表项相同 |
| 6.2 | totalCount | 总记录数 | integer | — | Required | 总记录数 |
| 6.3 | totalSum | 汇总数据 | object | — | Required | 汇总数据 |
| 6.3.1 | totalCount | 总记录数 | integer | — | Required | 总记录数 |
| 6.3.2 | currency | 币种 | string | — | Required | 币种 |
| 6.3.3 | currencyIcon | 币种符号 | string | — | Required | 币种符号 |
| 6.3.4 | quantity | 数量 | integer | — | Required | 数量 |
| 6.3.5 | itemAmount | 商品金额 | number | — | Required | 商品金额 |
| 6.3.6 | itemDiscountAmount | 商品折扣 | number | — | Required | 商品折扣 |
| 6.3.7 | buyerShippingFee | 买家运费 | number | — | Required | 买家运费 |
| 6.3.8 | orderDiscountAmount | 订单折扣 | number | — | Required | 订单折扣 |
| 6.3.9 | buyerPaymentAmount | 买家付款金额 | number | — | Required | 买家付款金额 |
| 6.3.10 | platformSubsidyAmount | 平台补贴 | number | — | Required | 平台补贴 |
| 6.3.11 | withholdingTaxAmount | 预提税 | number | — | Required | 预提税 |
| 6.3.12 | transactionFeeAmount | 交易费 | number | — | Required | 交易费 |
| 6.3.13 | serviceFeeAmount | 服务费 | number | — | Required | 服务费 |
| 6.3.14 | vatAmount | 增值税 | number | — | Required | 增值税 |
| 6.3.15 | otherAmount | 其他 | number | — | Required | 其他 |
| 6.3.16 | sellerReceivableAmount | 卖家应收 | number | — | Required | 卖家应收 |
| 7 | total | 总记录数 | integer | 1 | Required | 总记录数,与data.totalCount相同 |
The 查询LINE账单明细列表 API (/basicOpen/multiplatformFinance/lineBill/statement/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.