Static System Properties in Capex Management Module


Overview of Request Types and Properties

  1. GLOBAL Properties

    • Applicable across all request types, including CAPEX, EXPENDITURE, and BUDGET.

    • Retrieve or calculate data dynamically based on the context of the request.

    • Example: Fields such as Request Name, Project Leader, and Requested Amount store universal information critical for all workflows.

  2. CAPEX Properties

    • Specific to CAPEX requests, these properties manage data related to capital investments and projects.

    • Example: Fields like NPV (pre-decision), Payback Period, and Total Capex Amount provide detailed financial metrics for evaluating investment proposals.

  3. EXPENDITURE Properties

    • Designed for expenditure requests, these properties handle data specific to financial outlays and budget line items.

    • Example: Fields such as Expense Type, Commitments, and Tax Depreciation focus on expenditure tracking and reporting.


Properties Applicable to Request Type GLOBAL

Properties of type GLOBAL store information across all request types—CAPEX, EXPENDITURE, and BUDGET—in Weissr Capex Management. With built-in logic, GLOBAL properties can retrieve or calculate data as needed and operate consistently regardless of the request type. In Capex and Budget requests, GLOBAL properties pull data from the original project source. In Expenditure requests, they hold data specific to the individual expenditure request.

Static System Properties Applicable to Request Type GLOBAL

Note: Property names in Weissr can be customized, so each instance may display different names for these properties.

ID

Property Type

Name

Code (original_name)

Description

1

String (single line)

Request name

name

A name describing the request/project. Mandatory for all projects.

2

String (multiline)

Background

description

A detailed comment explaining why the investment is needed, focusing on the root cause rather than symptoms.

3

Currency

Currency

currencyId

The local currency used by the organizational unit for the project.

5

User

Project leader

managerId

The user selected in this field can advance the request from the initial preparation step in the approval route. If no user is selected, only the creator of the request will be able to move it forward.

7

Node

Production unit

nodeId

Represents the organizational unit (node) associated with the project.

15

String (single line)

Project no.

projectSerialNumber

A unique serial number automatically generated by the system for each request or project. Example: 2762/001/b.

The project number format includes:

  • Production Unit ID: Identifies the specific production unit.

  • Sequence Number: Represents the unique order of the request within that production unit.

  • Request Type: b for the base request, with additional requests labeled sequentially as a1, a2, etc., in the order they are created.

22

Money

Requested amount

Total Capex Amount

The total of all expenditures (capex and opex) listed in the project's pre-decision "Capex" tab. After final approval, this amount is fixed and will not be updated with subsequent changes.

23

Date

Est. commissioning year

inUseYear

The estimated year when the project is expected to be operational.

34

Money

Total approved capex amount

Total approved capex amount

The combined total of the "Requested amount" and the "Additional capex amount". Not calculated in additional funding or reallocation requests.

36

Money

Total outcome

Total outcome

The sum of all listed expenditures (capex and opex) entered in the project’s post-decision "Capex" tab available after final approval. Not calculated in additional funding or reallocation requests.

41

Date

Forecast start date

forecastStartDate

Editable only in the execution phase. Expenditures before this date are considered actual and non-editable in the "Capex" tab. Expenditures after this date can be edited.

42

Money

Total spent amount

Total spent amount

The sum of all expenditures (capex and opex) listed in the project's "Capex" tab that occur before the "Forecast start date”. Calculated post-final approval; not updated in additional funding or reallocation requests.

44

User

Owner

createdByUser

The user who created the request/project. The creator can advance the request from the initial preparation step in the approval route.

68

String (single line)

External mapping ID

externalId

The project’s ID in an external system

69

Money

Decision amount total

Decision amount total

The approved amount at the time of final approval, excluding additional approved requests.

76

Money

Total capex amount

Total capex amount

The total pre-decision capex expenditure. Fixed after final approval.

77

Money

Total opex amount

Total opex amount

The total pre-decision opex expenditure. Fixed after final approval.

78

Code

Analysis period length

analysisPeriodLength

Defines the project's analysis period length. This determines the number of years available for adding expenditures and the length of the investment model.

81

Integer

ID

ID

The request ID is in the database. Table cm_request

83

Boolean

Modification in Capex

hasCapexChanges

Automatically set to TRUE when adjustments are made to expenditures (capex and opex) in the project's "Capex" tab.

86

Date

Creation date

Creation date

Automatically set to the date the project was created.


Properties Applicable to Request Type CAPEX

Properties of type CAPEX are properties that store information about requests and projects within Weissr Capex Management. These properties have built-in logic to serve specific functions, such as calculating or retrieving data automatically based on the system’s rules. Unlike configurable properties, the behavior of static CAPEX properties cannot be modified through configuration. In both Capex and Budget requests, CAPEX properties display data directly from the original Capex request source.

Static System Properties applicable to Request Type CAPEX

For some properties of type Money, the Code (original name) is set by default. However, in certain installations, this code may not appear automatically; if required for calculations, a support case should be opened to insert these values.

Note: Property names in Weissr can be customized, so each instance may display different names for these properties.

ID

Property Type

Name

Code (original_name)

Description

4

Fiscal Year

Include to budget

includeToBudget

The year when budget inclusion is expected or desired for the request/project.

6

Model

Model

modelId

Drop down selection of the available investment models that can be used depending on the characteristics of the request/project.

8

Route

Route

routeId

Defined routes based on investment size or approval authority.

9

String (single line)

strategyCategory

Strategy Category property. Removed in 5.1 Version

10

String (multiline)

strategyComments

Strategy Comments property. Removed in 5.1 Version

11

String (multiline)

strategyDescription

Strategy Description property. Removed in 5.1 Version

12

Year

strategyExitYear

Strategy Exit Year property. Removed in 5.1 Version

13

Decimal

strategyMaxPayBack

Strategy Max Payback property. Removed in 5.1 Version

14

Fiscal Year

Analysis start year

startOfPurchaseYear

Sets the first year in which data can be entered for both the Capex form and Cash Flow model. For example, if capexes and outlays start in 2024, enter 2024 in this field.

16

Money

NPV (Follow-up)

Value Development (follow up) or actualValueDevelopment

The Net Present Value (NPV) is calculated based on future cash flows (including expenditures) after final approval.

17

Decimal

Profitability Index (Follow-up)

actualProfitabilityIndex

The Profitability Index (PI), calculated as the present value of future cash flows divided by the present value of the investment. Calculated after final approval.

18

Decimal

Payback, disc. (Follow-up)

actualDiscountedPayBack

The discounted payback period, which calculates the time required to recover the costs of an investment. Calculated after final approval.

19

Money

NPV

Value Development (pre decision) or plannedValueDevelopment

The Net Present Value (NPV) is calculated based on future cash flows (including expenditures) before final approval. After final approval, this amount reflects the NPV at the time of approval and does not update with subsequent changes.

20

Decimal

Profitability Index

plannedProfitabilityIndex

The Profitability Index (PI) is calculated as the ratio of the present value of future cash flows to the present value of the investment. This calculation is performed before final approval. After final approval, the PI becomes fixed and will not update with any subsequent changes.

21

Decimal

Payback, disc.

plannedDiscountedPayBack

The discounted payback period, which calculates the time required to recover the costs of an investment. This calculation is performed before final approval. After final approval, the PI becomes fixed and will not update with any subsequent changes.

25

Money

Approved Budget amount

Approved Budget amount or approvedBudgetAmount

A non-editable field showing the amount approved for the project in a budget within the Capital Budgeting module, if it has been approved.

26

Current step

Current step

currentStepId

Indicates the current step the project is at within the approval route.

42

Money

Total spent amount

Total spent amount

The sum of all expenditures (capex and opex) listed in the project's "Capex" tab that occur before the "Forecast start date”. This value is calculated only after the final approval of the project. Only calculated in standard requests - not in any additional funding or reallocation requests.

27

Project state

Approval state

currentStateId

Represents the current state of the project based on its position in the approval route. Possible states include Draft, Under review, Decision, Monitoring, Follow-up, Completed, Rejected, or Undefined.

28

Fiscal Year

Postponed in approved budget

postponedInApprovedBudget

The year to which the project is postponed in the approved budget.

31

String (multiline)

Comment from budget

commentInApprovedBudget

Comments related to the project from the approved budget.

32

Approved in budget

Included in approved budget

includedInApprovedBudget

A non-editable field indicating whether the project is included in the current approved budget. Options include Yes, No, or Not decided. The field remains blank if no budget is approved.

33

Money

Additional capex amount

Supplemental capex amount

Contains the sum of the "Requested amount" from all additional requests that have received final approval. Not calculated in additional funding or reallocation requests.

34

Money

Total approved capex amount

Total approved capex amount

The combined total of the "Requested amount" and the "Additional capex amount". Not calculated in additional funding or reallocation requests.

35

User

Suggested decision maker

currentSuggestedDecisionUserId

The decision maker assigned to the current step in the approval route.

36

Money

Total outcome

Total outcome

The sum of all listed expenditures (capex and opex) entered in the project’s post-decision "Capex" tab available after final approval. Not calculated in additional funding or reallocation requests.

38

Money

Expected result

Average Cash Flow

Removed in 4.15 version.

39

Fiscal Year

Approved budget year

approvedBudgetYear

The budget year into which the request was included.

45

String (single line)

Status in approved budget

statusInApprovedBudget

Indicates the project's status in the current approved budget. Options include Not included, Rejected, Postponed, or Approved.

46

String (singleline)

Approved budget name

approvedBudgetName

The name of the approved budget in which the request is included.

65

Decimal

IRR (follow up), %

actualIrrRate

Internal Rate of Return (IRR), calculated on cash flow after final approval.

66

Decimal

IRR, %

plannedIrrRate

Internal Rate of Return (IRR), calculated on cash flow before final approval. After final approval, the IRR becomes fixed and will not update with any subsequent changes.

67

Date

Final approve date

finalApproveDate

Automatically set to the date when the project received final approval.

79

Money

Previous allocated amount

Previous allocated amount

Calculated in additional funding requests. It represents the sum of the "Requested amount" from the original request and all previous additional requests. This amount matches the "Total approved capex amount" in the original request at the time the additional request is created.

80

Money

Total allocated amount

Total allocated amount

Calculated in additional funding requests. It is the sum of the "Requested amount" from the original request, the current additional request, and any previous additional requests.

82

Integer

Investment program ID

investmentProgramId

The ID of the main request within an investment program.

84

Money

Total allocated capex amount

Total allocated capex amount

Calculated in additional funding requests. It is the sum of the "Total capex amount" from the original request, the current additional funding request, and any previous additional funding requests.

85

Money

Total allocated opex amount

Total allocated opex amount

Calculated in additional funding requests. It is the sum of the "Total opex amount" from the original request, the current additional funding request, and any previous additional funding requests.

92

Boolean

Is additional request

Is additional request

Automatically set to TRUE for additional requests, including new funding or transfer funding requests. Set to FALSE for standard requests/projects


Properties Applicable to Request Type EXPENDITURE

Properties of type EXPENDITURE are properties that store information about expenditure requests, line items in the expenditure grid within a capex request project within Weissr Capex Management. These properties have built-in logic to serve specific functions, such as calculating or retrieving data automatically based on the system’s rules. Unlike configurable properties, the behavior of static EXPENDITURE properties cannot be modified through configuration.

Static System Properties applicable to Request Type EXPENDITURE

For some properties of type Money, the Code (original name) is set by default. However, in certain installations, this code may not appear automatically; if required for calculations, a support case should be opened to insert these values.

Note: Property names in Weissr can be customized, so each instance may display different names for these properties.

ID

Property Type

Name

Code (original_name)

Description

87

Code

Category

Category

Expenditure request category

88

Integer

Tax depreciation

Tax depreciation

The useful life of an asset

89

Money

Commitments

Commitments

Sum of commitment documents

90

Code

Expense type

Expense type

Expense type capex/opex

91

Integer

Payment term

Payment term

Payment term. Only used if the Spend to Cash feature is enables


Properties Applicable to Request Type BUDGET

BUDGET properties store information about budget requests created within Capital Budgets in the Weissr Capital Budgeting module. These properties come with built-in logic for specific functions, such as automatically calculating or retrieving data based on system rules. The behavior of static BUDGET properties is fixed and cannot be modified through configuration.

Learn more about static properties for budget requests here.