| Column | Data Type | Nullable | Default | Description / PK / Index |
| BillOfMaterialsID | int | not null | | Primary key for BillOfMaterials records.
PK_BillOfMaterials_BillOfMaterialsID |
| ProductAssemblyID | int | null | | Parent product identification number. Foreign key to Product.ProductID.
AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate |
| ComponentID | int | not null | | Component identification number. Foreign key to Product.ProductID.
AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate |
| StartDate | datetime | not null | (getdate()) | Date the component started being used in the assembly item.
AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate |
| 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.
IX_BillOfMaterials_UnitMeasureCode |
| BOMLevel | smallint | not null | | Indicates the depth the component is from its parent (AssemblyID).
|
| PerAssemblyQty | decimal(8, 2) | not null | ((1.00)) | Quantity of the component needed to create the assembly.
|
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|