Cost elements

WRSurcharge

The table provides all cost elements that are referenced in the exported projects. New cost elements are only available in the WRSurcharge table if they are defined at least at one exported project.

Cost elements are either configured via the costing schema or predefined (see Configuration-independent Cost Elements)

Relations

Field (WRSurcharge)	Field	Table / View
ContactType	EnumID	Constants
Type	EnumID	Constants

Field description

Field	Description
SurchargeID	primary key, int not null Internal ID of the cost element
SurchargeID_FACTON	int, not null Reference to the FACTON-internal ID of the cost element.
Short	nvarchar(80), null Short label of the cost element
SurchargeRateID	nvarchar(50), null Semantic key of the cost element
Name	nvarchar(255), null Label of the cost element in the Company language.
CaptionDE	nvarchar(255), null German label of the cost element.
CaptionEN	nvarchar(255), null English label of the cost element.
Type	int, null Type of the cost element (e.g. unit cost, percentage surcharge) The label of the type can be determined via the foreign key (EnumID) in the Constants table.
Formula	nvarchar(2000), null Formula at the cost element If no formula is defined, the value null is returned.
IsGroup	bit, null Returns the value 0 if the cost element is a surcharge definition. Returns the value 1 if the cost element is defined as surcharge group.
ContactType	int, null Origin type at the cost element For the origin type unspecific the value null is returned. The label of the origin type can be determined via the foreign key (EnumID) in the Constants table.

 

Configuration-independent Cost Elements

The following cost elements are defined by the system and are uniquely identified via the Short field.

Field	Description
As of version 12.3 VD_TargetCost	The cost element provides the target costs entered at the project (WRProjectCost), part (WRPartCost), process (WRProcessCost) or additional cost element (WRCostofAdditionalCost) over project lifetime.
As of version 12.3 VD_TargetCostDeviation	The cost element provides the deviation between costs and target costs at the project (WRProjectCost), part (WRPartCost), process (WRProcessCost) or additional cost element (WRCostofAdditionalCost) over project lifetime. The absolute and relative deviation is returned. The absolute deviation is < 0 if the costs are lower than the target costs.