Difference between revisions of "Production.UnitMeasure (table)"
(One intermediate revision by the same user not shown) | |||
Line 110: | Line 110: | ||
{| 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" | ||
− | |||
− | |||
| '''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
Contents
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 |