Managing cost column structure

Select the “Manage Cost Column Structure” activity under the “Cost Setup” business component.

The “Manage Cost Column Structure” page appears.

Enter the following fields in the “Cost Column Structure Info” group box:

Column Structure ID

Use the drop-down list box to specify the basis on which you wish to create / modify or view a column structure. Mandatory. The system lists the following options:

New - Select this option if you wish to create a New Column Structure ID.
Pre-defined - Select this option if you wish to create / for a predefined structure the modification is not allowed or view a Column Structure ID that has already been defined.
User Defined – Select this option if you wish to create, modify or view a user defined Column Structure ID.

In the drop-down list box alongside, select a value corresponding to the value specified in the Column Structure ID. Data selection in this field is mandatory if “Pre-defined” or “User Defined” is selected as the Column Structure ID. The system lists the options as follows:

Value selected in the Column Structure ID drop-down list box 1:	The system lists the following values in the adjacent drop-down list box:
New	Blank
Pre-defined	All the pre-defined Cost Column Structure IDs
User Defined	All the existing user defined Cost Column Structure IDs for the login OU company

Column Structure ID

A unique code identifying the Column Structure ID. Data entry in this field is mandatory if “New” is specified in the “Column Structure ID” drop-down list box

Ensure the following:

The value entered in this field is without any space or special character except ' - ' (hyphen).
The value entered in this field is a Column Structure ID that is unique for the login OU if “New” is specified as the “Column Structure ID” drop-down list box 1.
he value entered in this field is not modified if “Predefined” or “User Defined” as the “Column Structure ID” drop-down list box 1.

Help facility available

Descriptions

A textual description of Cost Column Structure. Mandatory.

No. of Columns

Use the drop-down list box to select the number of columns in the column structure. The system lists the following options 1, 2, 3, 4, 5, and 6.

Ensure that the number entered in this field is equal to the number of rows in the multiline for which data is entered.

The system displays “2” by default in this field.

The system displays the following fields in the multiline:

Note: Ensure that details of records in the multiline are for not more than 6 rows.

Column ID

The number identifying the column in which the value for the report is displayed.

The system displays the system currently displays ‘blank’” by default in this field.

Enter the following fields in the multiline:

Column Name	The name of the column that will be displayed in the report. Data entry in this column is Mandatory if values are entered for other columns in that row. Ensure that the value entered in this field is a unique column name for the given Column Structure ID.
Source Info	Use the drop-down list box to specify the source from where the values for the report are to be derived. Data selection in this field is mandatory if values are entered for other columns in that row. The system lists the following options: Budget – Select this option if the source of the values for the report is to be from the cost budget Actuals – Select this option if the values for the report is to be the actual. User Defined Formula - Select this option if the source for the values for the report is to be derived from the formulae as defined in “Manage Formula” activity. By default the system leaves this field blank.
Data Based on	Use the drop-down list box to specify the basis of the data for the report. Data selection is mandatory in this field if values are entered for other columns in that row. The system lists the following options: YTD - Year-to-Date, indicates values from the beginning of the year until the report date. Period – Indicates values from the beginning of the period until the report date. Formula - Column Level – Indicates the formula defined for two columns in this column structure in the “Manage Formula” activity. Formula - Column-Element level – Indicates formula defined for a column and an element in the “Manage CE Structure” activity. Note that the formula for this column is to be defined for the Report ID which has this column structure. Ensure the following: Either 'Formula - Column level' or 'Formula - Column-Element level' is selected in this field if “User Defined Formula” is specified as the “Source Info”. Either 'YTD' or 'Period' is selected in this field if “Budgets” or “Actuals” is selected as the “Source Info”. By default the system leaves this field blank.
Qty/Value	Use the drop-down list box to specify the whether the data for the report has to be derived based on quantity or values. Data entry in this field is mandatory if “Budget” or “Actuals” is selected as the “Source Info”. The system lists the following options: Quantity - Indicates data for the report is to be based on quantity. Value – Indicates data for the report is to be based on value. Leave this field blank if “User Defined Formula” is specified as the “Source Info”. By default the system displays “Value” in this field.

The system displays the following fields in the multiline”

Formula

Indicates whether formula is defined for the row, which could be “fx-defined” or “fx-Not defined”

Note that the system leaves this field blank if “Formula - Column-Element level” is specified as the “Data Based On”.

Formula Display

Formula defined in the Manage formula.

Note: Ensure that data is entered for at least one row in the multiline.

Click the “Save” pushbutton to save the details against the Column Structure ID.

The system displays the following fields in the “Record Statistics” group box:

Created by	The login user who created the Column Structure ID.
Created date	The date on which the Column Structure ID was created.
Modified by	The login user who modified the Column Structure ID.
Modified date	The date on which the Column Structure ID was modified.