Data entry details
The columns that are contained in each BI view and their sources are listed in a downloadable spreadsheet. The BI view data updated in the current version is highlighted in yellow. Click BI_Views_37.019.00.00.xlsx to download the spreadsheet for the latest version. For information about BI views in a previous version, see BI views in previous versions.
Each tab in the spreadsheet provides the details about one BI view. Starting from the second row on a tab, each row represents one column in the BI view with the following information provided:
- Entity: The physical table name based on which the BI view is created.
- Column: The column name in the BI view.
- Key: Indicates whether the current column is a primary key of the BI view. The primary key indicator indicates the minimum columns that are required to uniquely identify a record in the BI view.
- Data Type: The data type of the column.
- Source Table: The source table from which the column originates.
- Source Column: The name of the column in the source table from which this column origins.
- Function/Expression: Indicates the function or expression that is used to derive the current column.
- Description: A short description of the column.
Some columns exist in each BI view for audit purposes. These audit columns track the creation date, last update date, and the name of the user who updates the record. You can use the audit columns and the primary key columns to process the records for an incremental load strategy.
BI views in previous versions
Zuora Revenue BI views are updated on a quarterly basis. The spreadsheet file name indicates the version that provides the contained BI views. Compared with the last quarterly update, the BI view data updated in the current version is highlighted in yellow. Click the following file to download the BI view information in a previous quarterly update:
- RPRO_BI3_RC_BILL_V
- RPRO_BI3_RC_LNS_V
- RPRO_BI3_MJE_V
- RPRO_BI3_RC_POB_V
| File to download | Change history |
|---|---|
| BI_Views_37.008.00.00.xlsx |
New columns are added to the following BI view: |
| BI_Views_37.007.00.00.xlsx |
New columns are added to the following BI views:
Data type is changed for some columns in the following BI views:
|
| BI_Views_37.006.00.00.xlsx |
New columns are added to the following BI views:
|
| BI_Views_37.005.00.00.xlsx |
New columns are added to the following BI views:
Data type is changed for some columns in the following BI views:
The column called ZBILL_TRUE_UP_FLAG is deprecated in RPRO_BI3_RC_BILL_V. |
| BI Views 37.004.00.00.xlsx | N/A |
| BI Views 37.003.00.00.xlsx | N/A |
| BI Views 37.002.00.00.xlsx | N/A |
| BI Views 37.001.00.00.xlsx | N/A |
| BI Views 36.009.00.xlsx | N/A |
| BI Views 36.008.00.xlsx | N/A |
| BI Views 36.006.00.xlsx | N/A |
| BI Views 36.010.00.xlsx | N/A |