Difference between revisions of "Production.Product (table)"
| Line 5: | Line 5: | ||
| '''Table | | '''Table | ||
| Production.Product | | Production.Product | ||
| + | |- valign="top" | ||
| + | | '''Description | ||
| + | | Products sold or used in the manfacturing of sold products. | ||
|- | |- | ||
|} | |} | ||
| Line 15: | Line 18: | ||
| '''Nullable | | '''Nullable | ||
| '''Default | | '''Default | ||
| − | | '''PK | + | | '''Description / PK / Index |
| − | |||
| − | |- | + | |- valign="top" |
| ProductID | | ProductID | ||
| int | | int | ||
| not null | | not null | ||
| | | | ||
| − | | PK_Product_ProductID | + | | Primary key for Product records.<br />PK_Product_ProductID |
| − | + | |- valign="top" | |
| − | |- | ||
| Name | | Name | ||
| dbo.Name | | dbo.Name | ||
| not null | | not null | ||
| | | | ||
| − | | | + | | Name of the product.<br />AK_Product_Name |
| − | + | |- valign="top" | |
| − | |- | ||
| ProductNumber | | ProductNumber | ||
| nvarchar(25) | | nvarchar(25) | ||
| not null | | not null | ||
| | | | ||
| − | | | + | | Unique product identification number.<br />AK_Product_ProductNumber |
| − | + | |- valign="top" | |
| − | |- | ||
| MakeFlag | | MakeFlag | ||
| dbo.Flag | | dbo.Flag | ||
| not null | | not null | ||
| ((1)) | | ((1)) | ||
| − | | | + | | 0 = Product is purchased, 1 = Product is manufactured in-house.<br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| FinishedGoodsFlag | | FinishedGoodsFlag | ||
| dbo.Flag | | dbo.Flag | ||
| not null | | not null | ||
| ((1)) | | ((1)) | ||
| − | | | + | | 0 = Product is not a salable item. 1 = Product is salable.<br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| Color | | Color | ||
| nvarchar(15) | | nvarchar(15) | ||
| null | | null | ||
| | | | ||
| − | | | + | | Product color.<br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| SafetyStockLevel | | SafetyStockLevel | ||
| smallint | | smallint | ||
| not null | | not null | ||
| | | | ||
| − | | | + | | Minimum inventory quantity. <br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| ReorderPoint | | ReorderPoint | ||
| smallint | | smallint | ||
| not null | | not null | ||
| | | | ||
| − | | | + | | Inventory level that triggers a purchase order or work order. <br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| StandardCost | | StandardCost | ||
| money | | money | ||
| not null | | not null | ||
| | | | ||
| − | | | + | | Standard cost of the product.<br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| ListPrice | | ListPrice | ||
| money | | money | ||
| not null | | not null | ||
| | | | ||
| − | | | + | | Selling price.<br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| Size | | Size | ||
| nvarchar(5) | | nvarchar(5) | ||
| null | | null | ||
| | | | ||
| − | | | + | | Product size.<br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| SizeUnitMeasureCode | | SizeUnitMeasureCode | ||
| nchar(3) | | nchar(3) | ||
| null | | null | ||
| | | | ||
| − | | | + | | Unit of measure for Size column.<br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| WeightUnitMeasureCode | | WeightUnitMeasureCode | ||
| nchar(3) | | nchar(3) | ||
| null | | null | ||
| | | | ||
| − | | | + | | Unit of measure for Weight column.<br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| Weight | | Weight | ||
| decimal(8, 2) | | decimal(8, 2) | ||
| null | | null | ||
| | | | ||
| − | | | + | | Product weight.<br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| DaysToManufacture | | DaysToManufacture | ||
| int | | int | ||
| not null | | not null | ||
| | | | ||
| − | | | + | | Number of days required to manufacture the product.<br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| ProductLine | | ProductLine | ||
| nchar(2) | | nchar(2) | ||
| null | | null | ||
| | | | ||
| − | | | + | | R = Road, M = Mountain, T = Touring, S = Standard<br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| Class | | Class | ||
| nchar(2) | | nchar(2) | ||
| null | | null | ||
| | | | ||
| − | | | + | | H = High, M = Medium, L = Low<br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| Style | | Style | ||
| nchar(2) | | nchar(2) | ||
| null | | null | ||
| | | | ||
| − | | | + | | W = Womens, M = Mens, U = Universal<br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| ProductSubcategoryID | | ProductSubcategoryID | ||
| int | | int | ||
| null | | null | ||
| | | | ||
| − | | | + | | Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID. <br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| ProductModelID | | ProductModelID | ||
| int | | int | ||
| null | | null | ||
| | | | ||
| − | | | + | | Product is a member of this product model. Foreign key to ProductModel.ProductModelID.<br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| SellStartDate | | SellStartDate | ||
| datetime | | datetime | ||
| not null | | not null | ||
| | | | ||
| − | | | + | | Date the product was available for sale.<br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| SellEndDate | | SellEndDate | ||
| datetime | | datetime | ||
| null | | null | ||
| | | | ||
| − | | | + | | Date the product was no longer available for sale.<br /> |
| − | + | |- valign="top" | |
| − | |- | ||
| DiscontinuedDate | | DiscontinuedDate | ||
| datetime | | datetime | ||
| null | | null | ||
| | | | ||
| − | | | + | | Date the product was discontinued.<br /> |
| − | + | |- 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.<br />AK_Product_rowguid |
| − | + | |- valign="top" | |
| − | |- | ||
| ModifiedDate | | ModifiedDate | ||
| datetime | | datetime | ||
| not null | | not null | ||
| (getdate()) | | (getdate()) | ||
| − | | | + | | Date and time the record was last updated.<br /> |
| − | |||
|} | |} | ||
| Line 285: | Line 262: | ||
| 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]] | ||
| + | |||
| + | |} | ||
| + | |||
| + | |||
| + | {| 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]] | ||
| + | |||
| + | |} | ||
| + | |||
| + | |||
| + | |||
== automatically generated == | == automatically generated == | ||
Revision as of 22:54, 28 December 2009
wikibot
| 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 | dbo.Name | not null | Name of the product. AK_Product_Name | |
| ProductNumber | nvarchar(25) | not null | Unique product identification number. AK_Product_ProductNumber | |
| MakeFlag | dbo.Flag | not null | ((1)) | 0 = Product is purchased, 1 = Product is manufactured in-house. |
| FinishedGoodsFlag | dbo.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 |
| Dependency Type | Object Type | Referenced Object |
| Data Type | Type | dbo.Flag |
| Data Type | Type | dbo.Name |
| Reference Type | Object Type | Referencing Object |
| Select | View | Production.vProductAndDescription |
| Select | Procedure | dbo.uspGetBillOfMaterials |
| Select | Procedure | dbo.uspGetWhereUsedProductID |
| Select | Function | dbo.ufnGetProductDealerPrice |
| Select | Function | dbo.ufnGetProductListPrice |
| Select | Function | dbo.ufnGetProductStandardCost |
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 |
| Dependency Type | Object Type | Referenced Object |
| Data Type | Type | dbo.Flag |
| Data Type | Type | dbo.Name |
| Schema | Schema | Production |
| Reference Type | Object Type | Referencing Object |
| Select | View | Production.vProductAndDescription |
| Select | Procedure | dbo.uspGetBillOfMaterials |
| Select | Procedure | dbo.uspGetWhereUsedProductID |
| Select | Function | dbo.ufnGetProductDealerPrice |
| Select | Function | dbo.ufnGetProductListPrice |
| Select | Function | dbo.ufnGetProductStandardCost |
