/basicOpen/finance/requestFundsPool/otherFee/list{
"operation": {
"method": "POST",
"path": "/basicOpen/finance/requestFundsPool/otherFee/list"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": "curl --location 'https://openapi.lingxing.com/basicOpen/finance/requestFundsPool/otherFee/list?access_token=value×tamp=value&sign=value&app_key=value' \\\n--header 'Content-Type: application/json' \\\n--data '{\n \"endTime\": \"2024-12-31\",\n \"startTime\": \"2024-01-01\",\n \"length\": 20,\n \"offset\": 0,\n \"purchaserIds\": [1234567890,9876543210],\n \"searchField\": \"order_sn\",\n \"searchFieldTime\": \"create_time\",\n \"searchValue\": \"PO20240101\",\n \"status\": 0,\n \"supplierIds\": [1234567890,9876543210]\n}'",
"responseExample": {
"code": 0,
"data": {
"list": [
{
"amountNotPaid": "2500",
"amountPaid": "1500.5",
"applyedAmount": "3500",
"applyedDiscount": "50",
"applyedGoodsValue": "4500",
"applyingAmount": "2000",
"applyingDiscount": "30",
"applyingGoodsValue": "3000",
"applyingOrders": [
54321,
98765
],
"closeDate": "2024-11-15",
"closeTime": 1700000000,
"closedByUid": 1234567890,
"closedByUser": "张三",
"closedRemark": "已全额付清",
"currency": "CNY",
"customOrderSn": "CUSTOM-2024-001",
"discountAmount": "100",
"fee": "5000",
"feeTypeId": 1234567890,
"feeTypeName": "运输费",
"icon": "icon_other_fee.png",
"id": 1001,
"isAutoDone": 0,
"notApplyAmount": "1000",
"optRealname": "李四",
"optUid": 1234567890,
"orderSn": "PO202401010001",
"paidOrders": [
12345,
67890
],
"payStatus": 2,
"payStatusText": "未付清",
"payableAmount": "5000",
"purchaserId": 1234567890,
"purchaserName": "深圳采购中心",
"supplierId": 1234567890,
"supplierName": "顺丰物流",
"unapplyGoodsValue": "1500",
"updateUid": 1234567890,
"wareHouseName": "华南仓库",
"wid": 1234567890
},
{
"amountNotPaid": "1000",
"amountPaid": "500",
"applyedAmount": "2000",
"applyedDiscount": "20",
"applyedGoodsValue": "2500",
"applyingAmount": "500",
"applyingDiscount": "10",
"applyingGoodsValue": "1000",
"applyingOrders": [
11223,
44556
],
"closeDate": null,
"closeTime": null,
"closedByUid": null,
"closedByUser": null,
"closedRemark": null,
"currency": "USD",
"customOrderSn": "CUSTOM-2024-002",
"discountAmount": "50",
"fee": "3000",
"feeTypeId": 2345678901,
"feeTypeName": "关税",
"icon": "icon_tariff.png",
"id": 1002,
"isAutoDone": 0,
"notApplyAmount": "500",
"optRealname": "王五",
"optUid": 2345678901,
"orderSn": "PO202401020002",
"paidOrders": [
99887
],
"payStatus": 1,
"payStatusText": "申请中",
"payableAmount": "3000",
"purchaserId": 2345678901,
"purchaserName": "上海采购部",
"supplierId": 2345678901,
"supplierName": "UPS快递",
"unapplyGoodsValue": "500",
"updateUid": 2345678901,
"wareHouseName": "华东仓库",
"wid": 2345678901
}
],
"total": 2
},
"error_details": [],
"message": "成功",
"request_id": "some_request_id_123",
"response_time": "2024-01-01 12:00:00",
"total": 2
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | endTime | 结束时间 | string | — | Optional | 结束时间,必填,格式:yyyy-MM-dd,根据searchFieldTime字段确定查询维度 |
| 2 | startTime | 开始时间 | string | — | Optional | 开始时间,必填,格式:yyyy-MM-dd,根据searchFieldTime字段确定查询维度 |
| 3 | length | 分页长度 | integer | — | Optional | 分页长度 |
| 4 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量 |
| 5 | purchaserIds | 采购方ID列表 | array<any> | — | Optional | 采购方ID列表,筛选指定采购方的其他费用 |
| 6 | searchField | 搜索字段 | string | — | Optional | 搜索字段,枚举值:order_sn-采购单号, create_username-采购员,配合searchValue使用 |
| 7 | searchFieldTime | 时间维度 | string | — | Optional | 时间维度,枚举值:create_time-创建时间, close_time-付清时间,默认create_time |
| 8 | searchValue | 搜索值 | string | — | Optional | 搜索值,根据searchField字段进行搜索,支持模糊查询 |
| 9 | status | 付款状态 | integer | — | Optional | 付款状态,枚举值:0-查询未付清, 1-查询已付清,不传默认查询全部 |
| 10 | supplierIds | 应付对象ID列表 | array<any> | — | Optional | 应付对象ID列表,筛选指定供应商的其他费用 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 响应码 | integer | — | Required | 响应码 |
| 2 | data | 返回数据 | object | — | Required | 返回数据 |
| 2.1 | list | 列表数据 | array<object> | — | Required | 列表数据 |
| 2.1.1 | amountNotPaid | 未付金额 | string | 2500 | Required | 未付金额,还需支付的金额 |
| 2.1.2 | amountPaid | 已付金额 | string | 1500.5 | Required | 已付金额,已完成支付的金额 |
| 2.1.3 | applyedAmount | 已请款金额 | string | 3500 | Required | 已请款金额,已完成请款的金额 |
| 2.1.4 | applyedDiscount | 已请款折扣 | string | 50 | Required | 已请款折扣,已完成请款的折扣金额 |
| 2.1.5 | applyedGoodsValue | 已请款货值 | string | 4500 | Required | 已请款货值,已完成请款的货物价值 |
| 2.1.6 | applyingAmount | 申请中金额 | string | 2000 | Required | 申请中金额,正在请款流程中的金额 |
| 2.1.7 | applyingDiscount | 请款中折扣 | string | 30 | Required | 请款中折扣,正在请款流程中的折扣金额 |
| 2.1.8 | applyingGoodsValue | 请款中货值 | string | 3000 | Required | 请款中货值,正在请款流程中的货物价值 |
| 2.1.9 | applyingOrders | 请款中订单ID列表 | array<any> | [54321,98765] | Required | 请款中订单ID列表,正在请款流程中的订单 |
| 2.1.10 | closeDate | 结清日期 | string | 2024-11-15 | Required | 结清日期,格式:yyyy-MM-dd,完成付清的日期 |
| 2.1.11 | closeTime | 结清时间戳 | integer | 1700000000 | Required | 结清时间戳,完成付清的时间戳(秒) |
| 2.1.12 | closedByUid | 结清操作人UID | integer | 1234567890 | Required | 结清操作人UID,完成付清的用户ID |
| 2.1.13 | closedByUser | 结清操作人姓名 | string | 张三 | Required | 结清操作人姓名,完成付清的操作人员 |
| 2.1.14 | closedRemark | 结清备注 | string | 已全额付清 | Required | 结清备注,付清时填写的备注说明 |
| 2.1.15 | currency | 币种代码 | string | CNY | Required | 币种代码,费用金额使用的货币类型,如:CNY、USD |
| 2.1.16 | customOrderSn | 自定义单号 | string | CUSTOM-2024-001 | Required | 自定义单号,用户自定义的订单编号 |
| 2.1.17 | discountAmount | 折扣金额 | string | 100 | Required | 折扣金额,优惠折扣的金额 |
| 2.1.18 | fee | 费用金额 | string | 5000 | Required | 费用金额,其他费用的总金额 |
| 2.1.19 | feeTypeId | 费用类型ID | integer | 1234567890 | Required | 费用类型ID,费用分类的唯一标识 |
| 2.1.20 | feeTypeName | 费用类型名称 | string | 运输费 | Required | 费用类型名称,费用分类的名称 |
| 2.1.21 | icon | 图标标识 | string | icon_other_fee.png | Required | 图标标识,费用类型的图标地址或标识 |
| 2.1.22 | id | 其他费用记录ID | integer | 1001 | Required | 其他费用记录ID,唯一标识 |
| 2.1.23 | isAutoDone | 是否自动完成 | integer | 0 | Required | 是否自动完成,枚举值:0-否, 1-是,标识是否系统自动结清 |
| 2.1.24 | notApplyAmount | 未请款金额 | string | 1000 | Required | 未请款金额,还未发起请款的金额 |
| 2.1.25 | optRealname | 采购员 | string | 李四 | Required | 采购员 |
| 2.1.26 | optUid | 创建操作人UID | integer | 1234567890 | Required | 创建操作人UID,创建该费用的用户ID |
| 2.1.27 | orderSn | 订单编号 | string | PO202401010001 | Required | 订单编号,关联的采购单号 |
| 2.1.28 | paidOrders | 已付款请款单ID列表 | array<any> | [12345,67890] | Required | 已付款请款单ID列表,记录已关联的付款单据 |
| 2.1.29 | payStatus | 付款状态 | integer | 2 | Required | 付款状态,枚举值:0-未申请, 1-申请中, 2-已申请, 3-已付清 |
| 2.1.30 | payStatusText | 付款状态文本描述 | string | 未付清 | Required | 付款状态文本描述,如:未付清、已付清等 |
| 2.1.31 | payableAmount | 应付金额 | string | 5000 | Required | 应付金额,需要支付的总金额 |
| 2.1.32 | purchaserId | 采购方ID | integer | 1234567890 | Required | 采购方ID,发起采购的组织或个人ID |
| 2.1.33 | purchaserName | 采购方名称 | string | 深圳采购中心 | Required | 采购方名称,发起采购的组织或个人名称 |
| 2.1.34 | supplierId | 应付对象ID | integer | 1234567890 | Required | 应付对象ID,供应商或应付方的ID |
| 2.1.35 | supplierName | 应付对象名称 | string | 顺丰物流 | Required | 应付对象名称,供应商或应付方的名称 |
| 2.1.36 | unapplyGoodsValue | 未请款货值 | string | 1500 | Required | 未请款货值,还未发起请款的货物价值 |
| 2.1.37 | updateUid | 更新操作人UID | integer | 1234567890 | Required | 更新操作人UID,最后修改该记录的用户ID |
| 2.1.38 | wareHouseName | 仓库名称 | string | 华南仓库 | Required | 仓库名称,关联的仓库名称 |
| 2.1.39 | wid | 仓库ID | integer | 1234567890 | Required | 仓库ID,关联的仓库唯一标识 |
| 2.2 | total | 总记录数 | integer | 100 | Required | 总记录数 |
| 3 | error_details | 错误详情 | array<any> | — | Required | 错误详情 |
| 4 | message | 提示信息 | string | — | Required | 提示信息 |
| 5 | request_id | 请求id | string | — | Required | 请求id |
| 6 | response_time | 响应时间 | string | — | Required | 响应时间 |
| 7 | total | 总记录数 | integer | — | Required | 总记录数 |
The 查询请款池 - 其他费用 API (/basicOpen/finance/requestFundsPool/otherFee/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.