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, select Data Structure Setup, and then select 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, select uDesigner, and then select 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 Friday, April 11, 2025