Cardarea Settings Sub-Elements
Elements, attributes and possible values
<cardareas>
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'.
The depreciations functionality of the eliminations of equity investments template only works when there are 12 normal periods in the system.
<documentseries>
Path: <cardareas><documentseries>
Defines the document series number for the areas.
<sheetcolumns>
Path: <cardareas><sheetcolumns>
Defines the settings for mapping columns in the XLSX workbook.
<sheetcolumn>
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 xlsx 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
<settings>
Path: <cardarea><settings>
Defines the settings for the card area.
Attributes
id: Defines the ID for the card area.
<name>
Path: <cardarea><settings><name>
Defines the card area name.
Possible values:
The name must be the same as the area defined in the workbook.
<type>
Path: <cardarea><settings><type>
Defines the area type.
Possible values:
acquisitioncomment
acquisition
acquisitiontransaction
acquisitioncosts
acquiredequity
allocations
depreciation
<data>
Path: <cardarea><data>
Defines the settings for data in the area.
<cardrow>
Path: <cardarea><data><cardrow>
Defines the settings for one row in the template.
Attributes
id: ID for the data row.
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
<cardcolumn>
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
<dimensioninfo>
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.