> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Third-party tables

> Working with third-party tables in CRMScript

## Add data to a new table

Using [SearchEngine][2] and `addData()`, you set up the row and then do an insert.

This example adds a row to the `y_equipment` table with values for the `x_label` and `x_manufacturer` fields.

```crmscript theme={null}
SearchEngine se;
se.addData("y_equipment.x_label", "tablet");
se.addData("y_equipment.x_manufacturer", "HP");
se.insert();
```

## Reference

### Table properties

| Property               | Description                                                                              |
| :--------------------- | :--------------------------------------------------------------------------------------- |
| Folder                 | to organize tables in a hierarchy, optional                                              |
| Name                   | label                                                                                    |
| Database table         | for the schema, can't be changed after creation                                          |
| Sort order             | which column the table will be sorted on, and the direction                              |
| Display field          | for relations                                                                            |
| SuperOffice CRM access | controls access to the table from web panels<br />no access, read access, or full access |

[Complete list of properties][1]

### Field properties

| Property               | Description                                                |
| :--------------------- | :--------------------------------------------------------- |
| Name                   | label                                                      |
| Database field         | for the schema, can't be changed after creation            |
| Cannot be empty        | makes field mandatory                                      |
| Create index           | whether to index the field                                 |
| Show in table          | whether to as a column when listing entries                |
| Default value          | used if not set explicitly                                 |
| Update null values now | whether to replace all empty fields with the default value |

In addition, each type has its own set of properties. For example, items for a list box and decimals in a number, or units for a time span.

[Complete list of properties][3].

[1]: ../../../../custom-objects/admin/create-extra-table

[3]: ../../../../custom-objects/admin/create-extra-field

[2]: ../../searchengine/index


## Related topics

- [Third-party tables](/en/custom-objects/learn/extra-table.md)
- [Unassign Third Party Licenses](/en/api/reference/restful/rest/license/unassign-third-party-licenses.md)
- [Assign Third Party Licenses](/en/api/reference/restful/rest/license/assign-third-party-licenses.md)
- [Get Third Party License Assignments](/en/api/reference/restful/rest/license/get-third-party-license-assignments.md)