Question for my fellow PDM Admins...

Background:

I am testing Named BOMs originating from Computed BOMs and originating from Item Structures. I've determined that they are stored in different folder structures in PDM (File Folder structure vs. Item Folder structure).

Question:

Does anyone know which SQL tables contain both Named BOMs indicated above? I'm database literate, but I'm a beginner with SQL and just starting my investigation for extracting this information. Any tips or information are greatly appreciated.

Reason for asking:

Named BOMs will likely be used to populate information in our ERP system and I'll eventually need to produce automated extracts for this purpose.

Many thanks,

Craig Merrifield

aka - Merf