Description

Displays the name of the Source as defined in Target Design.

Displays the Source table containing the field.

Displays the Source field containing the value.

Displays the status of the Source field, such as whether the field is active, if value mapping is complete or if the Source field is not used. The field is used to track when a Mapper incorrectly sets a field mapping with an action of Xref. This status will leave a place holder for other users to review the setting and either activate or inactivate this Source field or table.

Displays the table name that stores the description field of the Source field.  Usually, the value and description are stored in the same table.

Displays the field name that contains the description of the Source field.

For example, the field State contains a value of GA. The description of the State field would be Georgia, and is stored in the description field.

Click to open the Legacy Value (Source Table Fields) page to view all values for the Source table that must be value mapped or removed.

Click to open the Value Mapping (Legacy to Target) page to perform value mapping for the selected Source field.

Click to open the Source Value Tracking page to view each Source table that has a field that has been mapped to the selected lookup table.

Refer to View the Source Tables and Fields Mapped to a Lookup Table for more information.

Click to remove all unmapped values from the Source table. Mapped values must be removed manually.

Click to delete unmapped values and pull new values from the Source.

Description

Displays the database name of the Source.

Displays the name of the Source as defined in Target Design.

Displays the name of the ERP check table.

Displays user-entered comments about the selected check table.

Displays the Source table containing the field.

NOTE: The Source table for the check table for the Rule Xref action is not automatically set. It must be entered in this field.

Displays the Source field containing the value.

NOTE: The Source field for the check table for the Rule Xref action is not automatically set. It must be entered in this field.

Displays the name of the field used for filtering on Client Values.  This field only applies to SAP Sources. For example: MANDT, CLIENT or MANDANT

Displays the name of the language field in the Source table to filter description updates in one language.  This field only applies to SAP Sources.

Displays the table name that stores the description field for the Source field.  Usually, the value and description are stored in the same table.

Displays the field name that contains the description of the Source field.

For example, the field State contains a value of GA. The description of the State field would be Georgia, and is stored in the description field.

Displays a key field name when the primary key of the Source table does not match the primary key of the Legacy Description Table.

Displays the field in the Source table that stores the description of the language.

Additional Information

Displays the second Key field name (for Multi-Part Key Source table).

Displays the third Key field name (for Multi-Part Key Source table).

Displays the fourth Key field name (for Multi-Part Key Source table.

Displays the fifth Key field name (for Multi-Part Key Source table).

Displays the Override Download SQL if the Source Table is too complicated for auto-generated SQL commands.

Displays the where clause to append to the download of values to filter on a smaller mapping list.