--- title: "Comment by Milind Joshi on \"Data Migration/Extraction from Autodesk Vault\" | Hashnode" description: "Hello Andrew, A very useful article. I have a query for you. What all tables are used to store Bill Of Material in Inventor Vault? I am looking for BOM details" url: "https://hashnode.com/posts/data-migrationextraction-from-autodesk-vault/6242a0a5db84f8c50fa5ba53/comment/636258f91a6e287db7286b04" --- [Discussion](https://hashnode.com/posts/data-migrationextraction-from-autodesk-vault/6242a0a5db84f8c50fa5ba53) Comment [Data Migration/Extraction from Autodesk Vault](https://hashnode.com/posts/data-migrationextraction-from-autodesk-vault/6242a0a5db84f8c50fa5ba53) [Milind Joshi](https://hashnode.com/@milindsj) [Nov 2, 2022](https://hashnode.com/posts/data-migrationextraction-from-autodesk-vault/6242a0a5db84f8c50fa5ba53/comment/636258f91a6e287db7286b04) Hello Andrew, A very useful article. I have a query for you. What all tables are used to store Bill Of Material in Inventor Vault? I am looking for BOM details like child item id, quantity, find number etc. Could you please help? [Andrew B](https://hashnode.com/@abowden) [Nov 8, 2022](https://hashnode.com/posts/data-migrationextraction-from-autodesk-vault/6242a0a5db84f8c50fa5ba53/comment/636258f91a6e287db7286b04#reply-6369c946a1ce83db6fb7209a) Hi there, I found that the BOM data is stored in the FileIteration table in the BOMBlob field. It's encoded as XML so you'll need a way to expand and link that data. This is an example of the Components section of the XML from an assembly: This translates to: -BOM item #2 (CompId) -ChildID (FileIteration.FileIterationId from DB) of 868932 [Milind Joshi](https://hashnode.com/@milindsj) [Nov 23, 2022](https://hashnode.com/posts/data-migrationextraction-from-autodesk-vault/6242a0a5db84f8c50fa5ba53/comment/636258f91a6e287db7286b04#reply-637dbb61caae63ceadac03d8) Thanks a lot [Andrew B](https://hashnode.com/@abowden). This helps. I will give it a try now.