Machines

Support

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

Machines

WRDA_Machines

The WRDA_Machines view provides information on the machines defined in the Data Administration.

Relations

Field (WRDA_Origins)	Field	Table / View
CurrencyID	UnitID	WRDA_Units
AmortiziationTimeUnitID	UnitID	WRDA_Units
PerformanceRateUnitID	UnitID	WRDA_Units
CycleTimeUnitID	UnitID	WRDA_Units
CreatorID	DAUserID	WRDA_Users
ModifierID	DAUserID	WRDA_Users

Field description

Field	Description
DAMachineID	int, not null Internal ID of the machine or machine folder
DAMachineParentID	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 for a folder.
MachineName	nvarchar(max), null Name of the machine in the Company language
MachineName _[Country identifier]	nvarchar(max), null Name of the machine in the language according to the country code. Example: MachineName_EN for the English machine name
MachineIdentifier	nvarchar(50), null Semantic key of the machine.
MachineDescription	nvarchar(max), null Description of the machine in the Company language
MachineDescription _[Country identifier]	nvarchar(max), null Description of the machine in the language according to the country code. Example: MachineDescription_EN for the English description of the machine.
CostRateType	varchar(10), null Returns the value Manual if the machine cost rate was entered manually, otherwise the value Calculated.
CurrencyID	int, null ID for the currency of the machine cost rate The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
CostRateManual	float, null Value of the manually entered manufacturing rate. Note: The manually entered value is also returned if the machine cost rate was subsequently set to calculated.
CostRateManualVar	float, null Value of the variable portion for the manual cost rate.
SetupCostRate	float, null Value of the setup rate in [CurrencyID] per hour.
SetupCostRateVar	float, null Value of the variable share of the setup rate [CurrencyID] per hour
InvestYear	int, null Machine Acquisition Year
ReacquisitionCost	float, null Value of the reacquisition (replacement) cost per unit [CurrencyID]
NotAbsorbed	float, null Value of the not set off share in unit [CurrencyID]
AmortiziationTime	float, null Value of the depreciation period.
AmortiziationTimeUnitID	int, null ID for the unit of the depreciation period. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
PerformanceRate	float, null Value of the performance index Note: The value 1 equals 100%.
PerformanceRateUnitID	int, null ID for the unit of the performance rate. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
Utilization	float, null Machine utilization Note: The value 1 equals 100%.
UtilizationUnitID	int, null ID for the unit of the capacity utilization. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
UtilizationTime	float, null Value of the maximum utilization of the machine in unit [hours / year]
UseCavities	bit, null Returns the value 1 if cavities are used at the machine, otherwise the value 0 is returned.
Cavities	float, null Number of cavities
WorkersPerMachine	float, null Number of workers per machine
CycleTime	float, null Cycle Time
CycleTimeUnitID	int, null ID for the unit of the cycle time. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
WorkersPerSetup	float, null Number of workers per setup
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
Machine consumptions
Configured Attributes

Machine consumptions

Consumptions by a machine are freely configurable in FACTON. The database fields are derived from the internal property labels.

Consumption values are converted into base units.

Example: A machine's gas consumption value of 200 m³ / a is exported as 6.342 cm³ / s if cm³ and seconds are defined as base units of the respective unit class.

Field	Description
[internal name]	float, null Value of consumption Example: The GasNeed field returns the gas consumption value. Note: The value is converted into the base unit.
[internal name]UnitID	int, null Numerator unit of the consumption Example: The GasNeedUnitID field contains the unit ID of the consumption. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
[internal name]RefUnitID	int, null Denominator unit of the consumption Example: The GasNeedRefUnitID field contains the unit ID of the denominator. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.

Field

Description

[internal name]

float, null

Value of consumption

Example: The GasNeed field returns the gas consumption value.

Note: The value is converted into the base unit.

[internal name]UnitID

int, null

Numerator unit of the consumption

Example: The GasNeedUnitID field contains the unit ID of the consumption.

The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.

[internal name]RefUnitID

int, null

Denominator unit of the consumption

Example: The GasNeedRefUnitID field contains the unit ID of the denominator.

The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.