预提台账查询接口 V2
说明
该接口用于查询预提台账
请求类型
post
接口地址
/api/openapi/expense/accrual/standingbook/query/V2
请求参数
参数说明
| 字段名 | 类型 | 说明 | 必填性 |
|---|---|---|---|
| requestUserEmployeeId | string | 查询人工号 | 必填 |
| accrualPeriod | string | 预提期间格式：yyyy-MM | 必填 |
| accrualNum | string | 预提编号支持模糊搜索 | 非必填 |
| formCodeList | Array[String] | 申请单号列表，最多 10 个，按单号精确匹配；不传或传空列表时不按申请单号筛选 | 非必填 |
| status | Array[String] | 预提状态 枚举值： OPEN 开启 CLOSED 关闭 INVALID 已作废 |
非必填 |
| departmentBizCodeList | Array[String] | 筛选条件部门业务编码 | 非必填 |
| expenseTypeBizCodeList | Array[String] | 筛选条件费用类型业务编码 | 非必填 |
| legalEntityBizCodeList | Array[String] | 筛选条件公司抬头业务编码 | 非必填 |
| accrualReversalType | string | 预提单冲销方式 枚举值： BALANCE_REVERSAL 差额回冲 FULL_REVERSAL 全额回冲 |
非必填 |
| start | number | 分页起始位置从0开始。默认0 | 必填 |
| length | number | 分页条数默认20最大100 | 必填 |
headers：
| 字段名 | 类型 | 说明 | 必填性 |
|---|---|---|---|
| lang | String | 语言环境 | 非必填 默认：zh 中文-zh 英文-en |
参数示例
{
"requestUserEmployeeId": "YYZ002",
"accrualPeriod": "2021-12",
"departmentBizCodeList": [
"DP1"
],
"expenseTypeBizCodeList": [
"CORP001"
],
"legalEntityBizCodeList": [
"ELC21042811WLNPXC"
],
"status": [
"OPEN"
],
"accrualNum": "",
"start": 0,
"length": 20,
"formCodeList": [
"MK21120320",
"MK21120321"
]
}
申请单号筛选与预提期间、部门、费用类型、公司抬头等条件共同生效。传入的申请单号均未命中时返回空列表；不传或传空列表时，保留原有查询范围。accrualPeriod 和查询人工号仍为必填参数。
响应参数
参数说明
| 字段名 | 类型 | 说明 |
|---|---|---|
| hasNextPage | boolean | 是否有下一页 |
| list | Array[AccrualStandingBook] | 预提台账 |
AccrualStandingBook
| 字段名 | 类型 | 说明 |
|---|---|---|
| accrualNum | string | 预提编号 |
| accrualPeriod | string | 预提期间格式：yyyy-MM |
| accrualBookCode | string | 预提台账内码；核销明细通过同名字段关联此台账 |
| targetType | string | 预提来源粒度：ALLOCATION 来源单据分摊，EXPENSE 来源单据费用；来源单据类型由 formType 确定 |
| targetCode | string | 预提来源单据的分摊明细内码；未分摊时为费用内码，由 formType、targetType 确定。申请单场景对应申请单的分摊或费用内码 |
| expenseTypeBizCode | string | 费用类型业务编码 |
| expenseTypeName | string | 费用类型名称 |
| legalEntityBizCode | string | 公司抬头业务编码 |
| legalEntityName | string | 公司抬头名称 |
| departmentBizCode | string | 预提部门业务编码 |
| departmentName | string | 预提部门名称 |
| coverUserEmployeeId | string | 归属人工号 |
| coverUserName | string | 归属人姓名 |
| accrualAmount | AmountInput | 预提金额 |
| accrualNonTaxAmount | AmountInput | 预提不含税金额（原币），沿用台账保存的税处理后记账金额；历史台账无该金额快照时为空 |
| reversalAmount | AmountInput | 已冲销金额 |
| reversalNonTaxAmount | AmountInput | 已核销不含税金额（原币），累计已核销明细中保存的金额 |
| processingNonTaxAmount | AmountInput | 流程中核销不含税金额（原币），累计流程中核销明细中保存的金额 |
| pendingAmount | AmountInput | 未冲销金额 |
| status | string | 预提状态 枚举值： **OPEN** 开启** CLOSED **关闭**INVALID** 已作废 |
| accrualFormCode | string | 预提单据号 |
| formType | string | 枚举值：REIMBURSE 报销单PRECONSUME 预提单（申请单） |
| accrualVoucherStatus | string | 预提凭证生成状态 枚举值： **GENERATE** 已生成**NO_GENERATE** 未生成 |
| accrualReversalType | string | 预提单冲销方式 枚举值： BALANCE_REVERSAL 差额回冲 FULL_REVERSAL 全额回冲 |
| accrualVoucherNum | string | 预提凭证编号 |
| variance | bool | 有无差异 |
| VarianceAmount | 差异 | |
| varianceVoucherNum | string | 差异凭证编号 |
| coveredRecords | Array[CoveredRecord] | 已核销记录，精确到分摊或费用级 |
| toCoveredRecords | Array[CoveredRecord] | 流程中核销记录，精确到分摊或费用级 |
| tradingPartnerBizCode | string | 往来单位bizCode |
| tradingPartnerName | string | 往来单位名称 |
| closeTime | Date | 预提关闭时间 |
CoveredRecord
| 字段名 | 类型 | 说明 |
|---|---|---|
| accrualBookCode | string | 关联的预提台账内码，对应父级台账的 accrualBookCode |
| targetType | string | 核销来源粒度：ALLOCATION 核销来源单据分摊，EXPENSE 核销来源单据费用；报销场景为报销单 |
| targetCode | string | 核销来源单据的分摊明细内码；未分摊时为费用内码，由 targetType 区分。报销场景对应报销单的分摊或费用内码 |
| expenseTypeBizCode | string | 费用类型业务编码 |
| expenseTypeName | string | 费用类型名称 |
| consumeTime | number | 消费时间13位时间戳 |
| reversalAmount | AmountInput | 核销金额 |
| reversalNonTaxAmount | AmountInput | 本次核销不含税金额（原币），读取该条核销记录保存的金额 |
| matchMode | string | 本次核销的匹配模式：DETAIL_ALLOCATION_RATIO 按明细分摊比例、SPECIFIED_DIMENSION 按指定维度匹配；历史记录无匹配快照时为空 |
| matched | boolean | 按指定维度的匹配结果：true 已匹配，false 未匹配；无匹配快照或非指定维度模式时为空 |
| formCode | string | 关联单据号 |
| reversalVoucherState | string | 核销凭证生成状态 |
| reversalVoucherNum | string | 核销凭证编号 |
| lastReversal | boolean | 是否为最后一次核销 |
台账的 targetType、targetCode 标识预提来源单据的分摊或费用，来源单据类型由 formType 确定；核销明细中的同名字段标识核销来源单据的分摊或费用，通过 accrualBookCode 关联两端。申请单生成预提、报销单核销时，两端分别对应申请单和报销单。没有分摊时返回费用级内码，不生成分摊内码。
matchMode 描述本次核销按分摊比例还是指定维度匹配，与 accrualReversalType 的差额回冲、全额回冲含义不同。matched 根据保存的指定维度匹配快照返回，不能用历史记录缺少快照来判断“未匹配”。
新增金额字段均沿用持久化的税处理和原币口径，不根据当前费用、当前税率重新计算。申请明细的发票类型和税率请通过申请单详情 V2 查询，台账接口不重复返回。
参数示例
{
"code": "ACK",
"message": "",
"data": {
"hasNextPage": true,
"list": [
{
"accrualNum": "YuTi202112310004",
"accrualPeriod": "2021-12",
"expenseTypeBizCode": null,
"expenseTypeName": "对私预提费用类型",
"legalEntityBizCode": "ELC2105201HOC0RNK",
"legalEntityName": "GJM测试专用U8V12抬头",
"departmentBizCode": "devolop",
"departmentName": "研发部",
"coverUserEmployeeId": "G001",
"coverUserName": "小明",
"tradingPartnerBizCode": "AAddd",
"tradingPartnerName": "高架道路寄过来的",
"accrualAmount": {
"amount": 318,
"currency": "CNY",
"customExchangeRate": 1,
"amountStr": "￥318.00"
},
"reversalAmount": {
"amount": 106,
"currency": "CNY",
"customExchangeRate": 1,
"amountStr": "￥106.00"
},
"pendingAmount": {
"amount": 212,
"currency": "CNY",
"customExchangeRate": 1,
"amountStr": "￥212.00"
},
"status": "OPEN",
"accrualFormCode": "MK21120320",
"accrualVoucherStatus": "GENERATE",
"accrualVoucherNum": "VIN2112311FN5DDS0",
"variance": false,
"VarianceAmount": null,
"varianceVoucherNum": "",
"coveredRecords": [
{
"accrualBookCode": "ASB261029001",
"targetType": "ALLOCATION",
"targetCode": "RA261029001",
"expenseTypeBizCode": "CORP001",
"expenseTypeName": "预提费用",
"consumeTime": 1793203200000,
"reversalAmount": {
"amount": 106,
"currency": "CNY"
},
"reversalNonTaxAmount": {
"amount": 100,
"currency": "CNY"
},
"matchMode": "SPECIFIED_DIMENSION",
"matched": true,
"formCode": "BX261029001",
"reversalVoucherState": "GENERATE",
"reversalVoucherNum": "VIN261029001",
"lastReversal": false
}
],
"closeTime": "2021-12-31 00:00:00",
"accrualBookCode": "ASB261029001",
"targetType": "ALLOCATION",
"targetCode": "AA261029001",
"formType": "PRECONSUME",
"accrualNonTaxAmount": {
"amount": 300,
"currency": "CNY"
},
"reversalNonTaxAmount": {
"amount": 100,
"currency": "CNY"
},
"processingNonTaxAmount": {
"amount": 50,
"currency": "CNY"
},
"toCoveredRecords": [
{
"accrualBookCode": "ASB261029001",
"targetType": "ALLOCATION",
"targetCode": "RA261029002",
"expenseTypeBizCode": "CORP001",
"expenseTypeName": "预提费用",
"consumeTime": 1793203200000,
"reversalAmount": {
"amount": 53,
"currency": "CNY"
},
"reversalNonTaxAmount": {
"amount": 50,
"currency": "CNY"
},
"matchMode": "SPECIFIED_DIMENSION",
"matched": true,
"formCode": "BX261029002",
"reversalVoucherState": "NO_GENERATE",
"reversalVoucherNum": "",
"lastReversal": false
}
]
},
{
"accrualNum": "YuTi202112310003",
"accrualPeriod": "2021-12",
"expenseTypeBizCode": null,
"expenseTypeName": "对私预提费用类型",
"legalEntityBizCode": "ELC2105201HOC0RNK",
"legalEntityName": "GJM测试专用U8V12抬头",
"departmentBizCode": "devolop",
"departmentName": "研发部",
"coverUserEmployeeId": "G001",
"coverUserName": "小明",
"tradingPartnerBizCode": "AAddd",
"tradingPartnerName": "高架道路寄过来的",
"accrualAmount": {
"amount": 240.0,
"currency": "CNY",
"customExchangeRate": 1,
"amountStr": "￥240.00"
},
"reversalAmount": {
"amount": 0.0,
"currency": "CNY",
"customExchangeRate": 1,
"amountStr": "￥0.00"
},
"pendingAmount": {
"amount": 240.0,
"currency": "CNY",
"customExchangeRate": 1,
"amountStr": "￥240.00"
},
"status": "INVALID",
"accrualFormCode": "MK21120320",
"accrualVoucherStatus": "NO_GENERATE",
"accrualVoucherNum": null,
"variance": false,
"VarianceAmount": null,
"varianceVoucherNum": "",
"coveredRecords": [],
"closeTime": "2021-12-31 00:00:00",
"accrualBookCode": "ASB261029002",
"targetType": "EXPENSE",
"targetCode": "AE261029002",
"formType": "PRECONSUME",
"accrualNonTaxAmount": null,
"reversalNonTaxAmount": {
"amount": 0,
"currency": "CNY"
},
"processingNonTaxAmount": {
"amount": 0,
"currency": "CNY"
},
"toCoveredRecords": []
}
]
},
"errorCode": null,
"success": true
}
更新说明
- 2026-03-09 新增入参，返参 **accrualReversalType** 预提冲销方式
- 2026-04-08 新增预提台账关闭时间字段
- 2026-10-29 DB-63267 新增申请单号列表筛选，以及分摊级关联、匹配模式和结果、预提及核销不含税金额；补充流程中核销明细，响应列表字段对齐为 list