Difference between revisions of "Production.Product (table)"
| Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| − | |- | + | |- valign="top" |
| '''Table | | '''Table | ||
| Production.Product | | Production.Product | ||
| Line 8: | Line 8: | ||
| '''Description | | '''Description | ||
| Products sold or used in the manfacturing of sold products. | | Products sold or used in the manfacturing of sold products. | ||
| − | |||
|} | |} | ||
| − | |||
=== Columns === | === Columns === | ||
| Line 20: | Line 18: | ||
| '''Default | | '''Default | ||
| '''Description | | '''Description | ||
| − | + | ||
|- valign="top" | |- valign="top" | ||
| ProductID | | ProductID | ||
| Line 178: | Line 176: | ||
| '''Primary Key | | '''Primary Key | ||
| '''Columns | | '''Columns | ||
| − | |- | + | |- valign="top" |
| PK_Product_ProductID | | PK_Product_ProductID | ||
| ProductID | | ProductID | ||
| Line 189: | Line 187: | ||
| '''Type | | '''Type | ||
| '''Columns | | '''Columns | ||
| − | + | ||
| − | |- | + | |- valign="top" |
| AK_Product_ProductNumber | | AK_Product_ProductNumber | ||
| Unique | | Unique | ||
| ProductNumber | | ProductNumber | ||
| − | |- | + | |- valign="top" |
| AK_Product_Name | | AK_Product_Name | ||
| Unique | | Unique | ||
| Name | | Name | ||
| − | |- | + | |- valign="top" |
| AK_Product_rowguid | | AK_Product_rowguid | ||
| Unique | | Unique | ||
| Line 210: | Line 208: | ||
| '''Expression | | '''Expression | ||
| '''Description | | '''Description | ||
| − | + | ||
| − | |- | + | |- valign="top" |
| CK_Product_Class | | CK_Product_Class | ||
| (upper([Class])='H' OR upper([Class])='M' OR upper([Class])='L' OR [Class] IS NULL) | | (upper([Class])='H' OR upper([Class])='M' OR upper([Class])='L' OR [Class] IS NULL) | ||
| Check constraint [Class]='h' OR [Class]='m' OR [Class]='l' OR [Class]='H' OR [Class]='M' OR [Class]='L' OR [Class] IS NULL | | Check constraint [Class]='h' OR [Class]='m' OR [Class]='l' OR [Class]='H' OR [Class]='M' OR [Class]='L' OR [Class] IS NULL | ||
| − | |- | + | |- valign="top" |
| CK_Product_DaysToManufacture | | CK_Product_DaysToManufacture | ||
| ([DaysToManufacture]>=(0)) | | ([DaysToManufacture]>=(0)) | ||
| Check constraint [DaysToManufacture] >= (0) | | Check constraint [DaysToManufacture] >= (0) | ||
| − | |- | + | |- valign="top" |
| CK_Product_ListPrice | | CK_Product_ListPrice | ||
| ([ListPrice]>=(0.00)) | | ([ListPrice]>=(0.00)) | ||
| Check constraint [ListPrice] >= (0.00) | | Check constraint [ListPrice] >= (0.00) | ||
| − | |- | + | |- valign="top" |
| CK_Product_ProductLine | | CK_Product_ProductLine | ||
| (upper([ProductLine])='R' OR upper([ProductLine])='M' OR upper([ProductLine])='T' OR upper([ProductLine])='S' OR [ProductLine] IS NULL) | | (upper([ProductLine])='R' OR upper([ProductLine])='M' OR upper([ProductLine])='T' OR upper([ProductLine])='S' OR [ProductLine] IS NULL) | ||
| Check constraint [ProductLine]='r' OR [ProductLine]='m' OR [ProductLine]='t' OR [ProductLine]='s' OR [ProductLine]='R' OR [ProductLine]='M' OR [ProductLine]='T' OR [ProductLine]='S' OR [ProductLine] IS NULL | | Check constraint [ProductLine]='r' OR [ProductLine]='m' OR [ProductLine]='t' OR [ProductLine]='s' OR [ProductLine]='R' OR [ProductLine]='M' OR [ProductLine]='T' OR [ProductLine]='S' OR [ProductLine] IS NULL | ||
| − | |- | + | |- valign="top" |
| CK_Product_ReorderPoint | | CK_Product_ReorderPoint | ||
| ([ReorderPoint]>(0)) | | ([ReorderPoint]>(0)) | ||
| Check constraint [ReorderPoint] > (0) | | Check constraint [ReorderPoint] > (0) | ||
| − | |- | + | |- valign="top" |
| CK_Product_SafetyStockLevel | | CK_Product_SafetyStockLevel | ||
| ([SafetyStockLevel]>(0)) | | ([SafetyStockLevel]>(0)) | ||
| Check constraint [SafetyStockLevel] > (0) | | Check constraint [SafetyStockLevel] > (0) | ||
| − | |- | + | |- valign="top" |
| CK_Product_SellEndDate | | CK_Product_SellEndDate | ||
| ([SellEndDate]>=[SellStartDate] OR [SellEndDate] IS NULL) | | ([SellEndDate]>=[SellStartDate] OR [SellEndDate] IS NULL) | ||
| Check constraint [SellEndDate] >= [SellStartDate] OR [SellEndDate] IS NULL | | Check constraint [SellEndDate] >= [SellStartDate] OR [SellEndDate] IS NULL | ||
| − | |- | + | |- valign="top" |
| CK_Product_StandardCost | | CK_Product_StandardCost | ||
| ([StandardCost]>=(0.00)) | | ([StandardCost]>=(0.00)) | ||
| Check constraint [SafetyStockLevel] > (0) | | Check constraint [SafetyStockLevel] > (0) | ||
| − | |- | + | |- valign="top" |
| CK_Product_Style | | CK_Product_Style | ||
| (upper([Style])='U' OR upper([Style])='M' OR upper([Style])='W' OR [Style] IS NULL) | | (upper([Style])='U' OR upper([Style])='M' OR upper([Style])='W' OR [Style] IS NULL) | ||
| Check constraint [Style]='u' OR [Style]='m' OR [Style]='w' OR [Style]='U' OR [Style]='M' OR [Style]='W' OR [Style] IS NULL | | Check constraint [Style]='u' OR [Style]='m' OR [Style]='w' OR [Style]='U' OR [Style]='M' OR [Style]='W' OR [Style] IS NULL | ||
| − | |- | + | |- valign="top" |
| CK_Product_Weight | | CK_Product_Weight | ||
| ([Weight]>(0.00)) | | ([Weight]>(0.00)) | ||
| Line 259: | Line 257: | ||
| '''Column | | '''Column | ||
| '''Referenced Column | | '''Referenced Column | ||
| − | + | ||
| − | |- | + | |- valign="top" |
| [[Production.ProductModel_(table)|Production.ProductModel]] | | [[Production.ProductModel_(table)|Production.ProductModel]] | ||
| ProductModelID | | ProductModelID | ||
| ProductModelID | | ProductModelID | ||
| − | |- | + | |- valign="top" |
| [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]] | | [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]] | ||
| ProductSubcategoryID | | ProductSubcategoryID | ||
| ProductSubcategoryID | | ProductSubcategoryID | ||
| − | |- | + | |- valign="top" |
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]] | | [[Production.UnitMeasure_(table)|Production.UnitMeasure]] | ||
| SizeUnitMeasureCode | | SizeUnitMeasureCode | ||
| UnitMeasureCode | | UnitMeasureCode | ||
| − | |- | + | |- valign="top" |
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]] | | [[Production.UnitMeasure_(table)|Production.UnitMeasure]] | ||
| WeightUnitMeasureCode | | WeightUnitMeasureCode | ||
| Line 284: | Line 282: | ||
| '''Column | | '''Column | ||
| '''Referencing Column | | '''Referencing Column | ||
| − | + | ||
| − | |- | + | |- valign="top" |
| [[Production.BillOfMaterials_(table)|Production.BillOfMaterials]] | | [[Production.BillOfMaterials_(table)|Production.BillOfMaterials]] | ||
| ProductID | | ProductID | ||
| ComponentID | | ComponentID | ||
| − | |- | + | |- valign="top" |
| [[Production.BillOfMaterials_(table)|Production.BillOfMaterials]] | | [[Production.BillOfMaterials_(table)|Production.BillOfMaterials]] | ||
| ProductID | | ProductID | ||
| ProductAssemblyID | | ProductAssemblyID | ||
| − | |- | + | |- valign="top" |
| [[Production.ProductCostHistory_(table)|Production.ProductCostHistory]] | | [[Production.ProductCostHistory_(table)|Production.ProductCostHistory]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
| − | |- | + | |- valign="top" |
| [[Production.ProductDocument_(table)|Production.ProductDocument]] | | [[Production.ProductDocument_(table)|Production.ProductDocument]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
| − | |- | + | |- valign="top" |
| [[Production.ProductInventory_(table)|Production.ProductInventory]] | | [[Production.ProductInventory_(table)|Production.ProductInventory]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
| − | |- | + | |- valign="top" |
| [[Production.ProductListPriceHistory_(table)|Production.ProductListPriceHistory]] | | [[Production.ProductListPriceHistory_(table)|Production.ProductListPriceHistory]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
| − | |- | + | |- valign="top" |
| [[Production.ProductProductPhoto_(table)|Production.ProductProductPhoto]] | | [[Production.ProductProductPhoto_(table)|Production.ProductProductPhoto]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
| − | |- | + | |- valign="top" |
| [[Production.ProductReview_(table)|Production.ProductReview]] | | [[Production.ProductReview_(table)|Production.ProductReview]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
| − | |- | + | |- valign="top" |
| [[Purchasing.ProductVendor_(table)|Purchasing.ProductVendor]] | | [[Purchasing.ProductVendor_(table)|Purchasing.ProductVendor]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
| − | |- | + | |- valign="top" |
| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]] | | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
| − | |- | + | |- valign="top" |
| [[Sales.ShoppingCartItem_(table)|Sales.ShoppingCartItem]] | | [[Sales.ShoppingCartItem_(table)|Sales.ShoppingCartItem]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
| − | |- | + | |- valign="top" |
| [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]] | | [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
| − | |- | + | |- valign="top" |
| [[Production.TransactionHistory_(table)|Production.TransactionHistory]] | | [[Production.TransactionHistory_(table)|Production.TransactionHistory]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
| − | |- | + | |- valign="top" |
| [[Production.WorkOrder_(table)|Production.WorkOrder]] | | [[Production.WorkOrder_(table)|Production.WorkOrder]] | ||
| ProductID | | ProductID | ||
| Line 350: | Line 348: | ||
| '''Referenced Object | | '''Referenced Object | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Type | | Type | ||
| [[dbo.Flag_(type)|dbo.Flag]] | | [[dbo.Flag_(type)|dbo.Flag]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Type | | Type | ||
| [[dbo.Name_(type)|dbo.Name]] | | [[dbo.Name_(type)|dbo.Name]] | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| Schema | | Schema | ||
| Line 374: | Line 372: | ||
| '''Referencing Object | | '''Referencing Object | ||
| − | |- | + | |- valign="top" |
| Select | | Select | ||
| View | | View | ||
| [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]] | | [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]] | ||
| − | |- | + | |- valign="top" |
| Select | | Select | ||
| Procedure | | Procedure | ||
| [[dbo.uspGetBillOfMaterials_(procedure)|dbo.uspGetBillOfMaterials]] | | [[dbo.uspGetBillOfMaterials_(procedure)|dbo.uspGetBillOfMaterials]] | ||
| − | |- | + | |- valign="top" |
| Select | | Select | ||
| Procedure | | Procedure | ||
| [[dbo.uspGetWhereUsedProductID_(procedure)|dbo.uspGetWhereUsedProductID]] | | [[dbo.uspGetWhereUsedProductID_(procedure)|dbo.uspGetWhereUsedProductID]] | ||
| − | |- | + | |- valign="top" |
| Select | | Select | ||
| Function | | Function | ||
| [[dbo.ufnGetProductDealerPrice_(function)|dbo.ufnGetProductDealerPrice]] | | [[dbo.ufnGetProductDealerPrice_(function)|dbo.ufnGetProductDealerPrice]] | ||
| − | |- | + | |- valign="top" |
| Select | | Select | ||
| Function | | Function | ||
| [[dbo.ufnGetProductListPrice_(function)|dbo.ufnGetProductListPrice]] | | [[dbo.ufnGetProductListPrice_(function)|dbo.ufnGetProductListPrice]] | ||
| − | |- | + | |- valign="top" |
| Select | | Select | ||
| Function | | Function | ||
Revision as of 00:16, 24 June 2010
Contents
wikibot
| Table | Production.Product |
| Description | Products sold or used in the manfacturing of sold products. |
Columns
| Column | Data Type | Nullable | Default | Description |
| ProductID | int | not null | Primary key for Product records. | |
| Name | dbo.Name | not null | Name of the product. | |
| ProductNumber | nvarchar(25) | not null | Unique product identification number. | |
| 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. |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |
Primary Key
| Primary Key | Columns |
| PK_Product_ProductID | ProductID |
Indexes
| Index | Type | Columns |
| AK_Product_ProductNumber | Unique | ProductNumber |
| AK_Product_Name | Unique | Name |
| AK_Product_rowguid | Unique | rowguid |
Check Constraints
| Check Constraint | Expression | Description |
| CK_Product_Class | (upper([Class])='H' OR upper([Class])='M' OR upper([Class])='L' OR [Class] IS NULL) | Check constraint [Class]='h' OR [Class]='m' OR [Class]='l' OR [Class]='H' OR [Class]='M' OR [Class]='L' OR [Class] IS NULL |
| CK_Product_DaysToManufacture | ([DaysToManufacture]>=(0)) | Check constraint [DaysToManufacture] >= (0) |
| CK_Product_ListPrice | ([ListPrice]>=(0.00)) | Check constraint [ListPrice] >= (0.00) |
| CK_Product_ProductLine | (upper([ProductLine])='R' OR upper([ProductLine])='M' OR upper([ProductLine])='T' OR upper([ProductLine])='S' OR [ProductLine] IS NULL) | Check constraint [ProductLine]='r' OR [ProductLine]='m' OR [ProductLine]='t' OR [ProductLine]='s' OR [ProductLine]='R' OR [ProductLine]='M' OR [ProductLine]='T' OR [ProductLine]='S' OR [ProductLine] IS NULL |
| CK_Product_ReorderPoint | ([ReorderPoint]>(0)) | Check constraint [ReorderPoint] > (0) |
| CK_Product_SafetyStockLevel | ([SafetyStockLevel]>(0)) | Check constraint [SafetyStockLevel] > (0) |
| CK_Product_SellEndDate | ([SellEndDate]>=[SellStartDate] OR [SellEndDate] IS NULL) | Check constraint [SellEndDate] >= [SellStartDate] OR [SellEndDate] IS NULL |
| CK_Product_StandardCost | ([StandardCost]>=(0.00)) | Check constraint [SafetyStockLevel] > (0) |
| CK_Product_Style | (upper([Style])='U' OR upper([Style])='M' OR upper([Style])='W' OR [Style] IS NULL) | Check constraint [Style]='u' OR [Style]='m' OR [Style]='w' OR [Style]='U' OR [Style]='M' OR [Style]='W' OR [Style] IS NULL |
| CK_Product_Weight | ([Weight]>(0.00)) | Check constraint [Weight] > (0.00) |
Foreign Keys
| Relation | Column | Referenced Column |
| Production.ProductModel | ProductModelID | ProductModelID |
| Production.ProductSubcategory | ProductSubcategoryID | ProductSubcategoryID |
| Production.UnitMeasure | SizeUnitMeasureCode | UnitMeasureCode |
| Production.UnitMeasure | WeightUnitMeasureCode | UnitMeasureCode |
Detail Tables
| 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 |
References
| Dependency Type | Object Type | Referenced Object |
| Data Type | Type | dbo.Flag |
| Data Type | Type | dbo.Name |
| Schema | Schema | Production |
Dependencies
| 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 |
