Difference between revisions of "Production.Product (table)"
Line 285: | Line 285: | ||
| ProductID | | ProductID | ||
|} | |} | ||
− | |||
== automatically generated == | == automatically generated == | ||
Line 307: | Line 306: | ||
| '''Nullable | | '''Nullable | ||
| '''Default | | '''Default | ||
− | | '''Description | + | | '''Description / 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 |
− | + | |- valign="top" | |
− | |- | ||
| Name | | Name | ||
| Name | | Name | ||
| not null | | not null | ||
| | | | ||
− | | Name of the product. | + | | Name of the product.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 |
− | + | |- 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 |
− | + | |- 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 00:57, 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 |