Review Database Table Structure

Before building your SQL statement, review the database table structure.

You can find the database table name in two ways:

  1. Using Entity Reference (ER) Views
    1. Sign in as a Company Administrator.
    2. Go to the Company Workspace tab and switch to Admin mode.
    3. In the left Navigator, click Data Structure Setup > ER Views.
    4. Open Business Processes View.
    5. Use your browser search function and search for a BP you want to report against (for example, Invoices).

      The name of the table appears under the BP Name, in blue (for example, UNIFIER_UI. The word "unifier" is the prefix and common to all BP tables. The UI is the ID of the Invoices BP).

  2. Using BP IDs
    1. Sign in as a Company Administrator.
    2. Go to the Company Workspace tab and switch to Admin mode.
    3. In the left Navigator, click uDesigner > Business Processes.
    4. Locate the BPs that you want to use in the report and find the IDs (first column).
    5. Add your deployment prefix and add an underscore ( _ ) to get the table name (for example, UNIFIER_UI).

      Note: To access the Line Items of a BP, add _LINEITEM to the table name (for example, UNIFIER_UI_LINEITEM).

The following lists the column names:


Last Published Thursday, December 14, 2023