BillOfMaterials Table (AdventureWorks)
Contains a list of all the components used to manufacture bicycles and bicycle subassemblies. ProductAssemblyID represents the parent (or primary) product and ComponentID represents child (or individual) parts that are used to build the parent assembly. For example, a wheel assembly contains components such as reflectors, rims, spokes, tires, and tire tubes.
BillOfMaterials Table Definition
The BillOfMaterials table is contained in the Production schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
BillOfMaterialsID |
int |
Not null |
Primary key for BillOfMaterials rows. |
ProductAssemblyID |
int |
Null |
Parent product identification number. Foreign key to Product.ProductID. |
ComponentID |
int |
Not null |
Component identification number. Foreign key to Product.ProductID. |
StartDate |
datetime |
Not null |
Date the component started being used in the assembly item. |
EndDate |
datetime |
Null |
Date the component stopped being used in the assembly item. |
UnitMeasureCode |
nchar(3) |
Not null |
Standard code identifying the unit of measure for the quantity. |
BOMLevel |
smallint |
Not null |
Indicates the depth the component is from its parent (ProductAssemblyID). |
PerAssemblyQty |
decimal(8,2) |
Not null |
Quantity of the component needed to create the assembly. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
See Also
Reference
Product Table (AdventureWorks)
UnitMeasure Table (AdventureWorks)
Concepts
Other Resources
AdventureWorks Data Dictionary