Bill of Material : BOMTable - BOMVersion - BOM

BOMTable
The BOMTable table contains all the bills of materials.
A bill of material is connected to a site and an item group.
For each bill of material the information whether it has been approved and by whom is stored.

BOMVersion
The BOMVersion table contains all bill of materials versions.
It connects to the BOMTable table in order to specify to which bill of materials the version refers
and it connects to the InventTable table in order to specify to which item the BOM version is assigned.
The BOMVersion table also connects to the InventDim table in order to specify a site for the BOM version.
Additionally the BOMVersion table stores information regarding approval and activation for each BOM version.

BOM
The BOM table contains bill of materials lines.
A BOM line connects to an item which is to be consumed and a BOM version to which the line applies.

Table	Primary Key
BOMTable	BOMId
BOMVersion	BOMId, ItemId, RecId
BOM	BOMId, LineNum, RecId

BOMTable

|

|

^

BOMVersion

|

|

^

BOM

Sources:
BOMTable http://msdn.microsoft.com/en-us/library/aa672428.aspx
BOMVersion: http://msdn.microsoft.com/en-us/library/aa630970.aspx
BOM http://msdn.microsoft.com/en-US/library/aa844882.aspx