Adding a New Mapping and Sequence

On the Import Source Tables form, select a Source Table from your external application that is not already mapped. The list of source tables is determined by the database you specify in the Import Parameters form.
Select the columns from the table that you want to map.
In the Import Target Tables form, select a Target Table. Only CloudSuite Industrial tables whose data can be modified are listed.
Select the columns from the table that you want to map.
On the Import Steps form, click the filter-in-place button.
Add a new record.
Select the Source Table you added in step 1 and the Target Table you added in step 3.
The next available sequence number is assigned. You can change this number; however, use extreme caution if you insert this sequence between two existing sequence numbers.

Note: The sequence is extremely important and must be planned carefully to avoid problems with missing dependencies in the data.
The status is set to Not Started.

See Changing the Data Transfer Status.
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.
For the selected source and target tables, use the grid to select and map the source table columns to the target table columns. Only columns that are defined on the Import Source Table and Import Target Table forms are listed.
When all source columns are mapped, save your changes.

Note: Be aware of any differences in the allowed lengths in mapped columns. If a decimal value imported from the external application contains more decimal places than are allowed in the mapped column in the target database, the data is rounded by SQL Server default precision. If this rounding is not appropriate for this value, you must correct it in the target database after the final data transfer is complete.

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"