Review Unifier Database Table Structure

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

You can find the Unifier database table name in two ways:

1. Using Entity Reference (ER) Views
   1. Sign in to Unifier as a Company Administrator and go to the Company Workspace tab, 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).
   4. 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 to Unifier as a Company Administrator and go to the Company Workspace tab, 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:

• Field Name
• Definition
• SQL Type
• Label
• Description

Legal Notices | Your Privacy Rights
Copyright © 1998, 2020

Last Published Friday, April 9, 2021