Path: <area><definitioncolumns>

Contains definition column settings.

Path: <definitioncolumns><definitioncolumn>

Contains the settings of one definition column.

The columns appear in the input or report template in the order in which the <definitioncolumn> elements occur in the definitions file.

Attributes

id: Definition column ID.

Path: <definitioncolumn><headers>

Contains the settings of the definition column headers.

Remember to add the required number of rows for all headers in the workbook.

Note! Definition column headers and data column headers are placed on the same row in the workbook, and the data columns headers are always placed above them.

Path: <definitioncolumn><headers><header>

Defines the header text of the definition column.

Attributes

language: Language identifier that defines the language of the header text. The column header is displayed on the input or report template according to the active language.

Note! If headers are defined in the XML definitions file, they override translations defined in the Excel file.

Possible values:

•Languages used in the system.

Example:

<header language="en">Account name</header><header language="fi">Tilin nimi</header>

Path: <definitioncolumn><generateheaders>

Contains the definitions of block headers in row generation.

Remember to add the required number of rows for all headers in the workbook.

Path: <definitioncolumn><generateheaders><header>

Defines the header text of one block header in row generation. Note that you can also use variables in the header (see Input and Report Template Variables).

Attributes

language: Language identifier that defines the language of the header text. The column header is displayed on the input or report template according to the active language.

Note! If headers are defined in the XML definitions file, they override translations defined in the Excel file.

Possible values:

•Languages used in the system.

Path: <definitioncolumn><dimensioninfo>

Defines the content of the definition column.

Attributes

dimensiontype: The type of content in the column.

Possible values:

•account

•dim00 ... dim09

•datatype

•coaccount

•finyr

•finper

•document

•documentseries

•position

•codim00

•oid

•inputtype

The attribute value 'inputtype' can be used in input templates and drill-down templates to show different input types ('manualentry', 'autocalculation', 'calculated', 'NCI' and 'reconciliation'; see <dimension> and <dimensionudid>) on separate rows. If this attribute value is not used in reports, different input types are summed together.

Example of definition column settings with dimensiontype='inputtype' in a drill-down sheet:

<definitioncolumn id="defcolx"><headers><header language="en">Input type</header><header language="fi">Syöttötapa</header></headers><dimensioninfo dimensiontype="inputtype" presentationproperty="udid"/>

Not in use: datatypever

presentationproperty

Defines what is displayed in the definition column

Possible values:

•udid: The ID of the selected dimension type is shown in the column.

•name: The name of the selected dimension type is shown in the column.

•unitpair: Defines that data is grouped by unit pairs. Unit pairs are used to match internal transactions. This option can only be used for dimension type 'dim00' in 'retrievefromdata' type report templates. Unit pairs are not stored in the database but created during data retrieval.

•accountgroup: Defines that data is grouped by account groups. Used for dimension type 'account'.

•currency: The currency for the selected unit and year.

•consolidationmethod: The consolidation method for the selected unit and year.

•taxpercent: The tax percent for the selected unit and period(month).

•consolidationpercent: The consolidation percent for the selected unit and period(month)

•datatypeusage: Shows, whether the account is of sum level or input level from the selected data type's point of view. Used for dimension type 'account'.

Note! A 'name' column cannot be used without a 'udid' column. If you only want a 'name' column to be shown in the template, you must define the 'udid' column and hide the column in the Excel sheet. The 'udid' column can be added before or after the 'name' column, or in some other place under <definitioncolumns>.

Path: <definitioncolumn><hierarchy>

Defines the dimension hierarchy for retrieving data.

Note! This element is only used in generation templates.

Possible values:

•Hierarchy ID: The hierarchy according to which the units are generated.

•%DIMnn HIERARCHY%: The units are generated according to the hierarchy selected by the user in the input or report template options view.

Path: <definitioncolumn><level>

Not in use.

Path: <definitioncolumn><account_statement>

Defines whether the definition column is used for the account statement function.

Possible values:

•true

•false (default)