Additional costs

Support

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

Additional costs

WRDA_AdditionalCosts

The WRDA_AdditionalCosts view provides the additional cost administered in the Data Administration.

Relations

Field (WRDA_AdditionalCosts)	Field	Table / View
CurrencyID	UnitID	WRDA_Units
QuantityUnitID	UnitID	WRDA_Units
AllocationTimeUnitID	UnitID	WRDA_Units
CreatorID	DAUserID	WRDA_Users
ModifierID	DAUserID	WRDA_Users

Field description

Field	Description
DAAdditionalCostID	int, not null FACTON internal ID of the additional cost.
DAAdditionalCostParentID	int, null Internal ID of the parent folder
IsGroup	bit, null Returns the value 0 if the current data row is a machine, otherwise the value 1 is returned for a folder.
AdditionalCostName	nvarchar(max), null Name of the additional cost in the Company language.
AdditionalCostName _[Country identifier]	nvarchar(max), null Name of the additional cost in the language according to the country code. Example: AdditionalCostName_EN for the English name.
AdditionalCostIdentifier	nvarchar(50), null Semantic key of the additional cost
AdditionalCostDescription	nvarchar(max), null Description of the additional cost in the Company language.
AdditionalCostDescription _[Country identifier]	nvarchar(max), null Description of the additional cost in the language according to the country code. Example: AdditionalCostDescription_EN for the English description.
CurrencyID	int, null ID for the currency of the additional cost rate. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
AdditionalCostRate	float, null Value of the additional cost rate in unit CurrencyID.
CostType	int, null Returns the additional cost type: 0: One-time costs 1: Annual costs 2: Unit costs
AllocationType	int, null Value of the cost allocation type. The value is of type: integer. The values correspond to the following allocation types: 0 = Total quantity 1 = Annual quantity 2 = To the first x pieces 3 = To the first x years 4 = After x pieces 5 = After x years 10 = No allocation
ReferenceQuantity	float, null Reference quantity for cost type: unit costs.
Quantity	float, null Quantity of additional costs. For additional costs always 1 in the Data Administration.
QuantityUnitID	int, null Internal unit ID of the additional cost quantity. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
AllocationTime	float, null The allocation period for cost allocation type: to the first x years or after x years.
AllocationTimeUnitID	int, null Internal unit ID for the allocation period. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
AllocationQuantity	float, null The allocation quantity for cost allocation type: to the first x pieces or after x pieces.
InternRate	float, null Value of the internal rate (own share). A value of 1 equals 100%.
InternRateUnitID	int, null Internal unit ID of the internal rate. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
UseInterest	bit, null Returns the value 1 if additional costs are calculated with imputed interest, otherwise the value 0 is returned.
InterestRate	float, null Value of the interest rate. Returns the value null if the interest rate is to be determined via the project location.
InterestRateUnitID	int, null Internal unit ID of the imputed interest rate. Returns the value null if the interest rate is to be determined via the project location.
InterestTime	float, null Value of the interest period in unit: Years Returns the value null if the interest rate is to be determined via the project location, since the period can only be identified in the project context.
UseProjectInterest	bit, null Returns the value 1 if the interest rate is to be determined via the project location, otherwise the value 0 is returned.
UseProjectLifetime	bit, null Returns the value 1 if the project period is to be used for the interest period, otherwise the value 0 is returned.
CanAllocateToInvestTime	float, null Returns the value 1 if a deviating pay out history can be defined for the additional costs, otherwise the value 0 is returned.
CreatorID	int, null Internal ID of the user who created the data record. The name of the user can be determined via the foreign key (DAUserID) in the WRDA_Users view.
CreationDateTime	datetime, null Creation date of the data record.
ModifierID	int, null Internal ID of the user who last updated the data record. The name of the user can be determined via the foreign key (DAUserID) in the WRDA_Users view.
LastUpdateDateTime	datetime, null Modification date
Configured Attributes