Rows

There are three types of rows. From top to bottom:

  • The first row indicates the column type : uppercase "I" columns are input columns. "T" columns are temporary columns, "O" columns are output columns and "IO" columns are input/output columns (see Columns).

  • The second row starts with "Level", and then contains the names of the input and output columns.

  • The third row starts with "Alias", and then optionally contains aliases. An alias enables you to:

    • Replace technical column names with names that are more explicit.

    • Rename target columns from an intermediary mapping that are used as source columns, in the next mapping.

    • Rename columns that have the same names in both the ACDOCA source table and the ACDOCU target table.

  • The remaining rows in the file are the mapping rules. They always start with the level.

Example

The example below illustrates the use of an alias:

 

I

I

I

              

Level

I_FSItem

I_SubItem

I_Amount

FinancialStatementItem

SubitemCategory

Subitem

AmountInLocalC

AmountInLocalCurrency

ConsolidationUnit

CostCenter

ALIAS

                  

CC1

0

A1412

F55

  

"141200"

"1"

"955"

"EUR"

[I_Amount]

"CUDC18"

"17"

In this mapping, CostCenter has the alias "CC1" ; in the second mapping, ProfitCenter is mapped with the alias "CC1" and not CostCenter.

 

I

I

  

Level

I_FSItem

I_SubItem

ProfitCenter

ALIAS

      

O

A1412

F55

[CC1]