Production.BillOfMaterials (table)

wikibot

Table

Production.BillOfMaterials

Column	Data Type	Nullable	Default	PK	Index
BillOfMaterialsID	int	not null		PK_BillOfMaterials_BillOfMaterialsID
ProductAssemblyID	int	null			AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
ComponentID	int	not null			AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
StartDate	datetime	not null	(getdate())		AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
EndDate	datetime	null
UnitMeasureCode	nchar(0)	not null			IX_BillOfMaterials_UnitMeasureCode
BOMLevel	smallint	not null
PerAssemblyQty	decimal(8, 2)	not null	((1.00))
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Production.Product	ComponentID	ProductID
Production.Product	ProductAssemblyID	ProductID
Production.UnitMeasure	UnitMeasureCode	UnitMeasureCode