Export (0) Print
Expand All
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.