Skip to main content

Data entry details

Zuora

Data entry details

The columns that are contained in each BI view and their sources are listed in a downloadable spreadsheet. Click BI_Views_37.008.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:

File to download Change history
BI_Views_37.007.00.00.xlsx

New columns are added to the following BI views:

  • RPRO_BI3_APPR_DTL_V
  • RPRO_BI3_RC_HEAD_V
  • RPRO_BI3_RC_LNS_V
  • RPRO_BI3_MJE_V

Data type is changed for some columns in the following BI views:

  • RPRO_BI3_APPR_DTL_V
  • RPRO_BI3_BOOK_V
  • RPRO_BI3_CALENDAR_V
  • RPRO_BI3_RC_LN_COST_V
  • RPRO_BI3_RC_HOLD_V
  • RPRO_BI3_MJE_V
  • RPRO_BI3_ORG_V
  • RPRO_BI3_PERIODS
  • RPRO_BI3_RC_POB_V
  • RPRO_BI3_RC_SCHD_V
BI_Views_37.006.00.00.xlsx

New columns are added to the following BI views:

  • RPRO_BI3_RC_BILL_V
  • RPRO_BI3_RC_HEAD_V
  • RPRO_BI3_RC_LNS_V
BI_Views_37.005.00.00.xlsx

New columns are added to the following BI views:

  • RPRO_BI3_RC_LN_COST_V
  • RPRO_BI3_RC_LNS_V

Data type is changed for some columns in the following BI views:

  • RPRO_BI3_LN_ACCT_SUMM_V
  • RPRO_BI3_RC_BILL_V
  • RPRO_BI3_BOOK_V
  • RPRO_BI3_RC_LN_COST_V
  • RPRO_BI3_RC_HEAD_V
  • RPRO_BI3_RC_HOLD_V
  • RPRO_BI3_RC_LNS_V
  • RPRO_BI3_MJE_V
  • RPRO_BI3_RC_POB_V
  • RPRO_BI3_RC_SCHD_V
  • RPRO_BI3_WF_SUMM_V

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