ScrewTurn Wiki

Edit

wikibot

TableProduction.UnitMeasure
DescriptionUnit of measure lookup table.

Edit

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.

Edit

Primary Key

Primary KeyColumns
PK_UnitMeasure_UnitMeasureCodeUnitMeasureCode

Edit

Indexes

IndexTypeColumns
AK_UnitMeasure_NameUniqueName

Edit

Detail Tables

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

Edit

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaProduction

Edit

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

Edit

automatically generated

TableProduction.UnitMeasure
DescriptionUnit of measure lookup table.

ColumnData TypeNullableDefaultDescription / PK / Index
UnitMeasureCodenchar(3)not null Primary key.
PK_UnitMeasure_UnitMeasureCode
NameNamenot null Unit of measure description.
AK_UnitMeasure_Name
ModifiedDatedatetimenot null(GETDATE())Date and time the record was last updated.



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

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaProduction

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.