Manufacturing processes
WRDA_Processes
The WRDA_Processes view provides the manufacturing processes administered in the Data Administration.
Relations
| Field (WRDA_Processes) | Field | Table / View |
|---|---|---|
CurrencyID |
UnitID |
|
CreatorID |
DAUserID |
|
ModifierID |
DAUserID |
Field description
| Field | Description |
|---|---|
DAProcessID |
int, not null FACTON internal ID of the manufacturing process. |
DAProcessParentID |
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. |
ProcessName |
nvarchar(max), null Name of the manufacturing process in the Company language |
ProcessName |
nvarchar(max), null Name of the manufacturing process in the language according to the country code. Example: ProcessName_EN for the English name. |
ProcessIdentifier |
nvarchar(50), null Semantic key of the manufacturing process |
ProcessDescription |
nvarchar(max), null Description of the manufacturing process in the Company language |
ProcessDescription |
nvarchar(max), null Description of the manufacturing process in the language according to the country code. Example: ProcessDescription_EN for the English description. |
CurrencyID |
int, null ID for the currency of the production cost rate. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table. |
ProductionCostRate |
float, null Value of the production cost rate in unit [CurrencyID / hour]. |
ProductionCostRateVar |
float, null Value of the variable production cost rate in unit [CurrencyID / hour]. |
SetupCostRate |
float, null Value of the setup cost rate in unit [CurrencyID / hour]. |
SetupCostRateVar |
float, null Value of the variable setup cost rate in unit [CurrencyID / hour]. |
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 |