/basicOpen/finance/shopee/adjustment/list{
"operation": {
"method": "POST",
"path": "/basicOpen/finance/shopee/adjustment/list"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": "curl --location 'https://openapi.lingxing.com/basicOpen/finance/shopee/adjustment/list?access_token=value×tamp=value&sign=value&app_key=value' \\\n--header 'Content-Type: application/json' \\\n--data '{\n \"adjDimensions\": [\"Order\"],\n \"adjTypes\": [\"Refund Amount\"],\n \"compareLogic\": \"AND\",\n \"currencyCode\": \"USD\",\n \"startDate\": \"2026-03-01\",\n \"endDate\": \"2026-03-17\",\n \"length\": 20,\n \"offset\": 0,\n \"searchType\": 1,\n \"searchSingleValue\": \"ORDER20260317001\",\n \"sites\": [\"SG\",\"MY\"],\n \"sids\": [10001,10002],\n \"storeTypes\": [1,2]\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": "320.50",
"currency": "USD",
"currencyIcon": "$",
"totalCount": 2
},
"list": [
{
"uniqueNo": "SHOPEE-ADJ-001",
"originalPayoutTime": 1742198400,
"storeType": 1,
"amount": "120.50",
"orderNo": "ORDER20260317001",
"adjDimension": "Order",
"adjNumber": 1,
"adjRemark": "订单售后差异调整",
"adjScenario": "After Sales",
"billingTransactionType": "adjustment",
"siteDisplay": "新加坡",
"currencyIcon": "$",
"storeId": 10001,
"payoutSn": "P20260317001",
"encryptedPayoutId": 1234567890,
"transactionId": 987654321,
"transactionType": "SALE",
"payoutTime": "2026-03-17 12:00:00",
"site": "SG",
"storeTypeDisplay": "跨境店",
"storeName": "Shopee-SG",
"currency": "USD",
"id": 1001,
"platformCode": "shopee",
"adjType": "Refund Amount"
}
]
}
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | adjDimensions | 调整维度数组(下拉多选) | array<any> | — | Optional | 调整维度数组(下拉多选): Order Shop other 其他维度 |
| 2 | adjTypes | 调整类型数组(下拉多选) | array<any> | — | Optional | 调整类型数组(下拉多选): Refund Amount Marketing Fee Warehouse Fee Other 其他类型 |
| 3 | compareLogic | 字段比较条件逻辑关系 | string | — | Optional | 字段比较条件逻辑关系: AND 所有条件都满足 OR 满足任一条件 默认 AND |
| 4 | currencyCode | 目标货币代码(为空则使用原币种 | string | — | Optional | 目标货币代码(为空则使用原币种,切换后按打款时间汇率换算) |
| 5 | endDate | 结束时间(结算时间) | string | — | Optional | 结束时间(结算时间),格式 yyyy-MM-dd,默认当前日期 |
| 6 | envKey | 环境标识 | string | — | Optional | 环境标识 |
| 7 | exportFields | 导出字段值 | array<any> | — | Optional | 导出字段值 |
| 8 | fieldCompares | fieldCompares | array<any> | — | Optional | 字段比较条件列表(多个条件之间的逻辑关系由 compareLogic 指定) |
| 9 | length | 分页大小 | number | — | Required | 分页大小,默认 20,最大不超过 200 |
| 10 | offset | 分页偏移 | number | — | Required | 分页偏移,默认 0 |
| 11 | platformCode | 平台码 | string | — | Optional | 平台码 |
| 12 | searchExactly | 是否精确匹配 | boolean | — | Optional | 是否精确匹配 |
| 13 | searchMultiValue | 多个搜索值(精确匹配) | array<any> | — | Optional | 多个搜索值(精确匹配) |
| 14 | searchSingleValue | 单个搜索值(支持模糊匹配 | string | — | Optional | 单个搜索值(支持模糊匹配,多个值用逗号分隔) |
| 15 | searchType | 搜索类型 | number | — | Optional | 搜索类型: 1 平台单号 |
| 16 | sids | 店铺 ID 数组 | array<any> | — | Optional | 店铺 ID 数组 |
| 17 | sites | 站点数组 | array<any> | — | Optional | 站点数组 |
| 18 | sortField | 排序字段 | string | — | Optional | 排序字段 |
| 19 | sortType | 排序方向 | string | — | Optional | 排序方向: 1 升序/ASC 0 降序/DESC 默认 0 |
| 20 | startDate | 开始时间(结算时间) | string | — | Optional | 开始时间(结算时间),格式 yyyy-MM-dd,默认当前月份第一天 |
| 21 | storeTypes | 店铺类型数组 | array<any> | — | Optional | 店铺类型数组: 1 跨境店(CB) 2 本土店(Local) |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | number | 0 | Required | 状态码,0:成功 |
| 2 | message | 消息提示 | string | success | Required | 消息提示 |
| 3 | error_details | 数据校验失败时的错误详情 | array<any> | [] | Required | 数据校验失败时的错误详情 |
| 4 | request_id | 请求链路id | string | ccafcc7d9a72484fac5a3889b5db2986.231.17611516492143035 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2025-10-23 00:47:29 | Required | 响应时间 |
| 6 | data | 响应数据 | object | — | Required | 响应数据 |
| 6.1 | totalCount | 总记录数 | number | 2 | Required | 总记录数 |
| 6.2 | totalSum | 汇总数据 | object | — | Required | 汇总数据 |
| 6.2.1 | amount | 调整金额汇总 | string | 320.50 | Required | 调整金额汇总 |
| 6.2.2 | currency | 币种代码 | string | USD | Required | 币种代码 |
| 6.2.3 | currencyIcon | 币种图标 | string | $ | Required | 币种图标 |
| 6.2.4 | totalCount | 总记录数 | number | 2 | Required | 总记录数 |
| 6.3 | list | 列表数据 | array<object> | — | Required | 列表数据 |
| 6.3.1 | uniqueNo | 业务唯一键 | string | SHOPEE-ADJ-001 | Required | 业务唯一键 |
| 6.3.2 | originalPayoutTime | 原始结算时间戳 | number | 1742198400 | Required | 原始结算时间戳 |
| 6.3.3 | storeType | 店铺类型 | number | 1 | Required | 店铺类型:1-跨境店, 2-本土店 |
| 6.3.4 | amount | 调整金额 | string | 120.50 | Required | 调整金额 |
| 6.3.5 | orderNo | 平台订单号 | string | ORDER20260317001 | Required | 平台订单号 |
| 6.3.6 | adjDimension | 调整维度 | string | Order | Required | 调整维度 |
| 6.3.7 | adjNumber | 调整明细序号 | number | 1 | Required | 调整明细序号 |
| 6.3.8 | adjRemark | 调整备注 | string | 订单售后差异调整 | Required | 调整备注 |
| 6.3.9 | adjScenario | 调整场景 | string | After Sales | Required | 调整场景 |
| 6.3.10 | billingTransactionType | 账单交易类型 | string | adjustment | Required | 账单交易类型 |
| 6.3.11 | siteDisplay | 站点中文展示 | string | 新加坡 | Required | 站点中文展示 |
| 6.3.12 | currencyIcon | 币种图标 | string | $ | Required | 币种图标 |
| 6.3.13 | storeId | 店铺 ID | number | 10001 | Required | 店铺 ID |
| 6.3.14 | payoutSn | 账期 ID | string | P20260317001 | Required | 账期 ID |
| 6.3.15 | encryptedPayoutId | 账期加密 ID(仅CB有) | number | 1234567890 | Required | 账期加密 ID(仅CB有) |
| 6.3.16 | transactionId | 交易 ID(仅Local有) | number | 987654321 | Required | 交易 ID(仅Local有) |
| 6.3.17 | transactionType | 交易类型(仅Local有) | string | SALE | Required | 交易类型(仅Local有) |
| 6.3.18 | payoutTime | 结算时间 | string | 2026-03-17 12:00:00 | Required | 结算时间 |
| 6.3.19 | site | 站点代码 | string | SG | Required | 站点代码 |
| 6.3.20 | storeTypeDisplay | 店铺类型展示 | string | 跨境店 | Required | 店铺类型展示 |
| 6.3.21 | storeName | 店铺名 | string | Shopee-SG | Required | 店铺名 |
| 6.3.22 | currency | 币种 | string | USD | Required | 币种 |
| 6.3.23 | id | 主键 ID | number | 1001 | Required | 主键 ID |
| 6.3.24 | platformCode | 平台码 | string | shopee | Required | 平台码 |
| 6.3.25 | adjType | 调整类型 | string | Refund Amount | Required | 调整类型 |
The 账单明细 - ShopeeAdjustment API (/basicOpen/finance/shopee/adjustment/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.