Configuring Capital Planning Attributes

Attribute Columns

Attribute columns are used to input the information related to the account/line and these values can be used in the template calculations. Select the number of attribute columns needed on the Capital Input Template. You can define up to 10 per template.

Six attributes are provided by default. Users cannot add or edit these attributes once a Capital Template Finance Mode is defined.

1. Purchase Month

2. Depr. Start Month

3. Units

4. Rate

5. Amount

6. Asset Life

Header

Enter the name of the attribute column. This is the name that will appear on Capital Templates.

Align

Select cell alignment. For example, you might select to center the cell contents.

Width

Select the width of the column.

Format

Select a format for the column. For example, if you plan to enter percentage values in the attribute column, set the format of the column to Percent. Alternatively, by selecting Row Format, the format used for the template line will be applied, which allows attribute values with varying formats.

Decimal

Select the number of decimals you want to associate with the cell values. For example, if you select 2, the cell value will be: 00.00

Formula

Enter the formula you want to associate with the column.

Life

Select to identify a column to denote the asset's useful life (service life). This information will be used to calculate the depreciation associated with the asset.