Issue #23448 Fix invoice performance.
Explode group by columns to avoid distinct
Change sochild view to use type registration pattern.
Drop table instead so not null constraints do not conflict.
remove SalesOrderLine from test spec.
Merge pull request #1460 from bendiy/shiphead_performance

Fix Invoice and SalesOrder performance.