Path: <datacolumn><settings>

Contains the settings of the data column.

Path: <datacolumn><settings><save>

Defines whether the data column values are saved.

Possible values:

•yes: Data is saved to the database.

•no: Data is not saved in the database.

•saveonly: Not in use.

Path: <datacolumn><settings><scaling>

Defines the factor by which the figures retrieved to the input screen are divided, and when saving, multiplied. The figures retrieved to the reporting screen are divided.

Path: <datacolumn><settings><currency>

Defines the currency in which the data is shown. Only used for numeric data fields (not for 'extra' or 'formula' fields; see <datafield>). In input, the <currency> element can be used only when the amount type is group (<datafield><numeric amount="group">). In reporting, the <currency> element can be used with both values of the amount attribute (group and unit).

The <currency> element in reports is inherited to drill-down and TR templates. If the drill-down and TR templates include their own <currency> elements, these definitions are stronger.

Note! Converting with cumulative currency rates is not possible in Transparent Reporting when all invoices are shown. In this case an error message is shown to the user. When documents are shown by periods, converting with cumulative currency rates is possible.

Input and reporting is possible in a third currency (some other currency than unit or group currency) when the <currency> element is defined in the basic area or data column settings. The <currency> element defined in the data column settings is stronger than the one defined in the basic area setting. If the <currency> element is not defined in the data column settings, its value is inherited from the basic area settings. If the <currency> element is also missing also from the basic area settings, no currency conversions are performed.

Possible values:

•Identifier of the currency

•Variable %USERCURRENCY%: The identifier of the currency selected in the input or report template Advanced Options tab (group currency, unit currency, or a third currency).

Path: <datacolumn><settings><periodizing>

Defines the periodizing function for the input template.

Possible values:

•sum: Defines the column as the column in which the sum to be periodized is entered.

•pattern: Defines the column as the column in which the periodizing pattern is selected.

•periodizable: Defines the column as one where the sum to be periodized is distributed according to the selected periodizing pattern.

In a periodizing template, one data column must have the periodizing type sum and one must have the periodizing type pattern. At least one data column must have the periodizing type periodizable, but usually there are more than one columns to which periodizing is applied.

It is recommended that you define the sum and pattern columns as extra columns (for <datafield type=”extra”> and <extra> parameter settings, see <datafield> and <extra>).

Example:

Periodizing sum column:

<settings><save>yes</save><periodizing type="sum"/></settings><datafield type="extra" datasource="input"><extra field="E01"/></datafield>

Periodizing pattern column:

<settings><save>yes</save><periodizing type="pattern"/></settings><datafield datasource="input" type="extra"><extra field="E02"/></datafield>

Data column to which periodizing is applied:

<settings><save>yes</save><scaling>1</scaling><periodizing type="periodizable"/></ settings><datafield datasource="input" type="numeric"><numeric amount="unit" period="periodical"/></datafield>

Path: <datacolumn><generalcolumnsettings>

Not in use.

Path: <datacolumn><selector>

Defines the settings for generating a selection list with values for extra fields.

Attributes

type: The type of the extra field.

Possible values:

•none: Used to define a customized list for a numeric extra field. The options are defined with <udid> elements (see below).

•dim[nn]

•account

•documentseries

•document

•datafield: Options defined for the drop-down list of the extra field in Data Type Management > Extra Fields are used in the selection list.

•finyr

•finper

•datatype

generatetype: Defines how the unit list is generated for the dimension.

Possible values:

•branch: The hierarchy tree is generated from all input units or accounts under the level defined with the <udid> element (including the defined level).

•all: The list containing all units, accounts, documentseries, documents, financial years, financial periods, or data types is generated.

•input: The list is generated from the input units or accounts defined with the <udid> element.

•selected: The list is generated from specific units, accounts, document series, documents, financial years, financial periods or data types defined with the <udid> element.

•none: Used when type=none or type=datafield (see attribute 'type' above).

hierarchy: Defines the hierarchy to be used. Used only when type=dim[nn

Possible values:

•%DIMnn HIERARCHY%: The hierarchy selected in Basic Options.

•The ID of a specific hierarchy, for example, STRUCTURE1.

sourcedatatype: Used when generating dim[nn] or accounts.

Possible values:

•%DATA TYPE CODE%/%USERDATATYPE%: The units or accounts are generated based on the connections of the selected data type.

•Empty value or missing attribute:

oUnits: All units from the organization chart are included to the list based on the value of the 'sourceyear' attribute. Note that 'not in use' units are not included and that the connections of the units to data types are not checked.

oAccounts: All accounts from the account chart are included to the list. Note that the connections of the accounts to data types are not checked.

•The ID of a specific data type.

sourceyear: Used when generating dim[nn].

Possible values:

•%YEAR CODE%/%USERFINYEAR%: The units are generated based on the connections of the selected/defined data type in the selected year. Also %YEAR CODE-n% (selected year – n) and %YEAR CODE+n% (selected year + n) can be used.

•Empty value or missing attribute: All units in use are shown in the list regardless of the selected year.

•The ID of a specific financial year.

Path: <datacolumn><selector><udid>

Defines the dimension unit, account, document series, document, financial year, financial period or data type used in the settings for generating a selection list for an extra field. <udid> is not needed when generatetype="all" or type="datafield