In this step, Visual FoxPro displays the default data type mappings used to convert local data to remote data, as tables are upsized to the server. You can choose to change these default mappings.
You can't change the default mapping for a key field to a data type that prevents the field from being indexed. You can change the default mapping of a field that is part of an index key if you choose a data type that is indexable; however, you might want to change the data types for the other fields in the key to match. Visual FoxPro warns you if you change the default data type mapping for a field that is not a key field but is used in a Visual FoxPro index. If you make a mistake, click Defaults to reset the data types.
Table
Select the table whose fields you want to map from the list of all the tables you've chosen to upsize.
Field Name
Lists the fields contained in the table you selected in the Table drop-down list.
FoxPro Type
Lists the Visual FoxPro data type for the field.
Server Type
Lists the server data type to which Visual FoxPro data in this field will be mapped when the table is copied to the server. Click in this field to display a drop-down list from which you can select a different server data type.
Width
Specifies the width of the field.
Precision
Specifies the decimal precision of the field, when applicable.
Note Empty Visual FoxPro date fields are upsized to NULL values in the Oracle database. If a date column in your Oracle database doesn't accept NULL values, replace empty date fields in your Visual FoxPro table with not empty dates before upsizing.