Production.UnitMeasure (table)

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

Detail Table	Column	Referencing Column
Production.BillOfMaterials	UnitMeasureCode	UnitMeasureCode
Production.Product	UnitMeasureCode	SizeUnitMeasureCode
Production.Product	UnitMeasureCode	WeightUnitMeasureCode
Purchasing.ProductVendor	UnitMeasureCode	UnitMeasureCode

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.

Detail Table	Column	Referencing Column
Production.BillOfMaterials	UnitMeasureCode	UnitMeasureCode
Production.Product	UnitMeasureCode	SizeUnitMeasureCode
Production.Product	UnitMeasureCode	WeightUnitMeasureCode
Purchasing.ProductVendor	UnitMeasureCode	UnitMeasureCode

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name
Schema	Schema	Production