Additional cost

Support

support@facton.com
+49 1805-FACTON
Customer Portal

Additional cost

WRAdditionalCost

The WRAdditionalCost table provides information on the additional cost used in the project.

Relations

Field (WRAdditionalCost)	Field	Table / View
ProjectID	ProjectID	WRProject
PartID	PartID	WRPart
ProcessID	ProcessID	WRProcess
CurrencyID	UnitID	WRUnits
CostType	EnumID	Constants
AllocationType	EnumID	Constants
DA_ID	DAAdditionalCostID	WRDA_AdditionalCosts
As of version 11.3 InvestID	InvestID	WRInvestments

Field description

Field	Description
ADC_ID	primary key, int, not null Internal ID of the additional cost
ADC_ID_FACTON	int, not null Reference to the FACTON-internal ID of the additional cost
ADC_CaptionDefault	nvarchar(255), null Label of the additional cost in the Company language.
ADC_CaptionDE	nvarchar(255), null German label of the additional cost.
ADC_CaptionEN	nvarchar(255), null English label of the additional cost.
ADC_Number	nvarchar(255), null Semantic key of the additional cost.
ProjectID	int, not null Internal ID of the project the additional cost are defined at Information on the project can be determined via the foreign key in the WRProject table.
PartID	int, null Internal ID of the part the additional cost are defined at Information on the part can be determined via the foreign key in the WRPart table.
ProcessID	int, null Internal ID of the manufacturing process the additional cost are defined at Information on the manufacturing process can be determined via the foreign key in the WRProcess table.
As of version 11.3 InvestID	int, null Internal ID of the corresponding investment (see WRInvestments)
CostRate	The cost rate of the additional cost element
CurrencyID	int, null ID for the currency of the cost rate. Information on the currency can be determined via the foreign key (UnitID) in the WRUnits table.
CostType	int, null ID of the cost type (e.g. one-time cost) Information on the cost type can be determined via the foreign key (EnumID) in the Constants table.
PP_Quantity	float, null Number of additional cost elements
PP_PieceCost	float, null Returns the quantity for the cost type "Unit costs", otherwise the value null is returned.
AllocationType	int, null ID of the cost allocation type (e.g. total quantity) The label of the type can be determined via the foreign key (EnumID) in the Constants table.
FreeAllocationInUnits	float, null Returns the allocation quantity: "after x piece" or "to the first x piece", otherwise the value null is returned.
FreeAllocationInYears	float, null Returns the number of years when allocating "after x a" or "to the first x a" (a = years), otherwise, the value null is returned.
Interest_Calculation	bit, null Returns the value 1 when calculating with active interest on capital, otherwise the value 0 is returned.
InterestPeriodInYears	float, null Returns the interest period in years when calculating with active interest on capital, otherwise the value null is returned.
InterestRateInPercent	float, null Returns the interest rate when calculating with active interest on capital, otherwise the value null is returned. The value 0.06 equals the interest rate 6%.
Path	nvarchar(255), null Path of the additional cost in the calculation structure. The path name is a compound of the parent parts labels and the project label in the Company language. Example: \Project A\Assembly Servomotor\Installation
Level	int, null BOM level. BOM level 1 equals the top-level assembly. Manufacturing processes are not considered as separate BOM levels.
LiningLevel	nvarchar(255), null Structural level of the additional cost Example: The level 1.1_RT20_AC0 indicates that the additional cost are located at the second position of the second manufacturing process. the manufacturing process is located on the second level.
Sort	int, null Position of the additional cost element within the additional cost node The first position has the value 0.
CalcMode	int, null Calculation Mode.
IsParentPathModusBase	bit, null Returns the value 1 if the parent part is calculated in Standard mode, otherwise the value 0 is returned.
DA_ID	int, null The internal ID of the additional cost in the Data Administration. The corresponding additional cost in the Data Administration can be determined via the foreign key (DAAdditionalCostID) in the WRDA_AdditionalCosts view.
Configured Attributes

WRCostofAdditionalCost

The WRCostofAdditionalCost table provides the costs defined in the costing schema at the additional cost elements.

Relations

Field (WRAdditionalCost)	Field	Table / View
ADC_ID	ADC_ID	WRAdditionalCost
SurchargeID	SurchargeID	WRSurcharge

Field description

Field	Description
ADC_ID	primary key, int, not null Internal ID of the additional cost Information on the additional cost can be determined via the foreign key in the WRAdditionalCost table.
Year	primary key, int, not null The calculation year If the fiscal year does not start in January, the calendar year of the fiscal year start is returned. Example: For the fiscal year from June 2020 until May 2021, the value 2020 is returned.
SurchargeID	primary key, int, not null Internal ID of the cost element. The label of the cost element can be determined via the foreign key (SurchargeID) in the WRSurcharge table.
Value	decimal(28,9), null Fix material cost in project currency.
ValueVar	decimal(28,9), null Variable unit cost in project currency.
ValueTotal	decimal(28,9), null Total unit cost (fix and variable) in project currency.
ValueTotalVar	decimal(28,9), null Variable unit cost in project currency.
As of version 6.4.6 Rate	decimal(28,9), null Value of the surcharge rate at cost elements defined as percentage surcharge. Example: Overhead cost of 4% are returned as 4.

WRAdditionalCostValidities

The table provides the attribute values with validities configured at the additional cost. Attribute values with validities are currently only used in customer-specific extensions (plugins); they are currently only defined for the Floating-point number data type.

Relations

Field (WRProcessValidities)	Field	Table / View
ADC_ID	ADC_ID	WRAdditionalCost
UnitID	UnitID	WRUnits
RefUnitID	UnitID	WRUnits

Field description

Field	Description
ADC_ID	primary key, int, not null Internal ID of the additional costs Information on the additional cost can be determined via the foreign key in the WRAdditionalCost table.
ColumnName	primary key, nvarchar(255) not null Internal label of the attribute with validities at the manufacturing process
Year	primary key, int not null The year for which the value is valid
Value	float, null The value of the attribute Currently, only numeric values are provided by the export.
UnitID	int, null Internal ID of the numerator unit The label of the unit can be determined via the foreign key (UnitID) in the WRUnits table.
RefUnitID	int, null Internal ID of the denominator unit The label of the unit can be determined via the foreign key (UnitID) in the WRUnits table.