Since we lost our item type BOM there have been so many situations where we have trouble in workflow conditions and other situations where I need to sort on "MAKE" versus 'BUY" items.

Because the default order type is hiding in a supporting table of the item table, I can't use a condition on it in a workflow. Workflow conditions allows no joins.  In reqular queries I have to use  a Join.

This is such a handicap that I would consider a change in the design. Get that default order type back into the inventtable. It would make a big difference. There is no good reason to hide it in the default order parameters table. It is not that I need an item to be purchased in site 1 and manufactured in site 2. I I really need that I have my item coverage to do that.