Editing Production.Product (table)

== 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
| 
| Primary key for Product records.
|- valign="top"
| Name
| dbo.Name
| not null
| 
| Name of the product.
|- valign="top"
| ProductNumber
| nvarchar(25)
| not null
| 
| 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
| 
| Product color.
|- valign="top"
| SafetyStockLevel
| smallint
| not null
| 
| Minimum inventory quantity. 
|- valign="top"
| ReorderPoint
| smallint
| not null
| 
| Inventory level that triggers a purchase order or work order. 
|- valign="top"
| StandardCost
| money
| not null
| 
| Standard cost of the product.
|- valign="top"
| ListPrice
| money
| not null
| 
| Selling price.
|- valign="top"
| Size
| nvarchar(5)
| null
| 
| Product size.
|- valign="top"
| SizeUnitMeasureCode
| nchar(3)
| null
| 
| Unit of measure for Size column.
|- valign="top"
| WeightUnitMeasureCode
| nchar(3)
| null
| 
| Unit of measure for Weight column.
|- valign="top"
| Weight
| decimal(8, 2)
| null
| 
| Product weight.
|- valign="top"
| DaysToManufacture
| int
| not null
| 
| Number of days required to manufacture the product.
|- valign="top"
| ProductLine
| nchar(2)
| null
| 
| R = Road, M = Mountain, T = Touring, S = Standard
|- valign="top"
| Class
| nchar(2)
| null
| 
| H = High, M = Medium, L = Low
|- valign="top"
| Style
| nchar(2)
| null
| 
| W = Womens, M = Mens, U = Universal
|- valign="top"
| ProductSubcategoryID
| int
| null
| 
| Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID. 
|- valign="top"
| ProductModelID
| int
| null
| 
| Product is a member of this product model. Foreign key to ProductModel.ProductModelID.
|- valign="top"
| SellStartDate
| datetime
| not null
| 
| Date the product was available for sale.
|- valign="top"
| SellEndDate
| datetime
| null
| 
| Date the product was no longer available for sale.
|- valign="top"
| DiscontinuedDate
| datetime
| null
| 
| 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]]

|}


== automatically generated ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| Production.Product
|- valign="top"
| '''Description
| Products sold or used in the manfacturing of sold products.
|-
|}


{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''Description / PK / Index
		
|- valign="top"
| ProductID
| int
| not null
| 
| Primary key for Product records.PK_Product_ProductID
|- valign="top"
| Name
| Name
| not null
| 
| Name of the product.AK_Product_Name
|- valign="top"
| ProductNumber
| nvarchar(25)
| not null
| 
| Unique product identification number.AK_Product_ProductNumber
|- valign="top"
| MakeFlag
| Flag
| not null
| (1)
| 0 = Product is purchased, 1 = Product is manufactured in-house.
|- valign="top"
| FinishedGoodsFlag
| Flag
| not null
| (1)
| 0 = Product is not a salable item. 1 = Product is salable.
|- valign="top"
| Color
| nvarchar(15)
| null
| 
| Product color.
|- valign="top"
| SafetyStockLevel
| smallint
| not null
| 
| Minimum inventory quantity. 
|- valign="top"
| ReorderPoint
| smallint
| not null
| 
| Inventory level that triggers a purchase order or work order. 
|- valign="top"
| StandardCost
| money
| not null
| 
| Standard cost of the product.
|- valign="top"
| ListPrice
| money
| not null
| 
| Selling price.
|- valign="top"
| Size
| nvarchar(5)
| null
| 
| Product size.
|- valign="top"
| SizeUnitMeasureCode
| nchar(3)
| null
| 
| Unit of measure for Size column.
|- valign="top"
| WeightUnitMeasureCode
| nchar(3)
| null
| 
| Unit of measure for Weight column.
|- valign="top"
| Weight
| decimal(8, 2)
| null
| 
| Product weight.
|- valign="top"
| DaysToManufacture
| int
| not null
| 
| Number of days required to manufacture the product.
|- valign="top"
| ProductLine
| nchar(2)
| null
| 
| R = Road, M = Mountain, T = Touring, S = Standard
|- valign="top"
| Class
| nchar(2)
| null
| 
| H = High, M = Medium, L = Low
|- valign="top"
| Style
| nchar(2)
| null
| 
| W = Womens, M = Mens, U = Universal
|- valign="top"
| ProductSubcategoryID
| int
| null
| 
| Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID. 
|- valign="top"
| ProductModelID
| int
| null
| 
| Product is a member of this product model. Foreign key to ProductModel.ProductModelID.
|- valign="top"
| SellStartDate
| datetime
| not null
| 
| Date the product was available for sale.
|- valign="top"
| SellEndDate
| datetime
| null
| 
| Date the product was no longer available for sale.
|- valign="top"
| DiscontinuedDate
| datetime
| null
| 
| 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.AK_Product_rowguid
|- valign="top"
| ModifiedDate
| datetime
| not null
| (GETDATE())
| Date and time the record was last updated.
|}



{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation
| '''Column
| '''Referenced Column
		
|-
| [[Production.ProductModel_(table)|Production.ProductModel]]
| ProductModelID
| ProductModelID
|-
| [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]]
| ProductSubcategoryID
| ProductSubcategoryID
|-
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]]
| SizeUnitMeasureCode
| UnitMeasureCode
|-
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]]
| WeightUnitMeasureCode
| UnitMeasureCode
|}


{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table
| '''Column
| '''Referencing Column
		
|-
| [[Production.BillOfMaterials_(table)|Production.BillOfMaterials]]
| ProductID
| ComponentID
|-
| [[Production.BillOfMaterials_(table)|Production.BillOfMaterials]]
| ProductID
| ProductAssemblyID
|-
| [[Production.ProductCostHistory_(table)|Production.ProductCostHistory]]
| ProductID
| ProductID
|-
| [[Production.ProductDocument_(table)|Production.ProductDocument]]
| ProductID
| ProductID
|-
| [[Production.ProductInventory_(table)|Production.ProductInventory]]
| ProductID
| ProductID
|-
| [[Production.ProductListPriceHistory_(table)|Production.ProductListPriceHistory]]
| ProductID
| ProductID
|-
| [[Production.ProductProductPhoto_(table)|Production.ProductProductPhoto]]
| ProductID
| ProductID
|-
| [[Production.ProductReview_(table)|Production.ProductReview]]
| ProductID
| ProductID
|-
| [[Purchasing.ProductVendor_(table)|Purchasing.ProductVendor]]
| ProductID
| ProductID
|-
| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
| ProductID
| ProductID
|-
| [[Sales.ShoppingCartItem_(table)|Sales.ShoppingCartItem]]
| ProductID
| ProductID
|-
| [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]]
| ProductID
| ProductID
|-
| [[Production.TransactionHistory_(table)|Production.TransactionHistory]]
| ProductID
| ProductID
|-
| [[Production.WorkOrder_(table)|Production.WorkOrder]]
| ProductID
| ProductID
|}


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

|-
| Data Type
| Type
| [[dbo.Flag_(type)|dbo.Flag]]

|-
| Data Type
| Type
| [[dbo.Name_(type)|dbo.Name]]

|-
| Schema
| Schema
| [[Production_(schema)|Production]]

|}


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

|-
| Select
| View
| [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]

|-
| Select
| Procedure
| [[dbo.uspGetBillOfMaterials_(procedure)|dbo.uspGetBillOfMaterials]]

|-
| Select
| Procedure
| [[dbo.uspGetWhereUsedProductID_(procedure)|dbo.uspGetWhereUsedProductID]]

|-
| Select
| Function
| [[dbo.ufnGetProductDealerPrice_(function)|dbo.ufnGetProductDealerPrice]]

|-
| Select
| Function
| [[dbo.ufnGetProductListPrice_(function)|dbo.ufnGetProductListPrice]]

|-
| Select
| Function
| [[dbo.ufnGetProductStandardCost_(function)|dbo.ufnGetProductStandardCost]]

|}