External data source table wizard

The wizard is intended for describing table structure.

If you click Manually and then click Finish, a table that does not have fields is created. You can create the fields and the table description in the external data source table editor.

If you click Select from list of external data source tables, you proceed to a step-by-step table structure creation. This option requires access to the data source.

At the next step (after you click Next), the data source connection window is displayed.

Once you connect to the data source, the list of its tables is displayed.

In the Name/expression in data source column, select the check boxes for the tables and fields that you want included in the external data source description.

If you have created tables for this data source earlier, the check boxes next to these tables are already selected. To exclude tables or fields, clear the check boxes next to them.

In the Name in configuration column, specify the name used for registering the table or field in the configuration.

In the Type column, specify the data type. For fields, you can specify links to external data source tables. The table list only includes tables with object data type.

In the Key field column, select the check boxes for the fields included in the key field list.

In the Presentation field column, select the check boxes for the fields that are used in table record presentations.

In the Version field column, select the check boxes for the fields that are used for record versioning (the field value is incremented every time a table record is changed).

In the Read-only column, select the check boxes for the fields that cannot be edited from forms or from 1C:Enterprise script. If the check box is selected for the entire table, the following operations are not available for the table: adding, editing, and deleting records.

In the NULL allowed column, select the check boxes for the fields where a Null (<not specified>) value can be recorded.

In the Default value column, a check box is selected automatically based on the default field in the source database.

In the Comment column, you can add a comment to the table or field.

If you select the Remove tables and fields not available in the external data source from the configuration check box, the tables and fields that are not available in the external data source (for example, tables and fields that were deleted from the data source) are removed from the configuration upon wizard completion.

The changes that you make are marked in bold.

To complete the wizard, click Finish. Then the tables and fields are added to (or removed from) the external data source description. To edit table and field descriptions, use the external data source table editor window.

If the configuration contains references to tables that are not selected in the wizard, such fields are marked in red and when you click Finish in the the wizard, the warning about excluded tables is displayed.

1C:Enterprise Developer's Community