Units

WRDA_Units

The WRDA_Units table provides the units that are currently defined in the system settings. In comparison, the WRUnits table provides the units used in the project.

Field description

Field Description
DAUnitID
int, not null

FACTON internal ID of the unit.

DAUnitBaseID
int, null

FACTON internal ID for the basic unit of the corresponding unit class (e.g. h to s, min to s, kg to g)

Factor
float, null

Unit to base unit factor

UnitName
nvarchar(max), null

Company language

UnitName
_[Country identifier]
nvarchar(max), null

Label of the unit in the language according to the country code.

Example: UnitName_EN for the English label.

UnitDescription
nvarchar(max), null

Company language

UnitDescription
_[Country identifier]
nvarchar(max), null

Description of the unit in the language according to the country code.

Example: UnitDescription_EN for the English label.

Short
nvarchar(50), null

Identifier of the unit.

Multiple identifiers are separated by a semicolon (e.g. PER; %).

IsCurrency
int, not null

Returns the value 1, if it is the currency unit, otherwise the value 0 is returned.