Adding Search Fields to Finders (Grid-Flattening)
Grid flattening enables administrators to present "pseudo fields" for search, result, and other manager pages that are configured to the needs of their users. Pseudo fields "flatten" a grid by presenting field labels that are more specific than the default fields. For example, a PO Number field could be added to the order base search page, so users can search for purchase orders directly by their numbers. Grid flattening is used to make it appear as if data from a child database table is on a parent database table. Using grid flattening on search and result pages should be done with caution since the resulting query is more complex and therefore susceptible to slower performance.