Difference between revisions of "Production.UnitMeasure (table)"

From dbscript Online Help
Jump to: navigation, search
Line 81: Line 81:
 
| '''Name
 
| '''Name
 
|-  
 
|-  
| B
+
| BTL
 
| Bottle
 
| Bottle
 
|-  
 
|-  
| B
+
| BOX
 
| Boxes
 
| Boxes
 
|-  
 
|-  
| C
+
| CAN
 
| Canister
 
| Canister
 
|-  
 
|-  
| C
+
| CAR
 
| Carton
 
| Carton
 
|-  
 
|-  
| C
+
| CS
 
| Case
 
| Case
 
|-  
 
|-  
| C
+
| C
 
| Celsius
 
| Celsius
 
|-  
 
|-  
| C
+
| CM
 
| Centimeter
 
| Centimeter
 
|-  
 
|-  
| C
+
| CTN
 
| Container
 
| Container
 
|-  
 
|-  
| C
+
| CR
 
| Crate
 
| Crate
 
|-  
 
|-  
| C
+
| CCM
 
| Cubic centimeter
 
| Cubic centimeter
 
|-  
 
|-  
| C
+
| CDM
 
| Cubic decimeter
 
| Cubic decimeter
 
|-  
 
|-  
| F
+
| FT3
 
| Cubic foot
 
| Cubic foot
 
|-  
 
|-  
| M
+
| M3
 
| Cubic meter
 
| Cubic meter
 
|-  
 
|-  
| C
+
| CBM
 
| Cubic meters
 
| Cubic meters
 
|-  
 
|-  
| D
+
| DM
 
| Decimeter
 
| Decimeter
 
|-  
 
|-  
| D
+
| DZ
 
| Dozen
 
| Dozen
 
|-  
 
|-  
| E
+
| EA
 
| Each
 
| Each
 
|-  
 
|-  
| G
+
| GAL
 
| Gallon
 
| Gallon
 
|-  
 
|-  
| G
+
| G
 
| Gram
 
| Gram
 
|-  
 
|-  
| I
+
| IN
 
| Inch
 
| Inch
 
|-  
 
|-  
| K
+
| KG
 
| Kilogram
 
| Kilogram
 
|-  
 
|-  
| K
+
| KGV
 
| Kilogram/cubic meter
 
| Kilogram/cubic meter
 
|-  
 
|-  
| K
+
| KM
 
| Kilometer
 
| Kilometer
 
|-  
 
|-  
| K
+
| KT
 
| Kiloton
 
| Kiloton
 
|-  
 
|-  
| L
+
| L
 
| Liter
 
| Liter
 
|-  
 
|-  
| M
+
| M
 
| Meter
 
| Meter
 
|-  
 
|-  
| M
+
| MG
 
| Milligram
 
| Milligram
 
|-  
 
|-  
| M
+
| ML
 
| Milliliter
 
| Milliliter
 
|-  
 
|-  
| M
+
| MM
 
| Millimeter
 
| Millimeter
 
|-  
 
|-  
| O
+
| OZ
 
| Ounces
 
| Ounces
 
|-  
 
|-  
| P
+
| PAK
 
| Pack
 
| Pack
 
|-  
 
|-  
| P
+
| PAL
 
| Pallet
 
| Pallet
 
|-  
 
|-  
| P
+
| PCT
 
| Percentage
 
| Percentage
 
|-  
 
|-  
| P
+
| PC
 
| Piece
 
| Piece
 
|-  
 
|-  
| P
+
| PT
 
| Pint, US liquid
 
| Pint, US liquid
 
|-  
 
|-  
| C
+
| CM2
 
| Square centimeter
 
| Square centimeter
 
|-  
 
|-  
| M
+
| M2
 
| Square meter
 
| Square meter
 
|-  
 
|-  
| L
+
| LB
 
| US pound
 
| US pound
 
|}
 
|}

Revision as of 15:29, 3 January 2009

wikibot

Table Production.UnitMeasure


Column Data Type Nullable Default PK Index
UnitMeasureCode nchar(0) 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