Select Distinct

When a business view includes the primary key fields of the primary table, every row of the business view query is unique. If for some reason the business view does not contain all primary key fields of the primary table, then duplicate rows can occur during the business view query.

For example, JD Edwards EnterpriseOne Journal Entry is unique by line number and document number. However, each document can contain multiple lines. If you need to display only one record per document, you can use Select Distinct to fetch only the first occurrence of the document number, not all of the detail lines within the document.

Business views that include a primary table that contains any of the following columns, which are used for currency support and security, might cause the Select Distinct feature to display duplicate values:

Column	Description
CO	Company
CRCD	Currency Code - From
CRDC	Currency Code - To
CRCX	Currency Code - Denominated In
CRCA	Currency Code - A/B Amounts
LT	Ledger Type
AID	Account ID
MCU	Business Unit
KCOO	Order Company (Company Code)
EMCU	Business Unit Header
MMCU	Branch
AN8	Address Number