> ## 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

> Introduction to SuperOffice extra tables

<Note>
  This feature requires a license for [Development Tools][1] or the CRM Suite **Core** plan.
</Note>

[1]: /en/admin/license/expander-services

The Development Tools license or the Core plan gives you the possibility to create extra tables (custom objects) in the database.

The **Tables** screen is your tool for customizing the database schema.

## How to access

<Tabs>
  <Tab title="Classic">
    Third-party tables are instantly available for standard CRUD operations in SuperOffice Service. You need to set up a web panel to access them from the Sales client.
  </Tab>

  <Tab title="New (from version 10.3.4 pilot)">
    No longer confined to SuperOffice Service, you can effortlessly explore and maintain data in extra tables from SuperOffice CRM.

    ### Build dashboards using custom objects

    ![Dashboard with custom objects -screenshot][img1]

    ### Find and selection

    **Custom object as search criteria for company, contact, sale, project, request, activity:**

    ![Custom object as search criteria -screenshot][img2]

    **Create selection of custom objects (10.3.7):**

    ![Find screen with custom objects -screenshot][img3]

    ![Selection of custom objects -screenshot][img4]

    ### Maintaining data (10.3.7)

    **Open Custom Objects overview:**

    ![Custom Objects overview -screenshot][img5]

    **Search:**

    ![Custom Objects overview, search -screenshot][img6]

    **Preview:**

    ![Custom Objects overview, preview -screenshot][img7]

    **Add/remove items:**

    When viewing the results for a specific item in the **Custom Objects** overview, click the **Task** button and select **New** or **Delete**.

    **Pre-fill fields when loading custom object (10.3.8):**

    The new [SalesLoadCustomObject][6] trigger is called before a custom object screen is loaded. Use it to set default values in fields and define business rules.
  </Tab>
</Tabs>

## Tables screen

The **Tables** screen shows a list of database tables. It displays both standard tables (predefined in the system and form the basis of different screens) and extra tables (tables you create yourself with optional content).

Here, you can create new tables and fields for different screens and dialogs. Only administrators have access to this functionality.

### Table folders

Table folders are used to organize your custom tables.

## Conventions

<Warning>
  Choose your database table and field names carefully. They cannot be changed later!

  A logical name is best because it makes it easier to see what the database contains.
</Warning>

Prefixes ensure that what you create do not conflict with future SuperOffice table and field names. However, it does not guarantee a lack of naming conflicts between different 3rd parties.

### Table names

* Must start with **y\_**
* May contain only underscores, the letters a to z, and numbers

### Field names

* Must start with **x\_**
* Must be unique within the table
* Must be a single word
* May contain only underscores, letters from a to z, and numbers

## Related topics

* [Add extra table][2]
* [Add extra fields][3]
* [Add user-defined fields][4]
* [Custom screens][1]
* [Create trigger][5]

[1]: ../../ui/blogic/learn/index

[2]: ../admin/create-extra-table

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

[4]: ../admin/add-udef

[5]: /en/automation/trigger/create-trigger-script

[6]: /en/automation/trigger/reference/CRMScript.Event.Trigger#salesloadcustomobject

[img1]: /media/loc/en/automation/custom-object-dashboard.png

[img2]: /media/loc/en/automation/find-custom-object-relation.png

[img3]: /media/loc/en/automation/find-screen-with-custom-objects.png

[img4]: /media/loc/en/automation/custom-object-selection.png

[img5]: /media/loc/en/automation/go-to-custom-objects.png

[img6]: /media/loc/en/automation/search-inventory.png

[img7]: /media/loc/en/automation/preview-inventory-results.png


## Related topics

- [Third-party tables](/en/automation/crmscript/howto/custom-objects/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)
