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.