tUnit Table

CEDE 9.0 Database Reference

tUnit Table

Collapse All

AIRReference Database : tUnit Table

Description

Stores the supported units of measure.

Properties

Creation Date	4/11/2017 1:36 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	20
Data Space Used	8.00 KB
Index Space Used	8.00 KB

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	UnitCode	Code that represents the unit of measure. AC = Acre (Area) BBL = Barrels (Liquid) BIL = Billions (Currency) EPY = Events per year (Count) FT = Feet (Distance) G = G Force (Gravity) HA = Hectare (Area) KM = Kilometers (Distance KPH = Kilometers per hour (Speed) M = Meters (Distance) MCF = Thousands of cubic feet (Volume) MI = Miles (Distance) MIL = Millions (Currency) MPH = Miles per hour (Speed) ONE = Ones (Currency) SQFT = Square feet (Area) SQM = Square meters (Area) THO = Thousands (Currency) USDBBL U= SD per barrel (Liquid) USDMCF = USD per thousand cubic feet (Gas)	varchar	10
	Unit	Name of the measurement unit.	varchar	40
	UnitCategory	Categorization of the measurement unit.	varchar	40
	Description	Description of the measurement unit.	varchar	1024
	SortOrder	Order of appearance of the unit in any drop-down lists in the application.	smallint	2		((0))

See Also

Related Objects

AIRReference Database

© 2021. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.