Production.Product (table) - Revision history

Bot at 08:55, 27 August 2011

2011-08-27T08:55:20Z

Bot at 22:16, 23 June 2010

2010-06-23T22:16:36Z

Show changes

Bot at 22:06, 2 February 2010

2010-02-02T22:06:36Z

Show changes

Bot at 21:54, 28 December 2009

2009-12-28T21:54:44Z

Show changes

Bot at 05:59, 30 November 2009

2009-11-30T05:59:28Z

Bot at 05:34, 30 November 2009

2009-11-30T05:34:50Z

Bot at 05:32, 30 November 2009

2009-11-30T05:32:08Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:51Z

Bot at 23:12, 26 November 2009

2009-11-26T23:12:57Z

Bot at 23:10, 26 November 2009

2009-11-26T23:10:20Z

@@ Line 188: / Line 188: @@
 | '''Columns
 |- valign="top"
 | AK_Product_ProductNumber
 | Unique
 | ProductNumber
 |- valign="top"
 | AK_Product_rowguid

@@ Line 292: / Line 292: @@
 | Production.Product
 |- valign="top"
 | '''Description
 | Products sold or used in the manfacturing of sold products.
 |-
 |}

@@ Line 571: / Line 571: @@
 | Schema
 | Schema
-| [[Production_(schema)|.Production]]
+| [[Production_(schema)|Production]]
 |}

@@ Line 554: / Line 554: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | [[dbo.Flag_(type)|dbo.Flag]]
 | Type
 | [[dbo.Name_(type)|dbo.Name]]
-| Type
 |-
 | Schema
 | Schema
 |}
@@ Line 575: / Line 578: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referencing Object
 |-
 | [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]
-| View
 | Select
 |-
-| [[dbo.uspGetBillOfMaterials_(procedure)|dbo.uspGetBillOfMaterials]]
+| Select
 | Procedure
 | Select
 |-
 | Select
 |-
 | Select
 | Function
 | [[dbo.ufnGetProductStandardCost_(function)|dbo.ufnGetProductStandardCost]]
-| Function
 |}

@@ Line 557: / Line 557: @@
 | '''Object Type
 | '''Dependency Type
-−
 |-
 | [[dbo.Flag_(type)|dbo.Flag]]
@@ Line 566: / Line 566: @@
 | Type
 | Data Type
 |}
@@ Line 574: / Line 578: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]

@@ Line 313: / Line 313: @@
 | not null
+|
-| Primary key for Product records.PK_Product_ProductID
+| Primary key for Product records.<br />PK_Product_ProductID
 |- valign="top"
 | Name
@@ Line 319: / Line 319: @@
 | not null
+|
-| Name of the product.AK_Product_Name
+| Name of the product.<br />AK_Product_Name
 |- valign="top"
 | ProductNumber
@@ Line 325: / Line 325: @@
 | not null
+|
-| Unique product identification number.AK_Product_ProductNumber
+| Unique product identification number.<br />AK_Product_ProductNumber
 |- valign="top"
 | MakeFlag
@@ Line 331: / Line 331: @@
 | not null
 | (1)
-| 0 = Product is purchased, 1 = Product is manufactured in-house.
+| 0 = Product is purchased, 1 = Product is manufactured in-house.<br />
 |- valign="top"
 | FinishedGoodsFlag
@@ Line 337: / Line 337: @@
 | not null
 | (1)
-| 0 = Product is not a salable item. 1 = Product is salable.
+| 0 = Product is not a salable item. 1 = Product is salable.<br />
 |- valign="top"
 | Color
@@ Line 343: / Line 343: @@
 | null
+|
-| Product color.
+| Product color.<br />
 |- valign="top"
 | SafetyStockLevel
@@ Line 349: / Line 349: @@
 | not null
+|
-| Minimum inventory quantity.
+| Minimum inventory quantity. <br />
 |- valign="top"
 | ReorderPoint
@@ Line 355: / Line 355: @@
 | not null
+|
-| Inventory level that triggers a purchase order or work order.
+| Inventory level that triggers a purchase order or work order. <br />
 |- valign="top"
 | StandardCost
@@ Line 361: / Line 361: @@
 | not null
+|
-| Standard cost of the product.
+| Standard cost of the product.<br />
 |- valign="top"
 | ListPrice
@@ Line 367: / Line 367: @@
 | not null
+|
-| Selling price.
+| Selling price.<br />
 |- valign="top"
 | Size
@@ Line 373: / Line 373: @@
 | null
+|
-| Product size.
+| Product size.<br />
 |- valign="top"
 | SizeUnitMeasureCode
@@ Line 379: / Line 379: @@
 | null
+|
-| Unit of measure for Size column.
+| Unit of measure for Size column.<br />
 |- valign="top"
 | WeightUnitMeasureCode
@@ Line 385: / Line 385: @@
 | null
+|
-| Unit of measure for Weight column.
+| Unit of measure for Weight column.<br />
 |- valign="top"
 | Weight
@@ Line 391: / Line 391: @@
 | null
+|
-| Product weight.
+| Product weight.<br />
 |- valign="top"
 | DaysToManufacture
@@ Line 397: / Line 397: @@
 | not null
+|
-| Number of days required to manufacture the product.
+| Number of days required to manufacture the product.<br />
 |- valign="top"
 | ProductLine
@@ Line 403: / Line 403: @@
 | null
+|
-| R = Road, M = Mountain, T = Touring, S = Standard
+| R = Road, M = Mountain, T = Touring, S = Standard<br />
 |- valign="top"
 | Class
@@ Line 409: / Line 409: @@
 | null
+|
-| H = High, M = Medium, L = Low
+| H = High, M = Medium, L = Low<br />
 |- valign="top"
 | Style
@@ Line 415: / Line 415: @@
 | null
+|
-| W = Womens, M = Mens, U = Universal
+| W = Womens, M = Mens, U = Universal<br />
 |- valign="top"
 | ProductSubcategoryID
@@ Line 421: / Line 421: @@
 | null
+|
-| Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID.
+| Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID. <br />
 |- valign="top"
 | ProductModelID
@@ Line 427: / Line 427: @@
 | null
+|
-| Product is a member of this product model. Foreign key to ProductModel.ProductModelID.
+| Product is a member of this product model. Foreign key to ProductModel.ProductModelID.<br />
 |- valign="top"
 | SellStartDate
@@ Line 433: / Line 433: @@
 | not null
+|
-| Date the product was available for sale.
+| Date the product was available for sale.<br />
 |- valign="top"
 | SellEndDate
@@ Line 439: / Line 439: @@
 | null
+|
-| Date the product was no longer available for sale.
+| Date the product was no longer available for sale.<br />
 |- valign="top"
 | DiscontinuedDate
@@ Line 445: / Line 445: @@
 | null
+|
-| Date the product was discontinued.
+| Date the product was discontinued.<br />
 |- valign="top"
 | rowguid
@@ Line 451: / Line 451: @@
 | not null
 | (NEWID())
-| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.AK_Product_rowguid
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_Product_rowguid
 |- valign="top"
 | ModifiedDate
@@ Line 457: / Line 457: @@
 | not null
 | (GETDATE())
-| Date and time the record was last updated.
+| Date and time the record was last updated.<br />
 |}