Source Columns

The Source Columns tab enables you to select the columns you require to be extracted.

Columns must be selected for the following reasons:

  • Only columns that are selected are available for mapping and for extraction.
  • When a source table is copied to destination, only the columns selected are copied to destination and mapped. Key columns of the main table (not the related table) are selected by default and cannot be cleared. Key columns of related tables are not selected by default.
  • At least one column should be selected if you plan to perform an operation such as collecting sample data or validating source tables. The results will display data specific to the columns selected.

Field Description and Action
Column Name This is the technical name for the column in the ERP.
Column Friendly Name This is the friendly name for the column.
Is Key Columns marked True are the key columns for the selected table.
Data Type Displays what type of data the column contains-for example, date or integer or a variable character.
Note: Each column on this panel has filters that enable you to search for a column name, friendly name, data type and so on. To search for a specific name or value, click Test in the required column.