Define DB views with DISTINCT
Goal: Technical
Developer: Nicolas Micoud
Sponsor: TGI
Feature Ticket: IDEMPIERE-5434
Description:
A 'Distinct' checkbox has been added on the View Component tab.

If ticked, DISTINCT is automatically added right after the SELECT keyword in the query
Source: Wiki