AnsweredAssumed Answered

PDM Professional - Named Bill of Material in SQL

Question asked by Craig Merrifield on Mar 9, 2017
Latest reply on Mar 17, 2017 by Tim Webb

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

Outcomes