Manufacturing processes

Support

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

Manufacturing processes

WRProcess

Relations

Field (WRProcess)	Field	Table / View
PartID	PartID	WRPart
ProjectID	ProjectID	WRProject
CurrencyID	CurrencyID	WRUnits
DA_ID	DAProcessID	WRDA_Processes

Field description

Field	Description
ProcessID	primary key, int not null Internal ID of the manufacturing process.
ProcessID _FACTON	int, not null ID of the manufacturing process in the FACTON-internal table The field is mainly used for error analysis.
CaptionDefault	nvarchar(255), null Label of the part in the Company language.
CaptionDE	nvarchar(255), null German label of the manufacturing process.
CaptionEN	nvarchar(255), null English label of the manufacturing process.
PartID	int, not null Internal ID of the parent part the manufacturing process is defined at. Information on the part can be determined via the foreign key (PartID) in the WRPart table.
ProjectID	int, not null Internal ID of the project the manufacturing process is defined at. Information on the project can be determined via the foreign key (ProjectID) in the WRProject table.
CC_ID	int, null Internal ID of the cost center used at the manufacturing process.
CC_Number	nvarchar(255), null Semantic key of the cost center used at the manufacturing process.
CC_CaptionDefault	nvarchar(255), null Label of the part in the Company language.
CC_CaptionEN	nvarchar(255), null German label of the cost center.
CC_CaptionDE	nvarchar(255), null English label of the cost center.
CurrencyID	int, null ID of the cost currency in Offer or Estimation mode. Note: Applies only if the currency remains the same over the project lifetime! The currency can be determined via the foreign key (CurrencyID) in the WRUnits table.
LotSize	float, null Batch Size
ProcessNumber	nvarchar(255), null Semantic key of the manufacturing process.
Path	nvarchar(255), null Path of the manufacturing processes 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
Level	int, null BOM level BOM level 1 equals the top-level assembly.
LiningLevel	nvarchar(255), null The structural level of the manufacturing process. Example: The level 1.1_RT20 indicates that the manufacturing process is located at the second position of the second level.
Sort	int, null Position of the manufacturing process within the routing. The first position has the value 1.
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 manufacturing process in the Data Administration. The manufacturing process in the Data Administration can be determined via the foreign key (DAProcessID) in the WRDA_Processes view.
Configured Attributes

WRProcessCost

Relations

Field (WRProcessCost)	Field	Table / View
ProcessID	ProcessID	WRProcess
SurchargeID	SurchargeID	WRSurcharge

Field description

Field	Description
ProcessID	primary key, int, not null Internal ID of the manufacturing process. Information on the manufacturing process can be determined via the foreign key in the WRProcess 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 unit 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 share of total value.
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.

Field

Description

ProcessID

primary key, int, not null

Internal ID of the manufacturing process.

Information on the manufacturing process can be determined via the foreign key in the WRProcess 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 unit 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 share of total value.

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.

WRProcessValidities

The table provides the attribute values with validities configured at the manufacturing process. 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
ProcessID	ProcessID	WRProcess
UnitID	UnitID	WRUnits
RefUnitID	UnitID	WRUnits

Field description

Field	Description
ProcessID	primary key, int not null Internal ID of the manufacturing process. Information on the manufacturing process can be determined via the foreign key in the WRProcess 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.

WRTariff

The WRTariff table returns the cost rates and times of manufacturing processes.

Relations

Field (WRProcessValidities)	Field	Table / View
ProcessID	ProcessID	WRProcess
CurrencyID	UnitID	WRUnits
QuantityUnitId	UnitID	WRUnits
ActivityType	EnumID	Constants

Field description

Field	Description
TariffID	primary key, int, not null Internal ID of the cost rate
ProcessID	int, not null Internal ID of the manufacturing process. Information on the manufacturing process can be determined via the foreign key in the WRProcess table.
Year	int, not null The calculation year
CurrencyID	int, not Original currency of the cost rate at the manufacturing process The label of the currency can be determined via the foreign key in the WRUnits table. Note: Applies only to cost centers.
TariffVarInProjectCurr	decimal(28,9), null Absolute variable cost rate share in the project currency.
TariffInProjectCurr	decimal(28,9), null Cost rate in the project currency.
TariffVarInDerivationCurr	decimal(28,9), null Absolute variable cost rate share in the original currency. Note: For manufacturing processes with assigned machines, the value null is currently returned, since it is not checked whether multiple machines are assigned.
TariffInDerivationCurr	decimal(28,9), null Cost rate in the original currency. Note: For manufacturing processes with assigned machines, the value null is currently returned, since it is not checked whether multiple machines are assigned.
Valid_From	datetime, null When using cost rates, the date as of which the cost rate is valid is returned, otherwise the value null is returned.
Valid_Until	datetime, null When using cost rates, the date until which the cost rate is valid is returned, otherwise the value null is returned.
ActivityID_FACTON	int, not null Reference to the FACTON-internal ID of the activity type.
ActivityType	int, not null ID of the activity type. The label of the type can be determined via the foreign key (EnumID) in the Constants table.
ActivityName	nvarchar(255), not null Name of the activity type in the database language.
Time	decimal(28,9), null Manufacturing times for the ActivityName activity type in seconds. Note: For the Setup activity type, the unit time is determined (i.e. the setup time is divided by the lot size).
CycleTime	decimal(28,9), null Cycle time for the Machine activity type in seconds. For all other activity types the value null is returned.
Cavities	float, null Number of cavities for the Machine activity type. For all other activity types the value null is returned.
Operators	float, null Number of operators for the Worker or Setup activity type (if configured). For all other activity types the value null is returned.
QuantityUnitId	int, null Internal ID of the activity type. The label of the unit can be determined via the foreign key in the WRUnits table.
LotSizeEffective	(float, null) Effective lot size for the Setup activity type. For all other activity types the value null is returned.