1. a. Product engineering table
BOM_table_master
ID name EMger
001 cars
002 002 engine parts
003 003 chassis parts
003.1 003.1 sensor components
003.2.1 connector accessories 003.2.1
BOM query recursive query if an order has several products should be
how to query
BOM_Detail_part
ID name parent_BOM
001 002 engine parts
001 003 chassis parts
004 engine cover 001
002.01 cylinder block of 002
002.02 piston ring of 002
002.03 piston driving arm of 002
002.04 inlet pipe of 002
003.1 sensor parts of 003
003.2.1 connector accessories, 003
003.2.2 solid 003 pieces
003.1.1 ABS induction line of 003.1
Allen 003.2.1 003.2.1.1 fasteners
asked
11 Sep '13, 12:51
mfkpie8
238●64●69●72
accept rate:
12%
Does that sample from the docs help - it seems rather similar:
Parts explosion problem