To write your first statement:
SELECT * FROM unifier_ui
Example
Name you Invoice table "inv" by adding "inv" after the table name. You can then refer to each column using the alias, instead of the full name. Your statement should look like the following:
Note: The Query Builder re-formats the layout of your SQL.
SELECT inv.PROJECT_ID,
inv.ID,
inv.RECORD_NO,
inv.TITLE,
inv.STATUS,
inv.UVEVENDORNAMETB50,
inv.AMOUNT
FROM unifier_ui inv
Example
SELECT inv.PROJECT_ID,
inv.ID AS inv_ID,
inv.RECORD_NO AS inv_record_no,
inv.TITLE AS inv_title,
inv.STATUS AS inv_status,
inv.UVEVENDORNAMETB50 AS vendor,
inv.AMOUNT AS inv_amount
FROM unifier_ui inv
Note: Unifier requires a field called "PROJECT_ID" since Unifier uses the filed for data filtering (for example, Only the Invoices from the project that you are running the report from are shown). Always leave a field called PROJECT_ID in your main Data View to prevent receiving an error message when creating the Custom Report.
Creating a Custom Report in Primavera Unifier
Download and Install BI Publisher Desktop for Microsoft Office
Review Unifier Database Table Structure
Creating a Report with Line Items
Advanced BI Publisher Functions
Search Parameters and Additional Parameters
Legal Notices
Copyright © 2016, 2018,
Oracle and/or its affiliates. All rights reserved.
Last Published Wednesday, March 28, 2018