Production UnitMeasure (table)

wikibot

TableProduction.UnitMeasure
DescriptionUnit of measure lookup table.

Columns

ColumnData TypeNullableDefaultDescription
UnitMeasureCodenchar(3)not null Primary key.
Namedbo.Namenot null Unit of measure description.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_UnitMeasure_UnitMeasureCodeUnitMeasureCode

Indexes

IndexTypeColumns
AK_UnitMeasure_NameUniqueName

Detail Tables

Detail TableColumnReferencing Column
Production.BillOfMaterialsUnitMeasureCodeUnitMeasureCode
Production.ProductUnitMeasureCodeSizeUnitMeasureCode
Production.ProductUnitMeasureCodeWeightUnitMeasureCode
Purchasing.ProductVendorUnitMeasureCodeUnitMeasureCode

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaProduction

wikivalues

Table ValuesProduction.UnitMeasure

UnitMeasureCodeName
BTLBottle
BOXBoxes
CANCanister
CARCarton
CS Case
C Celsius
CM Centimeter
CTNContainer
CR Crate
CCMCubic centimeter
CDMCubic decimeter
FT3Cubic foot
M3 Cubic meter
CBMCubic meters
DM Decimeter
DZ Dozen
EA Each
GALGallon
G Gram
IN Inch
KG Kilogram
KGVKilogram/cubic meter
KM Kilometer
KT Kiloton
L Liter
M Meter
MG Milligram
ML Milliliter
MM Millimeter
OZ Ounces
PAKPack
PALPallet
PCTPercentage
PC Piece
PT Pint, US liquid
CM2Square centimeter
M2 Square meter
LB US pound