I need to write an application (sevice) that reads released BOMs from Windchill and synchronizes them with a Sage 100 ERP database. I need the End Item and a list of all of the parts by level with the latest revision levels. I can see the End Item and Parts in the WTPartMaster and WTPart tables but am having difficulty identifying the relationships between the tables that would allow me to navigate the BOM structure. Does anyone have a select statement(s) with the appropriate links to generate a BOM struture using SQL?
