One way would be to include the field in your BAQ. There are many threads that will have this code. Here is one of them.
Looking for SQL SP or Code to list full BOM for a part - ERP 9 - Epicor User Help Forum (epiusers.help)