Create an asset sheet column

You are here: Primavera Unifier Administration Mode > Asset Manager Setup > Setting up and Managing Asset Sheets > Create an asset sheet column

Create an asset sheet column

Columns can be added to asset sheets. These columns can be used to capture data from the asset form, business processes, or manually entered data on the sheet. Users with create permission on asset class sheets are allowed to create and define columns.

To create a new asset sheet column

In the asset sheet, click the Columnsbutton in the menu bar. The Asset Sheet Columns Log opens.

In the menu bar click New. The Column Properties window opens. Complete the window as described in the following table.

In this field:

Do this:

Name

The Name field is populated with the data source value selected.

Datasource

Select a data source. The drop-down menu lists the data elements found on the asset class form. This list also shows data elements based on SYS Numeric Logical Datasource, Sys Date Logical Datasource, Sys Business Process Datasource, and Sys Project Cost Datasource data definitions. Data sources of type SYS Numeric Logical Datasource, SYS Date Logical Datasource, Sys Business Process Datasource, and Sys Project Cost Datasource can only be used once.

Examples include:

Business processes: Company-level BPs with line items with asset code subtype are available. Only the Amount field is available.

Project cost sheet: Columns defined with Sys Project Cost.

Entry Method

Choose one of the following data-entry methods to use for the column. The available choices vary depending on the data source selected. Options include:

Manual entry: User enters data directly into the cell, or data is rolled up from another source, such as the asset form.

Formula: Options are Numeric, Date Difference, and Date Add.

Data Type: This option is applicable if the data source is SYS Business Process, a business process or information from the project cost sheet. After selecting the data type, click Define to choose the data element or define a formula based on the data element.

Date Format

Specify how you want the column data to appear. This is applicable to numeric columns. Options are:

•

Show as Percentage: Data entered in a column will display in percentage format. For example, if a user enters 0.25, it will display as 25%.

•

Decimal Places: Select the number of decimal places to display.

•

Use 1000 Separator (,): Data entered is formatted with a separator; for example, 1,000, not 1000.

•

Negative Number Format: Select how negative values will be displayed on the sheet: with a negative sign or in parentheses.

Display Mode

Select Hide to make the column invisible to users, or Show to display it.

Total

This controls what displays in the bottom summary row for each column:

•

Blank: Summary row will remain blank.

•

Sum of All Rows: Displays the sum total of all row values for this column.

•

User Formula Definition: Formula entered in the Formula field will apply to the summary row.

Column Position After

Select a column from the list. This determines the position of the column on the sheet.

To copy a column

In the Column log, select a column and click Copy. The Column Properties window opens.

Make changes as necessary for the new column. You must change at least the data source.

Oracle Corporation