Common

System Types Mappings

Use this page to Add Mappings.

To access this page:

  1. Select Common > System Types in the Navigation pane.
  2. Click the Target Mappings icon for a System Type.

NOTE: Excel Integration has been enabled on this page. Refer to Use Excel Integration for more information.

Field

Description

SOURCE SYSTEM TYPE TABLE ID

Displays table within the target system being mapped.

DESCRIPTION

Displays description of the mapping.

TARGET SYSTEM TYPE TABLE FIELD ID

Displays table field within target system being mapped; fields are mapped from a source to a target system.

ACTION

Displays type of mapping. Options are:

  • Construction – Constructs data in Construct because source data does not exist for this Target ERP field.
  • Copy – Copies the legacy value directly into the Target ERP system, unchanged.
  • Cross Reference – Cross references the legacy value using value mapping to convert the source value to a Target ERP value.
  • Default – Defaults all records to value in DEFAULT VALUE field.
  • Internal – Generates number inside Legacy system as the record is loaded, which is typically the key value.
  • Manual Construction – Indicates a rule that will be built manually in Construct
  • Manual Rule – Creates rule using provided SQL code.
  • Not Used – No mapping is required because the field will not be loaded into the Target ERP system.
  • Rule – Creates a rule for complex field mapping. Any action that is too complex for a Default, Copy or Cross Reference.
  • Rule Cross Reference – Performs manipulation of the source value and then converts the value to a Target ERP value using value mapping.

RULE SQL

Displays SQL used to generate the rule if the action is Manual Rule.

SOURCE SYSTEM TYPE TABLE FIELD ID

Displays table field within the source system being mapped; fields are mapped from a source to a target system.

RULE COMMENT

Displays information about the rule.

DEFAULT VALUE

Displays the mapping value used for an Action of Default.

RULE TYPE

Displays the value to determine the rule category to import mappings. The options areSourceRule or TargetRule.

MAPPING GROUP ID

Displays name of mapping group.

FIELD GROUP

Displays field group used to further categorize the fields in mappings. Field groups do not impact rule generation.

MAPPING SET ID

Displays the Mapping Set to which the Mapping is assigned. The Mapping Set can be used to logically group several Mapping records.

SYSTEM TYPE JOIN ID

Displays the name of the join added on the System Types Joins page.

NOTE: Table join relationships indicate how table fields are connected; they must be manually added to System Types.

SYSTEM SUPPLIED

If checked, this content is installed with the Stewardship Tier and cannot be edited.

If unchecked, the content was added by a user or process.

NOTE: This is a display-only check box. It cannot be updated.