Map

Value Mapping (Legacy to Target) H

Value Mapping (Legacy to Target) V

To access this page:

  1. Click Advanced Data Migration in the Navigation pane.
  2. Click Map in the Context bar.
  3. Click the Value Mapping icon on the Process Area Launch page.
  4. Click the Values icon for a check table.

    NOTE: Use Excel Integration to download a spreadsheet that users can update with value mapping values. Excel Integration and Bulk Execution are enabled on the Value Mapping (Legacy to Target) page. Once data entry is complete, import that data into the Stewardship Tier. Refer to Use Bulk Execution and Use Excel Integration for more information.

Field

Description

CHECK TABLE

Click to open the Value Mapping (Config) page to view details about the check table.

Check tables are also called lookup tables and are added in Target Design or imported with a System Type when it is imported into t

Target Design.

SOURCE ID

Displays the name of the data source as defined in Target Design.

LEGACY VALUE

Displays the value in the Source that needs to be mapped to a Target value in value mapping.

LEGACY DESCRIPTION

Displays a description of the value from the Source.

TARGET VALUE

Displays the Target value that will replace the Source value during value mapping.

PROPOSED VALUE

Displays a proposed Target value to use for the Source value. This field is used to capture information only and is used while value mapping is being designed.

NOT RELEVANT

If enabled, the legacy value is not relevant for the Target ERP system.

COMMENT

Displays user-entered comments about the value mapping.

SOURCE VALUE SOURCE TABLE

Displays the table that contains the field that stores the value used in the check table.

SOURCE VALUE SOURCE TABLE FIELD

Displays the field that stores the value used in the check table.

Value Mapping (Legacy to Target) V

Value Mapping (Legacy to Target) H

Field

Description

Legacy Value

Displays the value in the Source that needs to be mapped.

Comment

Displays user-entered comments about the value mapping.

Source Details

Legacy Description

Displays a description of the value from the Source.

Legacy Value1

Displays the value of the first key column. This is only for Multi-Part Key Columns.

Legacy Value2

Displays the value of the second key column. This is only for Multi-Part Key Columns.

Legacy Value3

Displays the value of the third key column. This is only for Multi-Part Key Columns.

Legacy Value4

Displays the value of the fourth key column. This is only for Multi-Part Key Columns.

Legacy Value5

Displays the value of the fifth key column. This is only for Multi-Part Key Columns.

Target Details

Target Value

Displays the Target value that will replace the Source value.

Proposed Value

Displays a proposed Target value to use for the Source value. This field is used to capture information only and is used while value mapping is being designed.