Updating Existing Mappings and Sequences

Caution: The predefined mappings and sequences listed in the drop-down fields were configured and tested by Infor for the VISUAL migration. These predefined mappings and sequences are stored in migration database tables and should only be modified by a qualified consultant.

To update table mappings:

On the Import Steps form, select the source table record. You can see the mapped target table and the mapped columns in the source and target. You cannot edit the existing mappings or the sequence number. However, you can add mappings between columns in the tables, or delete existing mappings.
Optionally, specify a SQL "Where" clause in the Source Filter to use for filtering the source table data, as shown in the Filter Example below.
Set the status to Not Started so that the preliminary data transfer will process this step.
When your changes are complete, save the record.

For example, your external application has an OPERATION table that you are mapping to the CloudSuite Industrial job table. However, you only want to import operation records where the WORKORDER_TYPE value is M into the job table. In the sequence record where the OPERATION table is mapped to the job table, specify this in the Source Filter field: WORKORDER_TYPE="M"