X-ERP Help

System mapping

The system mapping uniquely assigns a foreign format column to an X-ERP system column.

System mapping

The system mapping uniquely assigns a foreign format column to an X-ERP system column.

Why this point is crucial for key users

A mapping is an interpreter with no room for interpretation. The clearer it is set up, the less manual rework and silent data movement occurs.

Fields and settings at a glance

  • Format name: The import or export format to which the mapping applies.
  • File column number: Position or identifier of the column in the source file.
  • System column: Target meaning in X-ERP to which the source column is assigned.
  • Data type: Set the correct type.
  • Transformation rule: Transfers values correctly into X-ERP.

How to prepare for the process safely

  1. Take a shared sample file for reference.
  2. Map each required file column to the correct system column.
  3. Test special characters, empty values, dates, numbers and signs.
  4. Compare the import result field by field and using checksums.

Check before sharing

  • No mandatory column is missing or assigned twice.
  • Data type and technical meaning match.
  • A changed file version is not processed unnoticed with old mapping.

What your team gets out of it

External data is not only read in, but is also understood in X-ERP in a controlled manner.

Related topics

  1. For key users – understand and prepare processes › Finance › Preparation for transfer
  2. For key users – understand and prepare processes › Finance › Corporate bank

Frequently asked questions

Why is system mapping important for key users?

A mapping is an interpreter with no room for interpretation. The clearer it is set up, the less manual rework and silent data movement occurs.

What needs to be checked before release?

No mandatory column is missing or assigned twice. Data type and technical meaning match. A changed file version is not processed unnoticed with old mapping.