Units
WRUnits
The WRUnits provides the units for all unit properties in the project.
Field | Description |
---|---|
UnitID |
primary key, int, not null Internal ID of the unit |
UnitID_FACTON |
int, not null Reference to the FACTON-internal ID of the unit. |
BaseUnitID |
int, null ID of the base unit (UnitID). If no base unit is defined, the value null is returned. |
Factor |
float null Unit to base unit factor. If no base unit is defined, the value 0 is returned as factor. |
Name |
nvarchar(255), not null Short label of the unit in the Company language. |
CaptionDE |
nvarchar(255), null German short label of the unit. |
CaptionEN |
nvarchar(255), null English short label of the unit. |
Accuracy |
int, not null Number of decimal places according to the unit configuration. |
Description |
nvarchar(50), null Equals the unit label according to the unit configuration in the Company language. |
Short |
nvarchar(80), null Identifier of the unit. |
UnitOfMeasureSystem |
nvarchar(255), null Returns the assigned unit system. Possible values: unspecific, metric, imperial or null The value null is returned if the use of different unit systems is deactivated. |
UnitIDMetric |
int, null Returns the ID of the metric unit corresponding to the imperial unit. Otherwise, the value null is returned. |
UnitIDImperial |
int, null Returns the ID of the imperial unit corresponding to the metric unit. Otherwise, the value null is returned. |
As of version 11.2 IsFactorReciprocal |
bit, null Returns the value 1 if the reciprocal factor of the base unit must be used, otherwise the value 0 is returned. |