Share via


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

Manufacturing Scenario

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance