预算余额详情查询
- url: common/budgets/v2/glBudgetBalance/findByCidsAndPeriods
- method: GET
- 数据格式：json
- 说明: 预算余额详情查询
预算总占用/消耗 = budget_amount + rollup_amount
参数
请求参数
| 字段名称 |
字段类型 |
字段描述 |
是否必填 |
长度限制 |
| bizId |
String |
当前请求唯一标识 |
TRUE |
36 |
| timestamp |
long |
当前请求对应的时间戳 |
TRUE |
13 |
| cids |
Array |
组合维度cid集合 |
TRUE |
200 |
| periodIds |
Array |
财年period_id集合 |
TRUE |
200 |
返回参数
| 字段名称 |
字段类型 |
字段描述 |
| bizId |
String |
当前次接口同步的唯一标识 |
| resCode |
Integer |
响应状态码（见附录） |
| resMsg |
String |
返回信息描述 |
| data |
Array |
当前请求的数据集合 |
| data.company_id |
Long |
公司ID |
| data.cid |
Long |
预算组合维度ID |
| data.gl_period |
Long |
预算财年ID |
| data.budget_status |
String |
预算余额状态(expense: 消耗; request: 占用) |
| data.budget_amount |
BigDecimal |
预算金额原始值 |
| data.rollup_amount |
BigDecimal |
项目金额卷积值 |
| data.last_trx_id |
Long |
表gl_budget_transaction_rollup.transaction_id |
| data.last_update_date |
Long |
最后更新时间(时间戳) |
示例
请求数据
{
"bizId": "a1ac76ab-58e6-419d-8798-8aefaaab7f99",
"timestamp": 1673798400000,
"cids": [41549, 78762, 6178, 78751, 35950, 6008, 35949, 35949],
"periodIds": [1791, 1689]
}
返回数据
{
"resCode": 200000,
"resMsg": "success",
"bizId": "a1ac76ab-58e6-419d-8798-8aefaaab7f99",
"data": [
{
"last_update_date": 1675130563000,
"company_id": 3809,
"cid": 6008,
"gl_period": 1689,
"budget_status": "expense",
"budget_amount": 0.00,
"rollup_amount": 210935.00,
"last_trx_id": 104442
},
{
"last_update_date": 1655799647000,
"company_id": 3809,
"cid": 6008,
"gl_period": 1689,
"budget_status": "request",
"budget_amount": 0.00,
"rollup_amount": 915480.00,
"last_trx_id": 77190
},
{
"last_update_date": 1629775917000,
"company_id": 3809,
"cid": 6178,
"gl_period": 1689,
"budget_status": "expense",
"budget_amount": 0.00,
"rollup_amount": 96433.00,
"last_trx_id": 12142
},
{
"last_update_date": 1630479952000,
"company_id": 3809,
"cid": 6178,
"gl_period": 1689,
"budget_status": "request",
"budget_amount": 0.00,
"rollup_amount": 977908.00,
"last_trx_id": 11982
},
{
"last_update_date": 1673948239000,
"company_id": 3809,
"cid": 6178,
"gl_period": 1791,
"budget_status": "expense",
"budget_amount": 0.00,
"rollup_amount": 50.00,
"last_trx_id": 104436
},
{
"last_update_date": 1675213677000,
"company_id": 3809,
"cid": 6178,
"gl_period": 1791,
"budget_status": "request",
"budget_amount": 0.00,
"rollup_amount": 21828.00,
"last_trx_id": 104444
},
{
"last_update_date": 1675130563000,
"company_id": 3809,
"cid": 35949,
"gl_period": 1689,
"budget_status": "expense",
"budget_amount": 134558.00,
"rollup_amount": 1100.00,
"last_trx_id": 104442
},
{
"last_update_date": 1675130563000,
"company_id": 3809,
"cid": 35949,
"gl_period": 1689,
"budget_status": "request",
"budget_amount": 896813.00,
"rollup_amount": 0.00,
"last_trx_id": 13791
},
{
"last_update_date": 1675130563000,
"company_id": 3809,
"cid": 35950,
"gl_period": 1689,
"budget_status": "expense",
"budget_amount": 0.00,
"rollup_amount": 206014.00,
"last_trx_id": 104442
},
{
"last_update_date": 1649772378000,
"company_id": 3809,
"cid": 35950,
"gl_period": 1689,
"budget_status": "request",
"budget_amount": 0.00,
"rollup_amount": 908885.00,
"last_trx_id": 40198
},
{
"last_update_date": 1675213677000,
"company_id": 3809,
"cid": 41549,
"gl_period": 1791,
"budget_status": "request",
"budget_amount": 0.00,
"rollup_amount": 350.00,
"last_trx_id": 104444
},
{
"last_update_date": 1675213677000,
"company_id": 3809,
"cid": 78751,
"gl_period": 1791,
"budget_status": "request",
"budget_amount": 250.00,
"rollup_amount": 50.00,
"last_trx_id": 104444
},
{
"last_update_date": 1675213677000,
"company_id": 3809,
"cid": 78762,
"gl_period": 1791,
"budget_status": "request",
"budget_amount": 0.00,
"rollup_amount": 300.00,
"last_trx_id": 104444
}
]
}