预算使用详情查询

  • url: common/budgets/v2/glBudgetBalance/findByCidsAndPeriods
  • method: GET
  • 数据格式：json
  • 说明: 预算使用详情查询——占用或消耗

预算总占用/消耗 = budget_amount + rollup_amount

参数

请求参数（RequestParams）

字段名称 字段类型 字段描述 是否必填 长度限制
bizId String 当前请求唯一标识 TRUE 36
timestamp long 当前请求对应的时间戳 TRUE 13
cids List<Long> 预算维度组合cid列表 TRUE 200
periodIds List<Long> 财年period_id列表 TRUE 200

返回参数

  • 说明： data 为数组，data[] 表示数组中元素（对象）
字段名称 字段类型 字段描述
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 最新预算记录的transaction_id
data[].last_update_date Long 最后更新时间(时间戳)

示例

请求数据

完整 URL：

/common/budgets/v2/glBudgetBalance/findByCidsAndPeriods?bizId=a1ac76ab-58e6-419d-8798-8aefaaab7f99&timestamp=1673798400000&cids=41549&cids=78762&cids=6178&cids=78751&cids=35950&cids=6008&cids=35949&periodIds=1791&periodIds=1689

参数拆解：

参数 值
bizId a1cc76ab-58e6-419d-8798-8aefaaab7f66
timestamp 1673798400000
cids 41549
cids 78762
cids 6178
cids 78751
cids 35950
cids 6008
cids 35949
periodIds 1791
periodIds 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
        }
    ]
}

results matching ""

    No results matching ""