Production.UnitMeasure (table)

wikibot

Table

Production.UnitMeasure

Column	Data Type	Nullable	Default	PK	Index
UnitMeasureCode	nchar(3)	not null		PK_UnitMeasure_UnitMeasureCode
Name	dbo.Name	not null			AK_UnitMeasure_Name
ModifiedDate	datetime	not null	(getdate())

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

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

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