Add a field map for sys_id

Add a field map to establish a relationship between the sys_id field in the source table (defined in the transform map) and the sys_id field in the target table.

  1. Open the table transform map record you just created.
  2. In the Field Map related list, click New.
  3. Complete the form, using the following values
    • Source field:sys_id
    • Target field:Sys ID (You must do XML injection to make it work on older releases.)
    • Coalesce: Select the check box.
  4. Click Submit.