Display Configuration     
  Schema Many databases support Schemas allowing the database administrator to organise tables and procesdures into logical groups.  If the connection supports schemas, choose the schema, then select the table or procedure. 
  Object List of database tables or procedures, depending on the chosen Task Method.
  Work Columns Work Columns can be added to hold calculation values or any other custom value or lookup.  Work columns examples are:

1. For total amounts.  The work column can contain an Excel formula to sum other column values.
2. A special drop down list to add row functionality such as row deletion.
3. A place holder where column a requires more than one validation rule.  In this case, set the work column's value using the 'Default value formula' option to reference the value of another column using R1C1 notation, then add the validation rule to this work column.
4. The data-source may contain one or more columns to be displayed or referenced in Excel formula but does not want to be sent to the database.  Work columns can be used as place holders for such columns.

Like any other column, work columns can be hidden using the Visible option.
Work columns can be referenced in any SQL within EDT using the Insert Merge code button.  Further details can be found here [INSERT LINK]
  Map Columns For data transfer tasks, and when source and target SQL is set to automatic, the Map Columns feature can be used to quickly align source and target data columns.  Further details can be found here [INSERT LINK]
Column Options     
  Column Letter The Excel column letter that the item will be displayed in.  You cannot edit the Column Letter but you can re-arrange the order of columns.
  Key The primary key/s
  Lock Prevents the user from being able to modify data in this column.  Consider also changing the 'Column Format' properties so the value appears grayed out.
  Item Name Field or stored procedure parameter name as labelled in the database.
  Data Type The data type for this column as defined by the database.  The application will automatically check that the data in the cell matches the data-type.  A validation message will appear in the far left column of the task if there is a data type validation problem.
  (Column) Visible Specifies if the column is visible to the user.  A column can be hidden from the user if the user does not need to see the data for this item.   Reference can still be made to a value in a hidden column in the row.
  Include in SQL Specifies whether this item will be included in the automatically generated SQL.  If not included then the data for this item will not be updated or added.
  Column Order Columns may be re-ordered by clicking and dragging the Item Name.  When the SQL Data Source is set to automatic, the source column order will be automatically modified for you.
  (Column) Mandatory Specifies that a value for this item must be supplied (IE cannot be NULL)
  Auto Filter The task Excel Auto filter can be restricted to certain columns.  See also the task 'Interface' options to enable/disable auto filter for this task.
  Column Title A meaningful descriptive column title (rather than the database item name).  The title can be multi-line and may contain task parameter merge codes.  Click the Column Title text box for available options.
  Default Value or = Excel formula The default value for this column.  Data (of the correct Data Type) maybe entered or the default value can be specified as an Excel formula.  Please also note the 'Allow user to modify formula' option under 'Interface Settings'. Further details can be found here [INSERT LINK]
  Column Format Enables the font colour, Number format and other options for this column to be specified.  Please also note that Conditional Formatting may be applied to this column by clicking the 'Conditional Formatting' button.
  Merge Number Format Add display characters such a currency symbol, thousands separator, or special date formats.  Check this option to send the formatted string to the database including the format characters.
  (Column) Min Width Minimum number of characters to display for this column column
  (Column) Max Width Maximum number of characters to display for this column.
  (Column) Wrap When using a fixed width column, the Wrap option will auto expand the row height to accommodate long text data.
  Conditional Formatting Enables the formatting of this column to be determined by a set of conditions.  The font colour / border colour can be set when these conditions are true. Further details can be found here [INSERT LINK]
  Excel Validation The Excel formula based validation rule for this column.
  Lookup Column Lookups can be used for several purposes:  Here are some examples:

1.  A select list for data column or task parameter drop down list.
2.  Display a list of possible values from any data source query.
3.  Row Actions can be defined (such as delete) using a 'Work column' drop-down.
4.  Lookup a value based on another column value.

Values can be a fixed list or SQL lookup from any data source.
Lookup can be key + Value for relation data lists.
The application will automatically display the list item that matches the underlying column data or initial parameter value.
Row SQL    
  Automatic SQL If this option is selected then the SQL statements will be automatically generated for you.
  Update Include additional SQL to perform 'if Exists Then Update Else Insert' based on the selected key.
This option is available when using the Task Method 'Insert or Update data from any source'
  Custom SQL If you chose to write your own custom SQL then select this option.  You may find it useful to copy the auto-generated SQL and modify as appropriate.
  On error - show data as error message The SQL can include simple 'SELECT' statements that return an error message.  If this option is selected, any such return data is shown in the error message in the EDT Validation column.

For example (SQL server):

IF {XL-Merge:DOB} > GetDate()
BEGIN
   SELECT 'Date of Birth must be before todays date'
   RAISERROR('Procedure failed',16,1)
END

If the DOB is invalid, the message 'Date of Birth must be before todays date' will appear in the EDT Validation column.
  Test Merge (Button) The Test Merge feature is useful when the task has been run at least once, and the first row of the EDT worksheet contains some data.
This feature will merge one or more data rows with the SQL from preview.
Merge Codes    
   Merge Code (Button)  Merge codes are used to replace SQL text with either column values, Task Parameter values or 'special' merge codes such as User Name.
First place the cursor in the SQL code box where the merge code is to be inserted, then click the insert merge code button.
Further details can be found here [INSERT LINK].