The consolidated capex plan: one row for each capex proposal approved for the consolidation plan, made when it was…

curl --request GET \
  --url https://app.assetinfinity.ai/api/capex_consolidated_lines

const options = {method: 'GET'};

fetch('https://app.assetinfinity.ai/api/capex_consolidated_lines', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://app.assetinfinity.ai/api/capex_consolidated_lines",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "https://app.assetinfinity.ai/api/capex_consolidated_lines"

	req, _ := http.NewRequest("GET", url, nil)

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

require 'uri'
require 'net/http'

url = URI("https://app.assetinfinity.ai/api/capex_consolidated_lines")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Get.new(url)

response = http.request(request)
puts response.read_body

[
  {
    "approved_carryover_amount": 123,
    "asset_block_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "asset_block_name": "<string>",
    "budget_category_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "budget_category_name": "<string>",
    "business_unit_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "capex_nature_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "capex_plan_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "capex_plan_line_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "carried_from_code": "<string>",
    "carried_from_line_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "carryover_cashflow_cy": 123,
    "carryover_order_reference": "<string>",
    "category": "<string>",
    "category_master_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "category_master_name": "<string>",
    "coordinator_name": "<string>",
    "coordinator_user_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "created_at": "<string>",
    "currency_code": "<string>",
    "currency_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "depreciation_rate_percent": 123,
    "division_name": "<string>",
    "fiscal_calendar_name": "<string>",
    "fiscal_year": 123,
    "fiscal_year_start_month": 123,
    "fresh_sanction_amount": 123,
    "gst_rate_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "gst_rate_name": "<string>",
    "gst_rate_percent": 123,
    "id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "investment_type": "<string>",
    "item_description": "<string>",
    "justification": "<string>",
    "last_approved_at": "<string>",
    "last_approved_by_name": "<string>",
    "last_approved_by_user_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "location_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "location_name": "<string>",
    "may_edit": true,
    "may_send": true,
    "nature_name": "<string>",
    "plan_code": "<string>",
    "plan_name": "<string>",
    "planning_needs": [
      "<string>"
    ],
    "planning_open": true,
    "priority": "<string>",
    "proposal_status": "<string>",
    "proposal_status_at": "<string>",
    "proposal_status_reason": "<string>",
    "py1_carryover_outflow": 123,
    "py1_carryover_total": 123,
    "py1_cashflow_balanced": true,
    "py1_cashflow_total": 123,
    "py1_fresh_outflow": 123,
    "py1_gst_credit": 123,
    "py1_gst_credit_total": 123,
    "py1_month_01": 123,
    "py1_month_01_gst": 123,
    "py1_month_02": 123,
    "py1_month_02_gst": 123,
    "py1_month_03": 123,
    "py1_month_03_gst": 123,
    "py1_month_04": 123,
    "py1_month_04_gst": 123,
    "py1_month_05": 123,
    "py1_month_05_gst": 123,
    "py1_month_06": 123,
    "py1_month_06_gst": 123,
    "py1_month_07": 123,
    "py1_month_07_gst": 123,
    "py1_month_08": 123,
    "py1_month_08_gst": 123,
    "py1_month_09": 123,
    "py1_month_09_gst": 123,
    "py1_month_10": 123,
    "py1_month_10_gst": 123,
    "py1_month_11": 123,
    "py1_month_11_gst": 123,
    "py1_month_12": 123,
    "py1_month_12_gst": 123,
    "py1_outflow": 123,
    "py1_outflow_difference": 123,
    "py1_proposed_plan": 123,
    "py2_gst_credit": 123,
    "py2_outflow": 123,
    "py2_py5_outflow": 123,
    "py3_gst_credit": 123,
    "py3_outflow": 123,
    "py4_gst_credit": 123,
    "py4_outflow": 123,
    "py5_gst_credit": 123,
    "py5_outflow": 123,
    "quantity": 123,
    "request_display_status": "<string>",
    "request_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "scheme_code": "<string>",
    "scheme_value": 123,
    "site_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "site_name": "<string>",
    "updated_at": "<string>"
  }
]

Capex consolidation

The consolidated capex plan: one row for each capex proposal approved for the consolidation plan, made when it was…

The consolidated capex plan: one row for each capex proposal approved for the consolidation plan, made when it was approved.

What the proposal decided is read off it and cannot be changed here: fiscal_year (with fiscal_calendar_name, the fiscal calendar the plan is counted on, and fiscal_year_start_month, the month that calendar starts its year in, so fiscal_year 2027 starting in April is April 2026 to March 2027), scheme_code (the Request ID), the unit and location, category_master_id and budget_category_id (the Category and Sub-Category), priority (the Item Type: VITAL, ESSENTIAL or DESIRABLE), investment_type (NEW or CARRY_FORWARD), carried_from_line_id (the Reference ID), scheme_value (the Capex Amount) and category (PROJECT, SPECIFIED, CLUBBED or FLEXIBLE). proposal_status is the proposal’s: APPROVED_FOR_PLAN while it is being planned, then PLAN_APPROVED or PLAN_REJECTED.

The coordinator, item_description, quantity, nature, fresh_sanction_amount, approved_carryover_amount and justification started as the proposal had them and are changed here without changing the proposal. The rest is planning: carryover_cashflow_cy (the approved cashflow of the current year carried forward) and carryover_order_reference for a carry forward; py1_carryover_outflow and py1_fresh_outflow, the estimated cash outflow in the planned year (PY1); py2_outflow to py5_outflow for the four years after it; gst_rate_id, the GST rate, a value of your organisation’s GST Rate Master list, with gst_rate_name its name and gst_rate_percent its rate as a whole percentage; py1_month_01 to py1_month_12, the planned year’s cash flow month by month from its first month; and asset_block_id, the asset block, a value of your organisation’s Asset Block Master list, with asset_block_name its name. depreciation_rate_percent is the Applicable Depreciation: the block’s depreciation rate as a whole percentage, as the block had it when the row was saved with it. It is kept while the row keeps that block, so a rate changed on the list afterwards does not change a row already planned; it is null where the block had no rate.

Worked out, never stored: py1_carryover_total is carryover_cashflow_cy plus approved_carryover_amount; py1_proposed_plan is that plus fresh_sanction_amount; py1_outflow is py1_carryover_outflow plus py1_fresh_outflow; py1_outflow_difference is py1_proposed_plan less py1_outflow; py2_py5_outflow is the four outer years added up; py1_cashflow_total is the twelve months added up, and py1_cashflow_balanced whether it equals py1_outflow. Each _gst_credit and _gst column is the GST inside that figure, the figure divided by one plus the rate times the rate, rounded to two places, and null where the figure or the rate is missing; py1_gst_credit_total adds up the twelve months’ credit, and equals py1_gst_credit when the months are balanced, give or take rounding.

The planning is approved in a workflow of its own. A row goes to its first level by itself when its proposal is approved, and its approvers plan it while it waits on them; where no workflow holds it, it stays here for your organisation’s planners to plan and send with api.submit_capex_consolidated_line. When the last level approves, proposal_status is PLAN_APPROVED; a rejection at any level is PLAN_REJECTED.

request_id and request_display_status are the planning’s own approval request, the open one where there is one, as your approvals show it; null until the plan is sent for approval. last_approved_by_name and last_approved_at are who gave the planning its latest approval, and when. Both are null until a level of the planning approves it, and stay null for a plan approved at once because no workflow applied; the approval of the proposal itself is never shown here. planning_open says whether the planners can still change the row: they cannot once the plan is approved or rejected, or while it is with approvers. planning_needs lists, in the sheet’s words, what the row still needs before its planning can be approved or sent: any of the six mandatory fields (a GST rate whose value has no rate counting as missing), the carried cashflow of a carry forward, and the twelve months adding up to py1_outflow; it is empty when nothing. may_edit says whether you may change the row now: while it is with its approvers only the approver it waits on may, and otherwise anybody holding finance.capex_consolidation.edit. may_send says whether you may send it for approval.

You see every row of the plan if you may view the consolidated plan. Without that, you see a row only while a step of its planning approval is waiting on you under your own authority, so that you can plan it before you sign; once you have decided, it is gone from what you see.

GET

capex_consolidated_lines

The consolidated capex plan: one row for each capex proposal approved for the consolidation plan, made when it was…

curl --request GET \
  --url https://app.assetinfinity.ai/api/capex_consolidated_lines

const options = {method: 'GET'};

fetch('https://app.assetinfinity.ai/api/capex_consolidated_lines', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://app.assetinfinity.ai/api/capex_consolidated_lines",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "https://app.assetinfinity.ai/api/capex_consolidated_lines"

	req, _ := http.NewRequest("GET", url, nil)

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

require 'uri'
require 'net/http'

url = URI("https://app.assetinfinity.ai/api/capex_consolidated_lines")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Get.new(url)

response = http.request(request)
puts response.read_body

[
  {
    "approved_carryover_amount": 123,
    "asset_block_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "asset_block_name": "<string>",
    "budget_category_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "budget_category_name": "<string>",
    "business_unit_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "capex_nature_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "capex_plan_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "capex_plan_line_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "carried_from_code": "<string>",
    "carried_from_line_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "carryover_cashflow_cy": 123,
    "carryover_order_reference": "<string>",
    "category": "<string>",
    "category_master_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "category_master_name": "<string>",
    "coordinator_name": "<string>",
    "coordinator_user_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "created_at": "<string>",
    "currency_code": "<string>",
    "currency_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "depreciation_rate_percent": 123,
    "division_name": "<string>",
    "fiscal_calendar_name": "<string>",
    "fiscal_year": 123,
    "fiscal_year_start_month": 123,
    "fresh_sanction_amount": 123,
    "gst_rate_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "gst_rate_name": "<string>",
    "gst_rate_percent": 123,
    "id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "investment_type": "<string>",
    "item_description": "<string>",
    "justification": "<string>",
    "last_approved_at": "<string>",
    "last_approved_by_name": "<string>",
    "last_approved_by_user_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "location_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "location_name": "<string>",
    "may_edit": true,
    "may_send": true,
    "nature_name": "<string>",
    "plan_code": "<string>",
    "plan_name": "<string>",
    "planning_needs": [
      "<string>"
    ],
    "planning_open": true,
    "priority": "<string>",
    "proposal_status": "<string>",
    "proposal_status_at": "<string>",
    "proposal_status_reason": "<string>",
    "py1_carryover_outflow": 123,
    "py1_carryover_total": 123,
    "py1_cashflow_balanced": true,
    "py1_cashflow_total": 123,
    "py1_fresh_outflow": 123,
    "py1_gst_credit": 123,
    "py1_gst_credit_total": 123,
    "py1_month_01": 123,
    "py1_month_01_gst": 123,
    "py1_month_02": 123,
    "py1_month_02_gst": 123,
    "py1_month_03": 123,
    "py1_month_03_gst": 123,
    "py1_month_04": 123,
    "py1_month_04_gst": 123,
    "py1_month_05": 123,
    "py1_month_05_gst": 123,
    "py1_month_06": 123,
    "py1_month_06_gst": 123,
    "py1_month_07": 123,
    "py1_month_07_gst": 123,
    "py1_month_08": 123,
    "py1_month_08_gst": 123,
    "py1_month_09": 123,
    "py1_month_09_gst": 123,
    "py1_month_10": 123,
    "py1_month_10_gst": 123,
    "py1_month_11": 123,
    "py1_month_11_gst": 123,
    "py1_month_12": 123,
    "py1_month_12_gst": 123,
    "py1_outflow": 123,
    "py1_outflow_difference": 123,
    "py1_proposed_plan": 123,
    "py2_gst_credit": 123,
    "py2_outflow": 123,
    "py2_py5_outflow": 123,
    "py3_gst_credit": 123,
    "py3_outflow": 123,
    "py4_gst_credit": 123,
    "py4_outflow": 123,
    "py5_gst_credit": 123,
    "py5_outflow": 123,
    "quantity": 123,
    "request_display_status": "<string>",
    "request_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "scheme_code": "<string>",
    "scheme_value": 123,
    "site_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "site_name": "<string>",
    "updated_at": "<string>"
  }
]

Headers

Range

string

Limiting and Pagination

Range-Unit

string

default:items

Limiting and Pagination

Prefer

enum<string>

Preference

Available options:

count=none

Query Parameters

string

capex_plan_line_id

string

created_at

string

updated_at

string

capex_plan_id

string

plan_code

string

plan_name

string

fiscal_year

string

fiscal_year_start_month

string

fiscal_calendar_name

string

business_unit_id

string

division_name

string

scheme_code

string

site_id

string

site_name

string

location_id

string

location_name

string

category_master_id

string

category_master_name

string

budget_category_id

string

budget_category_name

string

priority

string

investment_type

string

carried_from_line_id

string

carried_from_code

string

scheme_value

string

Response

approved_carryover_amount

number<numeric>

asset_block_id

string<uuid>

Note: This is a Foreign Key to capex_asset_blocks.id.

asset_block_name

string<character varying>

Maximum string length: 150

budget_category_id

string<uuid>

Note: This is a Foreign Key to capex_asset_blocks.id.

budget_category_name

string<character varying>

Maximum string length: 150

business_unit_id

string<uuid>

Note: This is a Foreign Key to business_units.id.

capex_nature_id

string<uuid>

Note: This is a Foreign Key to capex_natures.id.

capex_plan_id

string<uuid>

Note: This is a Foreign Key to capex_plans.id.

capex_plan_line_id

string<uuid>

Note: This is a Foreign Key to capex_plan_lines.id.

carried_from_code

string<character varying>

Maximum string length: 60

carried_from_line_id

string<uuid>

Note: This is a Foreign Key to capex_plan_lines.id.

carryover_cashflow_cy

number<numeric>

carryover_order_reference

string<character varying>

Maximum string length: 10