Consolidated column name   This is the column that you are synchronizing in the consolidated database.

Consolidated column number   This column indicates the order in which columns are returned by a SELECT * FROM tablename statement.

Consolidated column data type   The data type of the consolidated column.

Mapping direction   The mapping direction of the column.

For a column-to-column mapping the direction is the same as for the table mapping. A column can have the same mapping as its table or not be synchronized. For example, if the table has a bi-directional table mapping, the table's columns can either be Bi-Directional or Not Synchronized.

If the column mapping direction is Not Synchronized, the column is part of the remote database schema. When the model is deployed, the column is created on the remote, but no information is synchronized to it.

If you don't want the column to be created on the remote, delete it from the model. You can not delete primary key columns. See Modifying how deletes are recorded.

Remote column name   Show the remote column or upload value that the consolidated column is mapped to, or if it is not synchronized.

Columns in consolidated database tables can be mapped to upload values in the Column Mappings tab by clicking the ellipsis (three dots) button and selecting MobiLink User Name, Remote ID, or Custom, which allows you to enter a SQL expression that can include MobiLink named parameters. Upload values do not correspond to a column in the remote table, so they only apply to uploads to the consolidated database. If you map a consolidated primary key column to an upload value, you should also apply a corresponding subset to your downloads and download deletes to ensure uniqueness of primary keys on downloads.

Remote column number   This column indicates the order in which columns are returned by a SELECT * FROM tablename statement.

Remote column data type   The data type of the remote column.