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, go to the Company Workspace tab, and ensure that you are in Administration mode > Data Structure Setup > ER Views.
    2. Open Business Processes View.
    3. 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, go to the Company Workspace tab, and ensure that you are in Administration mode > uDesigner > Business Processes.
    2. Locate the BPs that you want to use in the report and find the IDs (first column).
    3. 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 Monday, August 28, 2023