From dbscript Online Help
|
|
| Line 105: |
Line 105: |
| | | | |
| | |} | | |} |
| | + | |
| | + | |
| | == wikivalues == | | == wikivalues == |
| | | | |
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]
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.
|
| Dependency Type
|
Object Type
|
Referenced Object
|
| Data Type
|
Type
|
dbo.Name
|
| Schema
|
Schema
|
Production
|
