The Database Dictionary provides a centralized reference for Finance database tables. Users can select a table to view its purpose, notes, columns, indexes, and relationships to other tables, as well as examine related tables and view sample SQL for supported relationships.
1. In the Setup menu, click Database Dictionary.
2. Option 1: Select the applicable table from the Tables pull-down to view information about the table, including its purpose, notes, columns, indexes, and relationships to other tables.
2. Option 2: Select the applicable Purpose from the pull-down to locate and select the corresponding table based on the purpose as opposed to the table. The Tables pull-down populates based on the Purpose selected.
3. The screen defaults to the Purpose tab where you can view the purpose of the selected table, such as general ledger account numbers for the gl_accounts table.
4. Click the Notes tab to view notes pertaining to the selected table.
5. Click the Columns tab to view the column names, data types, attributes, comments, and available options for the selected table.
6. Click the Indexes tab to view columns, include, filter, and times used since rest on [date/time] for the selected table.
7. Click the Joins tab to review the Joined Table, Joined Table Keys, Purpose, Number of times joined, as well as to examine and show a sample.
a. Click Examine to reload the page and report to view details pertaining to the selected joined table.
b. Click Show Sample to view a sample SQL query.
i. In the pop-up window, review the Sample SQL Query. When finished, click the white X to close the pop-up window.
