Production UnitMeasure (table)

Modified on 2011/08/27 11:18 by wikibot Categorized as Uncategorized
== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table'''
| Production.UnitMeasure
|- valign="top"
| '''Description'''
| Unit of measure lookup table.
|}

=== Columns ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column'''
| '''Data Type'''
| '''Nullable'''
| '''Default'''
| '''Description'''

|- valign="top"
| UnitMeasureCode
| nchar(3)
| not null
| &nbsp;
| Primary key.
|- valign="top"
| Name
| dbo.Name
| not null
| &nbsp;
| Unit of measure description.
|- valign="top"
| ModifiedDate
| datetime
| not null
| (getdate())
| 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"
|- style="background:silver"
| '''Detail Table'''
| '''Column'''
| '''Referencing Column'''

|- valign="top"
| [[Production BillOfMaterials (table)|Production.BillOfMaterials]]
| UnitMeasureCode
| UnitMeasureCode
|- valign="top"
| [[Production Product (table)|Production.Product]]
| UnitMeasureCode
| SizeUnitMeasureCode
|- valign="top"
| [[Production Product (table)|Production.Product]]
| UnitMeasureCode
| WeightUnitMeasureCode
|- valign="top"
| [[Purchasing ProductVendor (table)|Purchasing.ProductVendor]]
| UnitMeasureCode
| UnitMeasureCode
|}

=== References ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Dependency Type'''
| '''Object Type'''
| '''Referenced Object'''

|- valign="top"
| Data Type
| Type
| [[dbo Name (type)|dbo.Name]]

|- valign="top"
| Schema
| Schema
| [[Production (schema)|Production]]

|}


== wikivalues ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table Values'''
| Production.UnitMeasure
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"

| '''UnitMeasureCode'''

| '''Name'''

|- valign="top"

| BTL
| Bottle
|- valign="top"

| BOX
| Boxes
|- valign="top"

| CAN
| Canister
|- valign="top"

| CAR
| Carton
|- valign="top"

| CS 
| Case
|- valign="top"

| C  
| Celsius
|- valign="top"

| CM 
| Centimeter
|- valign="top"

| CTN
| Container
|- valign="top"

| CR 
| Crate
|- valign="top"

| CCM
| Cubic centimeter
|- valign="top"

| CDM
| Cubic decimeter
|- valign="top"

| FT3
| Cubic foot
|- valign="top"

| M3 
| Cubic meter
|- valign="top"

| CBM
| Cubic meters
|- valign="top"

| DM 
| Decimeter
|- valign="top"

| DZ 
| Dozen
|- valign="top"

| EA 
| Each
|- valign="top"

| GAL
| Gallon
|- valign="top"

| G  
| Gram
|- valign="top"

| IN 
| Inch
|- valign="top"

| KG 
| Kilogram
|- valign="top"

| KGV
| Kilogram/cubic meter
|- valign="top"

| KM 
| Kilometer
|- valign="top"

| KT 
| Kiloton
|- valign="top"

| L  
| Liter
|- valign="top"

| M  
| Meter
|- valign="top"

| MG 
| Milligram
|- valign="top"

| ML 
| Milliliter
|- valign="top"

| 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
|}
devio dbscript ScrewTurn Wiki

Navigation¶

Production UnitMeasure (table)
