Production Product (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.Product
|- valign="top"
| '''Description'''
| Products sold or used in the manfacturing of sold products.
|}

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

|- valign="top"
| ProductID
| int
| not null
| &nbsp;
| Primary key for Product records.
|- valign="top"
| Name
| dbo.Name
| not null
| &nbsp;
| Name of the product.
|- valign="top"
| ProductNumber
| nvarchar(25)
| not null
| &nbsp;
| Unique product identification number.
|- valign="top"
| MakeFlag
| dbo.Flag
| not null
| ((1))
| 0 = Product is purchased, 1 = Product is manufactured in-house.
|- valign="top"
| FinishedGoodsFlag
| dbo.Flag
| not null
| ((1))
| 0 = Product is not a salable item. 1 = Product is salable.
|- valign="top"
| Color
| nvarchar(15)
| null
| &nbsp;
| Product color.
|- valign="top"
| SafetyStockLevel
| smallint
| not null
| &nbsp;
| Minimum inventory quantity. 
|- valign="top"
| ReorderPoint
| smallint
| not null
| &nbsp;
| Inventory level that triggers a purchase order or work order. 
|- valign="top"
| StandardCost
| money
| not null
| &nbsp;
| Standard cost of the product.
|- valign="top"
| ListPrice
| money
| not null
| &nbsp;
| Selling price.
|- valign="top"
| Size
| nvarchar(5)
| null
| &nbsp;
| Product size.
|- valign="top"
| SizeUnitMeasureCode
| nchar(3)
| null
| &nbsp;
| Unit of measure for Size column.
|- valign="top"
| WeightUnitMeasureCode
| nchar(3)
| null
| &nbsp;
| Unit of measure for Weight column.
|- valign="top"
| Weight
| decimal(8, 2)
| null
| &nbsp;
| Product weight.
|- valign="top"
| DaysToManufacture
| int
| not null
| &nbsp;
| Number of days required to manufacture the product.
|- valign="top"
| ProductLine
| nchar(2)
| null
| &nbsp;
| R = Road, M = Mountain, T = Touring, S = Standard
|- valign="top"
| Class
| nchar(2)
| null
| &nbsp;
| H = High, M = Medium, L = Low
|- valign="top"
| Style
| nchar(2)
| null
| &nbsp;
| W = Womens, M = Mens, U = Universal
|- valign="top"
| ProductSubcategoryID
| int
| null
| &nbsp;
| Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID. 
|- valign="top"
| ProductModelID
| int
| null
| &nbsp;
| Product is a member of this product model. Foreign key to ProductModel.ProductModelID.
|- valign="top"
| SellStartDate
| datetime
| not null
| &nbsp;
| Date the product was available for sale.
|- valign="top"
| SellEndDate
| datetime
| null
| &nbsp;
| Date the product was no longer available for sale.
|- valign="top"
| DiscontinuedDate
| datetime
| null
| &nbsp;
| Date the product was discontinued.
|- valign="top"
| rowguid
| uniqueidentifier
| not null
| (newid())
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|- 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_Product_ProductID
| ProductID
|}

=== Indexes ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Index'''
| '''Type'''
| '''Columns'''

|- valign="top"
| AK_Product_Name
| Unique
| Name
|- valign="top"
| AK_Product_ProductNumber
| Unique
| ProductNumber
|- valign="top"
| AK_Product_rowguid
| Unique
| rowguid
|}

=== Check Constraints ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Check Constraint'''
| '''Expression'''
| '''Description'''

|- valign="top"
| CK_Product_Class
| (upper([Class])='H' OR upper([Class])='M' OR upper([Class])='L' OR [Class] IS NULL)
| Check constraint [Class]='h' OR [Class]='m' OR [Class]='l' OR [Class]='H' OR [Class]='M' OR [Class]='L' OR [Class] IS NULL
|- valign="top"
| CK_Product_DaysToManufacture
| ([DaysToManufacture]>=(0))
| Check constraint [DaysToManufacture] >= (0)
|- valign="top"
| CK_Product_ListPrice
| ([ListPrice]>=(0.00))
| Check constraint [ListPrice] >= (0.00)
|- valign="top"
| CK_Product_ProductLine
| (upper([ProductLine])='R' OR upper([ProductLine])='M' OR upper([ProductLine])='T' OR upper([ProductLine])='S' OR [ProductLine] IS NULL)
| Check constraint [ProductLine]='r' OR [ProductLine]='m' OR [ProductLine]='t' OR [ProductLine]='s' OR [ProductLine]='R' OR [ProductLine]='M' OR [ProductLine]='T' OR [ProductLine]='S' OR [ProductLine] IS NULL
|- valign="top"
| CK_Product_ReorderPoint
| ([ReorderPoint]>(0))
| Check constraint [ReorderPoint] > (0)
|- valign="top"
| CK_Product_SafetyStockLevel
| ([SafetyStockLevel]>(0))
| Check constraint [SafetyStockLevel] > (0)
|- valign="top"
| CK_Product_SellEndDate
| ([SellEndDate]>=[SellStartDate] OR [SellEndDate] IS NULL)
| Check constraint [SellEndDate] >= [SellStartDate] OR [SellEndDate] IS NULL
|- valign="top"
| CK_Product_StandardCost
| ([StandardCost]>=(0.00))
| Check constraint [SafetyStockLevel] > (0)
|- valign="top"
| CK_Product_Style
| (upper([Style])='U' OR upper([Style])='M' OR upper([Style])='W' OR [Style] IS NULL)
| Check constraint [Style]='u' OR [Style]='m' OR [Style]='w' OR [Style]='U' OR [Style]='M' OR [Style]='W' OR [Style] IS NULL
|- valign="top"
| CK_Product_Weight
| ([Weight]>(0.00))
| Check constraint [Weight] > (0.00)
|}

=== Foreign Keys ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation'''
| '''Column'''
| '''Referenced Column'''

|- valign="top"
| [[Production ProductModel (table)|Production.ProductModel]]
| ProductModelID
| ProductModelID
|- valign="top"
| [[Production ProductSubcategory (table)|Production.ProductSubcategory]]
| ProductSubcategoryID
| ProductSubcategoryID
|- valign="top"
| [[Production UnitMeasure (table)|Production.UnitMeasure]]
| SizeUnitMeasureCode
| UnitMeasureCode
|- valign="top"
| [[Production UnitMeasure (table)|Production.UnitMeasure]]
| WeightUnitMeasureCode
| UnitMeasureCode
|}

=== 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]]
| ProductID
| ComponentID
|- valign="top"
| [[Production BillOfMaterials (table)|Production.BillOfMaterials]]
| ProductID
| ProductAssemblyID
|- valign="top"
| [[Production ProductCostHistory (table)|Production.ProductCostHistory]]
| ProductID
| ProductID
|- valign="top"
| [[Production ProductDocument (table)|Production.ProductDocument]]
| ProductID
| ProductID
|- valign="top"
| [[Production ProductInventory (table)|Production.ProductInventory]]
| ProductID
| ProductID
|- valign="top"
| [[Production ProductListPriceHistory (table)|Production.ProductListPriceHistory]]
| ProductID
| ProductID
|- valign="top"
| [[Production ProductProductPhoto (table)|Production.ProductProductPhoto]]
| ProductID
| ProductID
|- valign="top"
| [[Production ProductReview (table)|Production.ProductReview]]
| ProductID
| ProductID
|- valign="top"
| [[Purchasing ProductVendor (table)|Purchasing.ProductVendor]]
| ProductID
| ProductID
|- valign="top"
| [[Purchasing PurchaseOrderDetail (table)|Purchasing.PurchaseOrderDetail]]
| ProductID
| ProductID
|- valign="top"
| [[Sales ShoppingCartItem (table)|Sales.ShoppingCartItem]]
| ProductID
| ProductID
|- valign="top"
| [[Sales SpecialOfferProduct (table)|Sales.SpecialOfferProduct]]
| ProductID
| ProductID
|- valign="top"
| [[Production TransactionHistory (table)|Production.TransactionHistory]]
| ProductID
| ProductID
|- valign="top"
| [[Production WorkOrder (table)|Production.WorkOrder]]
| ProductID
| ProductID
|}

=== 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 Flag (type)|dbo.Flag]]

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

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

|}

=== Dependencies ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Reference Type'''
| '''Object Type'''
| '''Referencing Object'''

|- valign="top"
| Select
| View
| [[Production vProductAndDescription (view)|Production.vProductAndDescription]]

|- valign="top"
| Select
| Procedure
| [[dbo uspGetBillOfMaterials (procedure)|dbo.uspGetBillOfMaterials]]

|- valign="top"
| Select
| Procedure
| [[dbo uspGetWhereUsedProductID (procedure)|dbo.uspGetWhereUsedProductID]]

|- valign="top"
| Select
| Function
| [[dbo ufnGetProductDealerPrice (function)|dbo.ufnGetProductDealerPrice]]

|- valign="top"
| Select
| Function
| [[dbo ufnGetProductListPrice (function)|dbo.ufnGetProductListPrice]]

|- valign="top"
| Select
| Function
| [[dbo ufnGetProductStandardCost (function)|dbo.ufnGetProductStandardCost]]

|}
devio dbscript ScrewTurn Wiki

Navigation¶

Production Product (table)
