Editing Production.Product (table)
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
− | |- | + | |- |
| '''Table | | '''Table | ||
| Production.Product | | Production.Product | ||
− | |- | + | |- |
− | |||
− | |||
|} | |} | ||
− | + | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- style="background:silver" | |- style="background:silver" | ||
Line 17: | Line 15: | ||
| '''Nullable | | '''Nullable | ||
| '''Default | | '''Default | ||
− | | ''' | + | | '''PK |
− | + | | '''Index | |
− | |- | + | |
+ | |- | ||
| ProductID | | ProductID | ||
| int | | int | ||
| not null | | not null | ||
| | | | ||
− | | | + | | PK_Product_ProductID |
− | |- | + | | |
+ | |- | ||
| Name | | Name | ||
| dbo.Name | | dbo.Name | ||
| not null | | not null | ||
| | | | ||
− | | | + | | |
− | |- | + | | AK_Product_Name |
+ | |- | ||
| ProductNumber | | ProductNumber | ||
| nvarchar(25) | | nvarchar(25) | ||
| not null | | not null | ||
| | | | ||
− | | | + | | |
− | |- | + | | AK_Product_ProductNumber |
+ | |- | ||
| MakeFlag | | MakeFlag | ||
| dbo.Flag | | dbo.Flag | ||
| not null | | not null | ||
| ((1)) | | ((1)) | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| FinishedGoodsFlag | | FinishedGoodsFlag | ||
| dbo.Flag | | dbo.Flag | ||
| not null | | not null | ||
| ((1)) | | ((1)) | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| Color | | Color | ||
| nvarchar(15) | | nvarchar(15) | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| SafetyStockLevel | | SafetyStockLevel | ||
| smallint | | smallint | ||
| not null | | not null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| ReorderPoint | | ReorderPoint | ||
| smallint | | smallint | ||
| not null | | not null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| StandardCost | | StandardCost | ||
| money | | money | ||
| not null | | not null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| ListPrice | | ListPrice | ||
| money | | money | ||
| not null | | not null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| Size | | Size | ||
| nvarchar(5) | | nvarchar(5) | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| SizeUnitMeasureCode | | SizeUnitMeasureCode | ||
| nchar(3) | | nchar(3) | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| WeightUnitMeasureCode | | WeightUnitMeasureCode | ||
| nchar(3) | | nchar(3) | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| Weight | | Weight | ||
| decimal(8, 2) | | decimal(8, 2) | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| DaysToManufacture | | DaysToManufacture | ||
| int | | int | ||
| not null | | not null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| ProductLine | | ProductLine | ||
| nchar(2) | | nchar(2) | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| Class | | Class | ||
| nchar(2) | | nchar(2) | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| Style | | Style | ||
| nchar(2) | | nchar(2) | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| ProductSubcategoryID | | ProductSubcategoryID | ||
| int | | int | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| ProductModelID | | ProductModelID | ||
| int | | int | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| SellStartDate | | SellStartDate | ||
| datetime | | datetime | ||
| not null | | not null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| SellEndDate | | SellEndDate | ||
| datetime | | datetime | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| DiscontinuedDate | | DiscontinuedDate | ||
| datetime | | datetime | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| rowguid | | rowguid | ||
| uniqueidentifier | | uniqueidentifier | ||
| not null | | not null | ||
| (newid()) | | (newid()) | ||
− | | | + | | |
− | |- | + | | AK_Product_rowguid |
+ | |- | ||
| ModifiedDate | | ModifiedDate | ||
| datetime | | datetime | ||
| not null | | not null | ||
| (getdate()) | | (getdate()) | ||
− | | | + | | |
− | | | + | | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|} | |} | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- style="background:silver" | |- style="background:silver" | ||
Line 257: | Line 202: | ||
| '''Column | | '''Column | ||
| '''Referenced Column | | '''Referenced Column | ||
− | + | ||
− | |- | + | |- |
| [[Production.ProductModel_(table)|Production.ProductModel]] | | [[Production.ProductModel_(table)|Production.ProductModel]] | ||
| ProductModelID | | ProductModelID | ||
| ProductModelID | | ProductModelID | ||
− | |- | + | |- |
| [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]] | | [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]] | ||
| ProductSubcategoryID | | ProductSubcategoryID | ||
| ProductSubcategoryID | | ProductSubcategoryID | ||
− | |- | + | |- |
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]] | | [[Production.UnitMeasure_(table)|Production.UnitMeasure]] | ||
| SizeUnitMeasureCode | | SizeUnitMeasureCode | ||
| UnitMeasureCode | | UnitMeasureCode | ||
− | |- | + | |- |
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]] | | [[Production.UnitMeasure_(table)|Production.UnitMeasure]] | ||
| WeightUnitMeasureCode | | WeightUnitMeasureCode | ||
Line 276: | Line 221: | ||
|} | |} | ||
− | + | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- style="background:silver" | |- style="background:silver" | ||
Line 282: | Line 227: | ||
| '''Column | | '''Column | ||
| '''Referencing Column | | '''Referencing Column | ||
− | + | ||
− | |- | + | |- |
| [[Production.BillOfMaterials_(table)|Production.BillOfMaterials]] | | [[Production.BillOfMaterials_(table)|Production.BillOfMaterials]] | ||
| ProductID | | ProductID | ||
| ComponentID | | ComponentID | ||
− | |- | + | |- |
| [[Production.BillOfMaterials_(table)|Production.BillOfMaterials]] | | [[Production.BillOfMaterials_(table)|Production.BillOfMaterials]] | ||
| ProductID | | ProductID | ||
| ProductAssemblyID | | ProductAssemblyID | ||
− | |- | + | |- |
| [[Production.ProductCostHistory_(table)|Production.ProductCostHistory]] | | [[Production.ProductCostHistory_(table)|Production.ProductCostHistory]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
− | |- | + | |- |
| [[Production.ProductDocument_(table)|Production.ProductDocument]] | | [[Production.ProductDocument_(table)|Production.ProductDocument]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
− | |- | + | |- |
| [[Production.ProductInventory_(table)|Production.ProductInventory]] | | [[Production.ProductInventory_(table)|Production.ProductInventory]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
− | |- | + | |- |
| [[Production.ProductListPriceHistory_(table)|Production.ProductListPriceHistory]] | | [[Production.ProductListPriceHistory_(table)|Production.ProductListPriceHistory]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
− | |- | + | |- |
| [[Production.ProductProductPhoto_(table)|Production.ProductProductPhoto]] | | [[Production.ProductProductPhoto_(table)|Production.ProductProductPhoto]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
− | |- | + | |- |
| [[Production.ProductReview_(table)|Production.ProductReview]] | | [[Production.ProductReview_(table)|Production.ProductReview]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
− | |- | + | |- |
| [[Purchasing.ProductVendor_(table)|Purchasing.ProductVendor]] | | [[Purchasing.ProductVendor_(table)|Purchasing.ProductVendor]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
− | |- | + | |- |
| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]] | | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
− | |- | + | |- |
| [[Sales.ShoppingCartItem_(table)|Sales.ShoppingCartItem]] | | [[Sales.ShoppingCartItem_(table)|Sales.ShoppingCartItem]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
− | |- | + | |- |
| [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]] | | [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
− | |- | + | |- |
| [[Production.TransactionHistory_(table)|Production.TransactionHistory]] | | [[Production.TransactionHistory_(table)|Production.TransactionHistory]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
− | |- | + | |- |
| [[Production.WorkOrder_(table)|Production.WorkOrder]] | | [[Production.WorkOrder_(table)|Production.WorkOrder]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
|} | |} | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
== automatically generated == | == automatically generated == | ||
Line 412: | Line 292: | ||
| Production.Product | | Production.Product | ||
|- valign="top" | |- valign="top" | ||
+ | |||
| '''Description | | '''Description | ||
| Products sold or used in the manfacturing of sold products. | | Products sold or used in the manfacturing of sold products. | ||
|- | |- | ||
+ | |||
|} | |} | ||
Line 672: | Line 554: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- style="background:silver" | |- style="background:silver" | ||
+ | | '''Referenced Object | ||
+ | | '''Object Type | ||
| '''Dependency Type | | '''Dependency Type | ||
− | + | ||
− | |||
− | |||
|- | |- | ||
+ | | [[dbo.Flag_(type)|dbo.Flag]] | ||
+ | | Type | ||
| Data Type | | Data Type | ||
+ | |- | ||
+ | | [[dbo.Name_(type)|dbo.Name]] | ||
| Type | | Type | ||
− | |||
− | |||
− | |||
| Data Type | | Data Type | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|} | |} | ||
Line 696: | Line 571: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- style="background:silver" | |- style="background:silver" | ||
+ | | '''Referencing Object | ||
+ | | '''Object Type | ||
| '''Reference Type | | '''Reference Type | ||
− | + | ||
− | |||
− | |||
|- | |- | ||
+ | | [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]] | ||
+ | | View | ||
| Select | | Select | ||
− | |||
− | |||
− | |||
|- | |- | ||
+ | | [[dbo.uspGetBillOfMaterials_(procedure)|dbo.uspGetBillOfMaterials]] | ||
+ | | Procedure | ||
| Select | | Select | ||
+ | |- | ||
+ | | [[dbo.uspGetWhereUsedProductID_(procedure)|dbo.uspGetWhereUsedProductID]] | ||
| Procedure | | Procedure | ||
− | | | + | | Select |
− | |||
|- | |- | ||
+ | | [[dbo.ufnGetProductDealerPrice_(function)|dbo.ufnGetProductDealerPrice]] | ||
+ | | Function | ||
| Select | | Select | ||
− | |||
− | |||
− | |||
|- | |- | ||
+ | | [[dbo.ufnGetProductListPrice_(function)|dbo.ufnGetProductListPrice]] | ||
+ | | Function | ||
| Select | | Select | ||
− | |||
− | |||
− | |||
|- | |- | ||
− | | | + | | [[dbo.ufnGetProductStandardCost_(function)|dbo.ufnGetProductStandardCost]] |
| Function | | Function | ||
− | |||
− | |||
− | |||
| Select | | Select | ||
− | |||
− | |||
− | |||
|} | |} |