Financial Data Tables in Requests

A request can have financial data table when its request type has configured a financial data table field. The request types can be, but are not limited to request types for lifecycle entities (the PFM - Proposal, PFM - Project, and PFM - Asset request types).

This section provides a brief introduction to financial data tables and summarizes what you can do with financial data tables.

Overview of financial data tables

Financial data tables are provided to allow your business to consolidate and track financial information that is related to a request and that, in the case of lifecycle entities, should not be part of the financial summary.

For example, you can use financial data tables to do the following:

  • Track indirect costs and/or benefits

  • Create multiple forecasts for a new request

  • Track a breakdown of costs by factors that are not available in a financial summary

Back to top

Enable financial data table field

Admin task

PPM request types are not provided with fields for financial data tables by default.

To make the financial data table field available in a request, administrators should add a custom field in the request type, set its Validation to CST - Financial Data Table, and set its Search Validation to CST - Search Financial Data on the Attributes tab. The custom field can have any appropriate name such as Alternative Data or Indirect Costs.

For details, see the Demand Management Configuration Guide.

Back to top

What you can do with financial data tables

The types of data in a request's financial data table are a subset of the types of data in a financial summary for a lifecycle entity.

The following table lists what you can do with financial data tables.

Action Details
Create a financial data table for a request See Creating a Financial Data Table.
Toggle currency display in a financial data table

Use the Display Currency in toggle to select one of the following currencies:

  • Currency derived from the region that was selected when the financial data table was created (the default option)
  • System default currency
View financial totals

View financial totals over all periods in the Summary section.

For description of the totals, see Viewing Financial Totals from Financial Summary.

Add and edit costs

Similar to how you add and edit costs in a financial summary.

For details, see Adding and Editing Costs.

Add and edit benefits

Similar to how you add and edit benefits in a financial summary.

For details, see Viewing, Adding, and Editing Benefits.

Export a financial data table to Excel

Similar to how you export a financial summary to Excel.

For details, see Exporting to Microsoft Excel.

Configure access for a financial data table

Similar to how you configure access for a financial summary.

Exceptions: The View Approved Budget, Edit Approved Budget, and Set Plan of Record access rights are not applicable to financial data tables.

For details, see Configure Access for Financial Summary.

Back to top

Financial data table for one or more projects created from a proposal

When a proposal becomes a project, by default any financial data tables in the proposal are copied to the project. Both forecasts and actuals are copied. The project's financial data table is editable and the proposal's financial data table becomes non-editable.

Note: Copying the financial data table requires that the administrator configure the proposal request type and the project request type to have matching tokens for the financial data table fields.

Based on your business needs, for example to implement an approved proposal as separate projects across various business units, a workflow can be configured to create multiple projects from a single proposal at different workflow steps. In this case, the financial summaries and financial data tables for the projects are as follows:

  • For the first project that is created, the financial data table is copied in its entirety from the proposal wherever tokens match as described previously.
  • For projects created after the first project, the same financial data table fields as in the proposal are present in the projects, but no financial data tables are copied from the proposal to those project fields.

Back to top

Financial data table for an asset created from a project

When an asset is created from a project, the financial data table of the project is copied to the asset. Both forecasts and actuals are copied. The asset's financial data table is editable and the project's financial data table becomes non-editable.

Note: Copying the financial data table requires that the administrator configure the project request type and the asset request type to have matching tokens for the financial data table fields.

Back to top