The MeasurementUnit table allows you to retrieve information about the units that can be used to measure Data types.
This topic contains the following sections:
When you write templates that access this table, follow these requirements:
Specify the Symbolic Name for the table version to use:
TableID = MeasurementUnit-1.0
Specify an Intent that this table supports:
[Filter] Id(ExtId) = Equals(Id1) # You can filter on literals or on variables from the [User] or [Calculated] sections.
[Filter] Id(ExtId) = In(["Id1","Id2","Id3"])
This list includes each column's name, which you use in expressions to retrieve data, and data type, which defines how the data is retrieved.
|Id||Id||(primary key) The ID of this measurement unit.|
|DataTypeId||Id<DataType>||The ID of the DataType that this unit is measuring.|
|Name||Text||The name of this unit of measurement, e.g. Miles.|
|Abbreviation||Text||The abbreviated name of this unit of measurement, e.g. mi.|
|Scale||Number||The scale of this unit of measurement. This defines how the magnitude of the unit compares to other units.|
|Offset||Number||The offset of this unit of measurement. defines how the scale of the unit is offset from other units.|