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

From dbscript Online Help
Jump to: navigation, search
 
(3 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| Production.UnitMeasure
 
| Production.UnitMeasure
Line 8: Line 8:
 
| '''Description
 
| '''Description
 
| Unit of measure lookup table.
 
| Unit of measure lookup table.
−
|-
 
 
|}
 
|}
  
−
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 18: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description / PK / Index
+
| '''Description
−
+
 
 
|- valign="top"
 
|- valign="top"
 
| UnitMeasureCode
 
| UnitMeasureCode
Line 25: Line 24:
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key.<br />PK_UnitMeasure_UnitMeasureCode
+
| Primary key.
 
|- valign="top"
 
|- valign="top"
 
| Name
 
| Name
Line 31: Line 30:
 
| not null
 
| not null
 
|  
 
|  
−
| Unit of measure description.<br />AK_UnitMeasure_Name
+
| Unit of measure description.
 
|- valign="top"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 37: Line 36:
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
| Date and time the record was last updated.<br />
+
| Date and time the record was last updated.
 
|}
 
|}
  
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| PK_UnitMeasure_UnitMeasureCode
 +
| UnitMeasureCode
 +
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
  
 +
|- valign="top"
 +
| AK_UnitMeasure_Name
 +
| Unique
 +
| Name
 +
|}
 +
 +
=== Detail Tables ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 47: Line 68:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[Production.BillOfMaterials_(table)|Production.BillOfMaterials]]
 
| [[Production.BillOfMaterials_(table)|Production.BillOfMaterials]]
 
| UnitMeasureCode
 
| UnitMeasureCode
 
| UnitMeasureCode
 
| UnitMeasureCode
−
|-
+
|- valign="top"
 
| [[Production.Product_(table)|Production.Product]]
 
| [[Production.Product_(table)|Production.Product]]
 
| UnitMeasureCode
 
| UnitMeasureCode
 
| SizeUnitMeasureCode
 
| SizeUnitMeasureCode
−
|-
+
|- valign="top"
 
| [[Production.Product_(table)|Production.Product]]
 
| [[Production.Product_(table)|Production.Product]]
 
| UnitMeasureCode
 
| UnitMeasureCode
 
| WeightUnitMeasureCode
 
| WeightUnitMeasureCode
−
|-
+
|- valign="top"
 
| [[Purchasing.ProductVendor_(table)|Purchasing.ProductVendor]]
 
| [[Purchasing.ProductVendor_(table)|Purchasing.ProductVendor]]
 
| UnitMeasureCode
 
| UnitMeasureCode
Line 66: Line 87:
 
|}
 
|}
  
−
 
+
=== References ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 73: Line 94:
 
| '''Referenced Object
 
| '''Referenced Object
  
−
|-
+
|- valign="top"
 
| Data Type
 
| Data Type
 
| Type
 
| Type
 
| [[dbo.Name_(type)|dbo.Name]]
 
| [[dbo.Name_(type)|dbo.Name]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
  
 
|}
 
|}
 +
 +
 
== wikivalues ==
 
== wikivalues ==
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table Values
 
| '''Table Values
 
| Production.UnitMeasure
 
| Production.UnitMeasure
−
|-
 
 
|}
 
|}
  
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
  
−
{| border="1" cellpadding="5" cellspacing="0"  style="border-collapse:collapse"
 
−
|- style="background:silver"
 
 
| '''UnitMeasureCode
 
| '''UnitMeasureCode
 
| '''Name
 
| '''Name
−
|-  
+
|- valign="top"
−
| BTL
+
 
−
| Bottle
+
| BTL
−
|-  
+
| Bottle
−
| BOX
+
|- valign="top"
−
| Boxes
+
 
−
|-  
+
| BOX
−
| CAN
+
| Boxes
−
| Canister
+
|- valign="top"
−
|-  
+
 
−
| CAR
+
| CAN
−
| Carton
+
| Canister
−
|-  
+
|- valign="top"
−
| CS  
+
 
−
| Case
+
| CAR
−
|-  
+
| Carton
−
| C   
+
|- valign="top"
−
| Celsius
+
 
−
|-  
+
| CS  
−
| CM  
+
| Case
−
| Centimeter
+
|- valign="top"
−
|-  
+
 
−
| CTN
+
| C   
−
| Container
+
| Celsius
−
|-  
+
|- valign="top"
−
| CR  
+
 
−
| Crate
+
| CM  
−
|-  
+
| Centimeter
−
| CCM
+
|- valign="top"
−
| Cubic centimeter
+
 
−
|-  
+
| CTN
−
| CDM
+
| Container
−
| Cubic decimeter
+
|- valign="top"
−
|-  
+
 
−
| FT3
+
| CR  
−
| Cubic foot
+
| Crate
−
|-  
+
|- valign="top"
−
| M3  
+
 
−
| Cubic meter
+
| CCM
−
|-  
+
| Cubic centimeter
−
| CBM
+
|- valign="top"
−
| Cubic meters
+
 
−
|-  
+
| CDM
−
| DM  
+
| Cubic decimeter
−
| Decimeter
+
|- valign="top"
−
|-  
+
 
−
| DZ  
+
| FT3
−
| Dozen
+
| Cubic foot
−
|-  
+
|- valign="top"
−
| EA  
+
 
−
| Each
+
| M3  
−
|-  
+
| Cubic meter
−
| GAL
+
|- valign="top"
−
| Gallon
+
 
−
|-  
+
| CBM
−
| G   
+
| Cubic meters
−
| Gram
+
|- valign="top"
−
|-  
+
 
−
| IN  
+
| DM  
−
| Inch
+
| Decimeter
−
|-  
+
|- valign="top"
−
| KG  
+
 
−
| Kilogram
+
| DZ  
−
|-  
+
| Dozen
−
| KGV
+
|- valign="top"
−
| Kilogram/cubic meter
+
 
−
|-  
+
| EA  
−
| KM  
+
| Each
−
| Kilometer
+
|- valign="top"
−
|-  
+
 
−
| KT  
+
| GAL
−
| Kiloton
+
| Gallon
−
|-  
+
|- valign="top"
−
| L   
+
 
−
| Liter
+
| G   
−
|-  
+
| Gram
−
| M   
+
|- valign="top"
−
| Meter
+
 
−
|-  
+
| IN  
−
| MG  
+
| Inch
−
| Milligram
+
|- valign="top"
−
|-  
+
 
−
| ML  
+
| KG  
−
| Milliliter
+
| Kilogram
−
|-  
+
|- valign="top"
−
| MM  
+
 
−
| Millimeter
+
| KGV
−
|-  
+
| Kilogram/cubic meter
−
| OZ  
+
|- valign="top"
−
| Ounces
+
 
−
|-  
+
| KM  
−
| PAK
+
| Kilometer
−
| Pack
+
|- valign="top"
−
|-  
+
 
−
| PAL
+
| KT  
−
| Pallet
+
| Kiloton
−
|-  
+
|- valign="top"
−
| PCT
+
 
−
| Percentage
+
| L   
−
|-  
+
| Liter
−
| PC  
+
|- valign="top"
−
| Piece
+
 
−
|-  
+
| M   
−
| PT  
+
| Meter
−
| Pint, US liquid
+
|- valign="top"
−
|-  
+
 
−
| CM2
+
| MG  
−
| Square centimeter
+
| Milligram
−
|-  
+
|- valign="top"
−
| M2  
+
 
−
| Square meter
+
| ML  
−
|-  
+
| Milliliter
−
| LB  
+
|- valign="top"
−
| US pound
+
 
 +
| MM  
 +
| Millimeter
 +
|- valign="top"
 +
 
 +
| OZ  
 +
| Ounces
 +
|- valign="top"
 +
 
 +
| PAK
 +
| Pack
 +
|- valign="top"
 +
 
 +
| PAL
 +
| Pallet
 +
|- valign="top"
 +
 
 +
| PCT
 +
| Percentage
 +
|- valign="top"
 +
 
 +
| PC  
 +
| Piece
 +
|- valign="top"
 +
 
 +
| PT  
 +
| Pint, US liquid
 +
|- valign="top"
 +
 
 +
| CM2
 +
| Square centimeter
 +
|- valign="top"
 +
 
 +
| M2  
 +
| Square meter
 +
|- valign="top"
 +
 
 +
| LB  
 +
| US pound
 
|}
 
|}
  

Latest revision as of 09:55, 27 August 2011

wikibot[edit]

Table Production.UnitMeasure
Description Unit of measure lookup table.

Columns[edit]

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[edit]

Primary Key Columns
PK_UnitMeasure_UnitMeasureCode UnitMeasureCode

Indexes[edit]

Index Type Columns
AK_UnitMeasure_Name Unique Name

Detail Tables[edit]

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

References[edit]

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


wikivalues[edit]

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[edit]

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
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.UnitMeasure_(table)&oldid=2936"