Value Mapping Legacy to Target H

Value Mapping (Legacy to Target) H

Use this page to

To access this page:

Click dspMigrate in the Navigation pane.
Click Map in the Context bar.
Click the Value Mapping icon on the Process Area Launch page.
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 DSP. 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.

Use this page to

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.