Before building your SQL statement, review the Unifier database table structure.
You can find the Unifier database table name in two ways:
- Using Entity Reference (ER) Views
- 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.
- Open Business Processes View.
- 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).
- Using BP IDs
- 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.
- Locate the BPs that you want to use in the report and find the IDs (first column).
- 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