Path: <sheet><cardareas>

Contains the settings for the areas on the Eliminations of Equity Investments template. Card areas can only be defined for templates which are of type 'card'.

Note! The depreciations functionality of the eliminations of equity investments template only works when there are 12 normal periods in the system.

Path: <cardareas><documentseries>

Defines the document series number for the areas.

Path: <cardareas><sheetcolumns>

Defines the settings for mapping columns in the XLSX workbook.

Path: <cardareas><sheetcolumns><sheetcolumn>

Defines the mapping settings for one column.

Attributes

id: Defines the XLSX workbook column ID. This ID is mapped to the <cardcolumn> definitions.

Possible values:

•rowIdColumn for the A column in the Excel file.

•Free text value for other columns.

col: Defines the column number in the xls workbook.

dynamic: Defines whether users can add columns using the Add Column function. Can be used only for the last column of the template.

Possible values:

•true

•false

Path: <cardareas><cardarea>

Contains the settings of one area on the template.

Path: <cardarea><settings>

Defines the settings for the card area.

Attributes

id: Defines the ID for the card area.

Path: <cardarea><settings><name>

Defines the card area name.

Possible values:

•The name must be the same as the area defined in the workbook.

Path: <cardarea><settings><type>

Defines the area type.

Possible values:

•acquisitioncomment

•acquisition

•acquisitiontransaction

•acquisitioncosts

•acquiredequity

•allocations

•depreciation

Path: <cardarea><data>

Defines the settings for data in the area.

Path: <cardarea><data><cardrow>

Defines the settings for one row in the template.

Attributes

id: ID for the data row.

Note! The ID must match the 'rowIdColumn' of the workbook (see <sheetcolumn>).

Possible values:

•AcquisitionComment

•AcquisitionUnit

•AcquisitionParent

•AcquisitionAllocation

•TransactionPeriod

•TransactionYear

•TransactionPortion

•TransactionEndPeriod

•TransactionEndYear

•TranslationDifferencesOpeningAccount

•TranslationDifferencesChangeAccount

•AcquisitionCosts

•AcquiredEquity

•Allocations

•Depreciation

•DepreciationDeftax

•DepreciationSeries

dynamic: Defines whether a new row is added to the template automatically when data is entered to the last row. The value true can be used in areas of the type acquisitioncosts, acquiredequity and allocations.

Possible values:

•true

•false

Path: <cardarea><data><cardrow><cardcolumn>

Defines the settings for one column in the template.

Attributes

id: Defines the ID of the XLS workbook column to which this column is mapped (see <sheetcolumn>).

type: Defines the column type.

Possible values:

•Comment

•Unit

•TaxPercent

•TransactionRate

•TransactionPeriod

•TransactionYear

•TransactionPortion

•TransactionEndPeriod

•TransactionEndYear

•OpeningAccount

•ChangeAccount

•TransactionYearAccount

•OtherYearsAccount

•DeferredTaxTransactionYearAccount

•DeferredTaxOtherYearsAccount

•Position

•CounterUnit

•Allocation

•IsDeftax

•AmountToDepreciate

•AllocatedAmount

•YearsToDepreciate

•CalculationMethod

•CurrentYearProfitAndLossAccount

•CurrentYearBalanceSheetAccount

•OpeningRetainedEarningsAccount

•OpeningBalanceSheetAccount

•Cost

•DepreciationSeries

Path: <cardarea><data><cardrow><cardcolumn><dimensioninfo>

Defines the content of the column.

Attributes

dimensiontype: The type of content in the column.

Possible values:

•account

•dim00

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.

•currency: The ID of the currency of the selected dimension type (available only for dimension type dim00) is shown in the column. Value is retrieved from the currently selected year.