Difference between revisions of "Production.Product (table)"
Line 557: | Line 557: | ||
| '''Object Type | | '''Object Type | ||
| '''Dependency Type | | '''Dependency Type | ||
− | + | ||
|- | |- | ||
| [[dbo.Flag_(type)|dbo.Flag]] | | [[dbo.Flag_(type)|dbo.Flag]] | ||
Line 566: | Line 566: | ||
| Type | | Type | ||
| Data Type | | Data Type | ||
+ | |- | ||
+ | | [[.Production_(schema)|.Production]] | ||
+ | | Schema | ||
+ | | Schema | ||
|} | |} | ||
Line 574: | Line 578: | ||
| '''Object Type | | '''Object Type | ||
| '''Reference Type | | '''Reference Type | ||
− | + | ||
|- | |- | ||
| [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]] | | [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]] |
Revision as of 07:24, 30 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 |
.Production | Schema | Schema |
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 |