Generated using SQL Data Dictionary demo version.
Stored procedure using a recursive query to return a multi-level bill of material for the specified ProductID.
| Parameter | Data Type | Default | Is Output |
|---|---|---|---|
| @StartProductID | int | ||
| Input parameter for the stored procedure uspGetBillOfMaterials. Enter a valid ProductID from the Production.Product table. | |||
| @CheckDate | datetime | ||
| Input parameter for the stored procedure uspGetBillOfMaterials used to eliminate components not used after that date. Enter a valid date. | |||
| Column | Data Type | Nullable |
|---|---|---|
| ProductAssemblyID | int | X |
| ComponentID | int | X |
| ComponentDesc | nvarchar(50) | X |
| TotalQuantity | decimal(38,2) | X |
| StandardCost | money | X |
| ListPrice | money | X |
| BOMLevel | smallint | X |
| RecursionLevel | int | X |