Generating Primary Keys and Defaults

When field is not mapped to anything:

Enter value (New York for example) into SQL function field and
following SQL would be executed while inserting the data.

Insert into Customers (Customer,,,,City)  
Values (CutomerValue,,,”New-York”)

When field is mapped:

Enter value (New York for example) into default field and 
this value will be used for  inserts if source field is null or empty.

Note:

To insert empty string enter ’’ into default field.