From dbscript Online Help
wikibot
Table
|
Production.UnitMeasure
|
Description
|
Unit of measure lookup table.
|
Columns
Column
|
Data Type
|
Nullable
|
Default
|
Description
|
UnitMeasureCode
|
nchar(3)
|
not null
|
|
Primary key.
|
Name
|
dbo.Name
|
not null
|
|
Unit of measure description.
|
ModifiedDate
|
datetime
|
not null
|
(getdate())
|
Date and time the record was last updated.
|
Primary Key
Primary Key
|
Columns
|
PK_UnitMeasure_UnitMeasureCode
|
UnitMeasureCode
|
Indexes
Index
|
Type
|
Columns
|
AK_UnitMeasure_Name
|
Unique
|
Name
|
Detail Tables
References
Dependency Type
|
Object Type
|
Referenced Object
|
Data Type
|
Type
|
dbo.Name
|
Schema
|
Schema
|
Production
|
wikivalues
Table Values
|
Production.UnitMeasure
|
UnitMeasureCode
|
Name
|
BTL
|
Bottle
|
BOX
|
Boxes
|
CAN
|
Canister
|
CAR
|
Carton
|
CS
|
Case
|
C
|
Celsius
|
CM
|
Centimeter
|
CTN
|
Container
|
CR
|
Crate
|
CCM
|
Cubic centimeter
|
CDM
|
Cubic decimeter
|
FT3
|
Cubic foot
|
M3
|
Cubic meter
|
CBM
|
Cubic meters
|
DM
|
Decimeter
|
DZ
|
Dozen
|
EA
|
Each
|
GAL
|
Gallon
|
G
|
Gram
|
IN
|
Inch
|
KG
|
Kilogram
|
KGV
|
Kilogram/cubic meter
|
KM
|
Kilometer
|
KT
|
Kiloton
|
L
|
Liter
|
M
|
Meter
|
MG
|
Milligram
|
ML
|
Milliliter
|
MM
|
Millimeter
|
OZ
|
Ounces
|
PAK
|
Pack
|
PAL
|
Pallet
|
PCT
|
Percentage
|
PC
|
Piece
|
PT
|
Pint, US liquid
|
CM2
|
Square centimeter
|
M2
|
Square meter
|
LB
|
US pound
|
automatically generated
Table
|
Production.UnitMeasure
|
Description
|
Unit of measure lookup table.
|
Column
|
Data Type
|
Nullable
|
Default
|
Description / PK / Index
|
UnitMeasureCode
|
nchar(3)
|
not null
|
|
Primary key. PK_UnitMeasure_UnitMeasureCode
|
Name
|
Name
|
not null
|
|
Unit of measure description. AK_UnitMeasure_Name
|
ModifiedDate
|
datetime
|
not null
|
(GETDATE())
|
Date and time the record was last updated.
|
Dependency Type
|
Object Type
|
Referenced Object
|
Data Type
|
Type
|
dbo.Name
|
Schema
|
Schema
|
Production
|