Difference between revisions of "Production.Product (table)"

From dbscript Online Help
Jump to: navigation, search
Line 285: Line 285:
 
| ProductID
 
| ProductID
 
|}
 
|}
−
 
 
== automatically generated ==
 
== automatically generated ==
  
Line 307: Line 306:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description
+
| '''Description / PK / Index
−
| '''PK / Index
 
 
 
−
|-
+
|- valign="top"
 
| ProductID
 
| ProductID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key for Product records.
+
| Primary key for Product records.PK_Product_ProductID
−
| PK_Product_ProductID
+
|- valign="top"
−
|-
 
 
| Name
 
| Name
 
| Name
 
| Name
 
| not null
 
| not null
 
|  
 
|  
−
| Name of the product.
+
| Name of the product.AK_Product_Name
−
| AK_Product_Name
+
|- valign="top"
−
|-
 
 
| ProductNumber
 
| ProductNumber
 
| nvarchar(25)
 
| nvarchar(25)
 
| not null
 
| not null
 
|  
 
|  
−
| Unique product identification number.
+
| Unique product identification number.AK_Product_ProductNumber
−
| AK_Product_ProductNumber
+
|- valign="top"
−
|-
 
 
| MakeFlag
 
| MakeFlag
 
| Flag
 
| Flag
Line 337: Line 332:
 
| (1)
 
| (1)
 
| 0 = Product is purchased, 1 = Product is manufactured in-house.
 
| 0 = Product is purchased, 1 = Product is manufactured in-house.
−
|
+
|- valign="top"
−
|-
 
 
| FinishedGoodsFlag
 
| FinishedGoodsFlag
 
| Flag
 
| Flag
Line 344: Line 338:
 
| (1)
 
| (1)
 
| 0 = Product is not a salable item. 1 = Product is salable.
 
| 0 = Product is not a salable item. 1 = Product is salable.
−
|
+
|- valign="top"
−
|-
 
 
| Color
 
| Color
 
| nvarchar(15)
 
| nvarchar(15)
Line 351: Line 344:
 
|  
 
|  
 
| Product color.
 
| Product color.
−
|
+
|- valign="top"
−
|-
 
 
| SafetyStockLevel
 
| SafetyStockLevel
 
| smallint
 
| smallint
Line 358: Line 350:
 
|  
 
|  
 
| Minimum inventory quantity.  
 
| Minimum inventory quantity.  
−
|
+
|- valign="top"
−
|-
 
 
| ReorderPoint
 
| ReorderPoint
 
| smallint
 
| smallint
Line 365: Line 356:
 
|  
 
|  
 
| Inventory level that triggers a purchase order or work order.  
 
| Inventory level that triggers a purchase order or work order.  
−
|
+
|- valign="top"
−
|-
 
 
| StandardCost
 
| StandardCost
 
| money
 
| money
Line 372: Line 362:
 
|  
 
|  
 
| Standard cost of the product.
 
| Standard cost of the product.
−
|
+
|- valign="top"
−
|-
 
 
| ListPrice
 
| ListPrice
 
| money
 
| money
Line 379: Line 368:
 
|  
 
|  
 
| Selling price.
 
| Selling price.
−
|
+
|- valign="top"
−
|-
 
 
| Size
 
| Size
 
| nvarchar(5)
 
| nvarchar(5)
Line 386: Line 374:
 
|  
 
|  
 
| Product size.
 
| Product size.
−
|
+
|- valign="top"
−
|-
 
 
| SizeUnitMeasureCode
 
| SizeUnitMeasureCode
 
| nchar(3)
 
| nchar(3)
Line 393: Line 380:
 
|  
 
|  
 
| Unit of measure for Size column.
 
| Unit of measure for Size column.
−
|
+
|- valign="top"
−
|-
 
 
| WeightUnitMeasureCode
 
| WeightUnitMeasureCode
 
| nchar(3)
 
| nchar(3)
Line 400: Line 386:
 
|  
 
|  
 
| Unit of measure for Weight column.
 
| Unit of measure for Weight column.
−
|
+
|- valign="top"
−
|-
 
 
| Weight
 
| Weight
 
| decimal(8, 2)
 
| decimal(8, 2)
Line 407: Line 392:
 
|  
 
|  
 
| Product weight.
 
| Product weight.
−
|
+
|- valign="top"
−
|-
 
 
| DaysToManufacture
 
| DaysToManufacture
 
| int
 
| int
Line 414: Line 398:
 
|  
 
|  
 
| Number of days required to manufacture the product.
 
| Number of days required to manufacture the product.
−
|
+
|- valign="top"
−
|-
 
 
| ProductLine
 
| ProductLine
 
| nchar(2)
 
| nchar(2)
Line 421: Line 404:
 
|  
 
|  
 
| R = Road, M = Mountain, T = Touring, S = Standard
 
| R = Road, M = Mountain, T = Touring, S = Standard
−
|
+
|- valign="top"
−
|-
 
 
| Class
 
| Class
 
| nchar(2)
 
| nchar(2)
Line 428: Line 410:
 
|  
 
|  
 
| H = High, M = Medium, L = Low
 
| H = High, M = Medium, L = Low
−
|
+
|- valign="top"
−
|-
 
 
| Style
 
| Style
 
| nchar(2)
 
| nchar(2)
Line 435: Line 416:
 
|  
 
|  
 
| W = Womens, M = Mens, U = Universal
 
| W = Womens, M = Mens, U = Universal
−
|
+
|- valign="top"
−
|-
 
 
| ProductSubcategoryID
 
| ProductSubcategoryID
 
| int
 
| int
Line 442: Line 422:
 
|  
 
|  
 
| 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.  
−
|
+
|- valign="top"
−
|-
 
 
| ProductModelID
 
| ProductModelID
 
| int
 
| int
Line 449: Line 428:
 
|  
 
|  
 
| 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.
−
|
+
|- valign="top"
−
|-
 
 
| SellStartDate
 
| SellStartDate
 
| datetime
 
| datetime
Line 456: Line 434:
 
|  
 
|  
 
| Date the product was available for sale.
 
| Date the product was available for sale.
−
|
+
|- valign="top"
−
|-
 
 
| SellEndDate
 
| SellEndDate
 
| datetime
 
| datetime
Line 463: Line 440:
 
|  
 
|  
 
| Date the product was no longer available for sale.
 
| Date the product was no longer available for sale.
−
|
+
|- valign="top"
−
|-
 
 
| DiscontinuedDate
 
| DiscontinuedDate
 
| datetime
 
| datetime
Line 470: Line 446:
 
|  
 
|  
 
| Date the product was discontinued.
 
| Date the product was discontinued.
−
|
+
|- valign="top"
−
|-
 
 
| rowguid
 
| rowguid
 
| uniqueidentifier
 
| uniqueidentifier
 
| not null
 
| not null
 
| (NEWID())
 
| (NEWID())
−
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
+
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.AK_Product_rowguid
−
| AK_Product_rowguid
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
Line 484: Line 458:
 
| (GETDATE())
 
| (GETDATE())
 
| Date and time the record was last updated.
 
| Date and time the record was last updated.
−
|
 
 
|}
 
|}
  
Line 576: Line 549:
 
| ProductID
 
| ProductID
 
| ProductID
 
| ProductID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Referenced Object
 +
| '''Object Type
 +
| '''Dependency Type
 +
 +
|-
 +
| [[dbo.Flag_(type)|dbo.Flag]]
 +
| Type
 +
| Data Type
 +
|-
 +
| [[dbo.Name_(type)|dbo.Name]]
 +
| Type
 +
| Data Type
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Referencing Object
 +
| '''Object Type
 +
| '''Reference Type
 +
 +
|-
 +
| [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]
 +
| View
 +
| Select
 +
|-
 +
| [[dbo.uspGetBillOfMaterials_(procedure)|dbo.uspGetBillOfMaterials]]
 +
| Procedure
 +
| Select
 +
|-
 +
| [[dbo.uspGetWhereUsedProductID_(procedure)|dbo.uspGetWhereUsedProductID]]
 +
| Procedure
 +
| Select
 +
|-
 +
| [[dbo.ufnGetProductDealerPrice_(function)|dbo.ufnGetProductDealerPrice]]
 +
| Function
 +
| Select
 +
|-
 +
| [[dbo.ufnGetProductListPrice_(function)|dbo.ufnGetProductListPrice]]
 +
| Function
 +
| Select
 +
|-
 +
| [[dbo.ufnGetProductStandardCost_(function)|dbo.ufnGetProductStandardCost]]
 +
| Function
 +
| Select
 
|}
 
|}

Revision as of 23:57, 26 November 2009

wikibot

Table Production.Product


Column Data Type Nullable Default PK Index
ProductID int not null PK_Product_ProductID
Name dbo.Name not null AK_Product_Name
ProductNumber nvarchar(25) not null AK_Product_ProductNumber
MakeFlag dbo.Flag not null ((1))
FinishedGoodsFlag dbo.Flag not null ((1))
Color nvarchar(15) null
SafetyStockLevel smallint not null
ReorderPoint smallint not null
StandardCost money not null
ListPrice money not null
Size nvarchar(5) null
SizeUnitMeasureCode nchar(3) null
WeightUnitMeasureCode nchar(3) null
Weight decimal(8, 2) null
DaysToManufacture int not null
ProductLine nchar(2) null
Class nchar(2) null
Style nchar(2) null
ProductSubcategoryID int null
ProductModelID int null
SellStartDate datetime not null
SellEndDate datetime null
DiscontinuedDate datetime null
rowguid uniqueidentifier not null (newid()) AK_Product_rowguid
ModifiedDate datetime not null (getdate())


Relation Column Referenced Column
Production.ProductModel ProductModelID ProductModelID
Production.ProductSubcategory ProductSubcategoryID ProductSubcategoryID
Production.UnitMeasure SizeUnitMeasureCode UnitMeasureCode
Production.UnitMeasure WeightUnitMeasureCode UnitMeasureCode


Detail Table Column Referencing Column
Production.BillOfMaterials ProductID ComponentID
Production.BillOfMaterials ProductID ProductAssemblyID
Production.ProductCostHistory ProductID ProductID
Production.ProductDocument ProductID ProductID
Production.ProductInventory ProductID ProductID
Production.ProductListPriceHistory ProductID ProductID
Production.ProductProductPhoto ProductID ProductID
Production.ProductReview ProductID ProductID
Purchasing.ProductVendor ProductID ProductID
Purchasing.PurchaseOrderDetail ProductID ProductID
Sales.ShoppingCartItem ProductID ProductID
Sales.SpecialOfferProduct ProductID ProductID
Production.TransactionHistory ProductID ProductID
Production.WorkOrder ProductID ProductID

automatically generated

Table Production.Product
Description Products sold or used in the manfacturing of sold products.


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


Relation Column Referenced Column
Production.ProductModel ProductModelID ProductModelID
Production.ProductSubcategory ProductSubcategoryID ProductSubcategoryID
Production.UnitMeasure SizeUnitMeasureCode UnitMeasureCode
Production.UnitMeasure WeightUnitMeasureCode UnitMeasureCode


Detail Table Column Referencing Column
Production.BillOfMaterials ProductID ComponentID
Production.BillOfMaterials ProductID ProductAssemblyID
Production.ProductCostHistory ProductID ProductID
Production.ProductDocument ProductID ProductID
Production.ProductInventory ProductID ProductID
Production.ProductListPriceHistory ProductID ProductID
Production.ProductProductPhoto ProductID ProductID
Production.ProductReview ProductID ProductID
Purchasing.ProductVendor ProductID ProductID
Purchasing.PurchaseOrderDetail ProductID ProductID
Sales.ShoppingCartItem ProductID ProductID
Sales.SpecialOfferProduct ProductID ProductID
Production.TransactionHistory ProductID ProductID
Production.WorkOrder ProductID ProductID


Referenced Object Object Type Dependency Type
dbo.Flag Type Data Type
dbo.Name Type Data Type


Referencing Object Object Type Reference Type
Production.vProductAndDescription View Select
dbo.uspGetBillOfMaterials Procedure Select
dbo.uspGetWhereUsedProductID Procedure Select
dbo.ufnGetProductDealerPrice Function Select
dbo.ufnGetProductListPrice Function Select
dbo.ufnGetProductStandardCost Function Select
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.Product_(table)&oldid=1215"