Touchstone 4.0 Database Documentation
tUnit Table
Description
Stores the possible units of measure.
Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows20
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 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)
VarChar10   
 Unit

Name of the measurement unit.

Corresponds to the code in UnitCode.

VarChar40   
 UnitCategory

Categorization of the measurement unit.

Corresponds to the code in UnitCode.

VarChar40   
 Description

Description of the measurement unit.

VarChar1024  
Objects that depend on tUnit
 Database ObjectObject TypeDescriptionDep Level
tUnitConversion tabletUnitConversionTable

Stores the ratio needed to convert from one distance measurement unit type to another, such as feet to meters.

1
See Also

Related Objects

AIRReference Database

 

 


AIR Client Confidential

© 2016. 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.