Difference between revisions of "Production.Product (table)"
Line 313: | Line 313: | ||
| not null | | not null | ||
| | | | ||
− | | Primary key for Product records.PK_Product_ProductID | + | | Primary key for Product records.<br />PK_Product_ProductID |
|- valign="top" | |- valign="top" | ||
| Name | | Name | ||
Line 319: | Line 319: | ||
| not null | | not null | ||
| | | | ||
− | | Name of the product.AK_Product_Name | + | | Name of the product.<br />AK_Product_Name |
|- valign="top" | |- valign="top" | ||
| ProductNumber | | ProductNumber | ||
Line 325: | Line 325: | ||
| not null | | not null | ||
| | | | ||
− | | Unique product identification number.AK_Product_ProductNumber | + | | Unique product identification number.<br />AK_Product_ProductNumber |
|- valign="top" | |- valign="top" | ||
| MakeFlag | | MakeFlag | ||
Line 331: | Line 331: | ||
| not null | | not null | ||
| (1) | | (1) | ||
− | | 0 = Product is purchased, 1 = Product is manufactured in-house. | + | | 0 = Product is purchased, 1 = Product is manufactured in-house.<br /> |
|- valign="top" | |- valign="top" | ||
| FinishedGoodsFlag | | FinishedGoodsFlag | ||
Line 337: | Line 337: | ||
| not null | | not null | ||
| (1) | | (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" | |- valign="top" | ||
| Color | | Color | ||
Line 343: | Line 343: | ||
| null | | null | ||
| | | | ||
− | | Product color. | + | | Product color.<br /> |
|- valign="top" | |- valign="top" | ||
| SafetyStockLevel | | SafetyStockLevel | ||
Line 349: | Line 349: | ||
| not null | | not null | ||
| | | | ||
− | | Minimum inventory quantity. | + | | Minimum inventory quantity. <br /> |
|- valign="top" | |- valign="top" | ||
| ReorderPoint | | ReorderPoint | ||
Line 355: | Line 355: | ||
| not null | | 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" | |- valign="top" | ||
| StandardCost | | StandardCost | ||
Line 361: | Line 361: | ||
| not null | | not null | ||
| | | | ||
− | | Standard cost of the product. | + | | Standard cost of the product.<br /> |
|- valign="top" | |- valign="top" | ||
| ListPrice | | ListPrice | ||
Line 367: | Line 367: | ||
| not null | | not null | ||
| | | | ||
− | | Selling price. | + | | Selling price.<br /> |
|- valign="top" | |- valign="top" | ||
| Size | | Size | ||
Line 373: | Line 373: | ||
| null | | null | ||
| | | | ||
− | | Product size. | + | | Product size.<br /> |
|- valign="top" | |- valign="top" | ||
| SizeUnitMeasureCode | | SizeUnitMeasureCode | ||
Line 379: | Line 379: | ||
| null | | null | ||
| | | | ||
− | | Unit of measure for Size column. | + | | Unit of measure for Size column.<br /> |
|- valign="top" | |- valign="top" | ||
| WeightUnitMeasureCode | | WeightUnitMeasureCode | ||
Line 385: | Line 385: | ||
| null | | null | ||
| | | | ||
− | | Unit of measure for Weight column. | + | | Unit of measure for Weight column.<br /> |
|- valign="top" | |- valign="top" | ||
| Weight | | Weight | ||
Line 391: | Line 391: | ||
| null | | null | ||
| | | | ||
− | | Product weight. | + | | Product weight.<br /> |
|- valign="top" | |- valign="top" | ||
| DaysToManufacture | | DaysToManufacture | ||
Line 397: | Line 397: | ||
| not null | | not null | ||
| | | | ||
− | | Number of days required to manufacture the product. | + | | Number of days required to manufacture the product.<br /> |
|- valign="top" | |- valign="top" | ||
| ProductLine | | ProductLine | ||
Line 403: | Line 403: | ||
| null | | null | ||
| | | | ||
− | | R = Road, M = Mountain, T = Touring, S = Standard | + | | R = Road, M = Mountain, T = Touring, S = Standard<br /> |
|- valign="top" | |- valign="top" | ||
| Class | | Class | ||
Line 409: | Line 409: | ||
| null | | null | ||
| | | | ||
− | | H = High, M = Medium, L = Low | + | | H = High, M = Medium, L = Low<br /> |
|- valign="top" | |- valign="top" | ||
| Style | | Style | ||
Line 415: | Line 415: | ||
| null | | null | ||
| | | | ||
− | | W = Womens, M = Mens, U = Universal | + | | W = Womens, M = Mens, U = Universal<br /> |
|- valign="top" | |- valign="top" | ||
| ProductSubcategoryID | | ProductSubcategoryID | ||
Line 421: | Line 421: | ||
| null | | 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" | |- valign="top" | ||
| ProductModelID | | ProductModelID | ||
Line 427: | Line 427: | ||
| null | | 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" | |- valign="top" | ||
| SellStartDate | | SellStartDate | ||
Line 433: | Line 433: | ||
| not null | | not null | ||
| | | | ||
− | | Date the product was available for sale. | + | | Date the product was available for sale.<br /> |
|- valign="top" | |- valign="top" | ||
| SellEndDate | | SellEndDate | ||
Line 439: | Line 439: | ||
| null | | null | ||
| | | | ||
− | | Date the product was no longer available for sale. | + | | Date the product was no longer available for sale.<br /> |
|- valign="top" | |- valign="top" | ||
| DiscontinuedDate | | DiscontinuedDate | ||
Line 445: | Line 445: | ||
| null | | null | ||
| | | | ||
− | | Date the product was discontinued. | + | | Date the product was discontinued.<br /> |
|- valign="top" | |- valign="top" | ||
| rowguid | | rowguid | ||
Line 451: | Line 451: | ||
| not null | | not null | ||
| (NEWID()) | | (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" | |- valign="top" | ||
| ModifiedDate | | ModifiedDate | ||
Line 457: | Line 457: | ||
| not null | | not null | ||
| (GETDATE()) | | (GETDATE()) | ||
− | | Date and time the record was last updated. | + | | Date and time the record was last updated.<br /> |
|} | |} | ||
Revision as of 01:10, 27 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 |