ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
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''' |- | ProductID | int | not null | | Primary key for Product records.<br />PK_Product_ProductID |- | Name | Name | not null | | Name of the product.<br />AK_Product_Name |- | ProductNumber | nvarchar(25) | not null | | Unique product identification number.<br />AK_Product_ProductNumber |- | MakeFlag | Flag | not null | (1) | 0 = Product is purchased, 1 = Product is manufactured in-house.<br /> |- | FinishedGoodsFlag | Flag | not null | (1) | 0 = Product is not a salable item. 1 = Product is salable.<br /> |- | Color | nvarchar(15) | null | | Product color.<br /> |- | SafetyStockLevel | smallint | not null | | Minimum inventory quantity. <br /> |- | ReorderPoint | smallint | not null | | Inventory level that triggers a purchase order or work order. <br /> |- | StandardCost | money | not null | | Standard cost of the product.<br /> |- | ListPrice | money | not null | | Selling price.<br /> |- | Size | nvarchar(5) | null | | Product size.<br /> |- | SizeUnitMeasureCode | nchar(3) | null | | Unit of measure for Size column.<br /> |- | WeightUnitMeasureCode | nchar(3) | null | | Unit of measure for Weight column.<br /> |- | Weight | decimal(8, 2) | null | | Product weight.<br /> |- | DaysToManufacture | int | not null | | Number of days required to manufacture the product.<br /> |- | ProductLine | nchar(2) | null | | R = Road, M = Mountain, T = Touring, S = Standard<br /> |- | Class | nchar(2) | null | | H = High, M = Medium, L = Low<br /> |- | Style | nchar(2) | null | | W = Womens, M = Mens, U = Universal<br /> |- | ProductSubcategoryID | int | null | | Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID. <br /> |- | ProductModelID | int | null | | Product is a member of this product model. Foreign key to ProductModel.ProductModelID.<br /> |- | SellStartDate | datetime | not null | | Date the product was available for sale.<br /> |- | SellEndDate | datetime | null | | Date the product was no longer available for sale.<br /> |- | DiscontinuedDate | datetime | null | | Date the product was discontinued.<br /> |- | rowguid | uniqueidentifier | not null | (NEWID()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_Product_rowguid |- | ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated.<br /> |} {| 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]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.