Investments

WRInvestments

Relations

Field (WRInvestments)	Field	Table / View
InvestmentType	EnumID	Constants
InvestID	InvestID	WRInvestmentDistribution

Field description

Field	Description
InvestID	primary key, int not null Internal ID of the investment
ProjectID	int, not null Internal ID of the project
ObjectID_FACTON	int, not null
InvestmentType	int, null Type of investment (additional costs or machine investment) The label of the investment type can be determined via the foreign key (EnumID) in the Constants table.
Path	nvarchar(255), null Path in the calculation structure the investment was defined at. Example: 1.2_AC0 The investment was defined via additional costs (AC). The additional costs are located at the first position (0) of the second part (2) on the second BOM level (1.2). Example: 1.2_RT10_AC0 The investment is calculated as additional costs. The additional costs are located at the first position (0) of the second routing (RT10) of the second part (2) on the second BOM level (1.2).
CaptionDefault	nvarchar(255), null Label of the investment in the Company language. The label of the additional costs or the machine is assumed as investment label.
CaptionDE	nvarchar(255), null German label of the investment
CaptionEN	nvarchar(255), null English label of the investment
Number	nvarchar(255), null Semantic key of additional costs or machine
TotalInvestment	decimal(28,9), null Investment amount (Cash out)
TotalReimbursment	decimal(28,9), null Reimbursement amount (Cash in)

 

WRInvestmentDistribution

Available as of version 9.1

The table provides the percentage distribution of pay in and pay out of investments over the investment period.

The InvestmentDistributionExporter exporter must be active in the Settings.

The Setting ExportMonthlyInvestDistribution must be activated, in order to export the monthly distribution of investments.

Relations

Field (WRInvestmentDistribution)	Field	Table / View
InvestID	InvestID	WRInvestments

Field description

Field	Description
InvestID	primary key, int, not null Internal ID of the investment The investment can be determined as semantic key in the WRInvestments table.
Year	primary key, int, not null Calendar year Investments are distributed over calendar years.
Month	primary key, int, not null Month as integer. For the annual investment distribution, the value 2147483647 is returned for Month.
Investment	decimal(28,9), null Proportional pay out in percent. A value of 0.2 equals 20%. The absolute investment amount can be determined via the WRInvestments table.
Reimbursement	decimal(28,9), null Proportional pay in in percent. A value of 0.2 equals 20%. The absolute pay in amount can be determined via the WRInvestments table.

 

Field description

Field	Description
ProjectID	primary key, int not null Internal ID of the project
KeyFigure	primary key, nvarchar(255), not null Key Figure
Value	decimal, (28,9), null Value

Definition of the key figures

Key Figure	Description
AmoDd	Dynamic Amortization period in years If the dynamic amortization period could not be calculated, the value null is returned.
AmoDs	Static amortization period in years
BEQ	Break even quantity
BER	Break even revenue in project currency
IRR	Internal rate of return If the dynamic amortization period could not be calculated, the value null is returned. A value of 0.06 equals 6%.
NPV	Net present value in project currency.
ROId	Return on investment dynamic A value of 0.4 equals 40%.
ROIs	Return on investment static A value of 0.4 equals 40%.