Review Database Table Structure
Before building your SQL statement, review the database table structure.
You can find the database table name in two ways:
- Using Entity Reference (ER) Views
- Sign in as a Company Administrator.
- Go to the Company Workspace tab and switch to Admin mode.
- In the left Navigator, click 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 as a Company Administrator.
- Go to the Company Workspace tab and switch to Admin mode.
- In the left Navigator, click 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
Last Published Thursday, December 14, 2023