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

# ext_field table

> This table contains entries mapping an external field to an internal field. Used for database integration.

## ext\_field Table (319)

This table contains entries mapping an external field to an internal field. Used for database integration.

## Fields

| Name       | Description                                                  | Type                             | Nullable |
| ---------- | ------------------------------------------------------------ | -------------------------------- | :------: |
| id         | The primary key (auto-incremented)                           | PK                               |    No    |
| ext\_table | The reference to the associated ext\_table                   | FK [ext\_table](./ext-table.mdx) |    Yes   |
| seq\_order | The column number for this field. Strictly ascending.        | Int                              |    Yes   |
| name       | The name for this field.                                     | String(255)                      |    Yes   |
| target     | The target for this field. E.g. \'customer.name\'. | String(64)                       |    Yes   |
| flags      | Bitmap for flags for this entry.                             | Int                              |    Yes   |
| datatype   | The datatype for this field. TODO: depreciated?              | Int                              |    Yes   |

<img src="https://mintcdn.com/superofficeas/6OcOTPa_ISkjXJg4/media/loc/en/database/tables/ext_field.png?fit=max&auto=format&n=6OcOTPa_ISkjXJg4&q=85&s=414ea54d190e489e1c74b838b669a4d6" alt="ext_field table relationship diagram" width="365" height="59" data-path="media/loc/en/database/tables/ext_field.png" />

## Indexes

| Fields     | Types | Description |
| ---------- | ----- | ----------- |
| ext\_table | FK    | Index       |

## Relationships

| Table                     | Description                                                                                                                               |
| ------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------- |
| [ext\_table](./ext-table) | This table contains entries used for mapping an external table to an internal table (customer or cust\_company) for database integration. |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [ext_table table](/en/database/tables/ext-table.md)
- [extra_fields table](/en/database/tables/extra-fields.md)
- [ext_datasource table](/en/database/tables/ext-datasource.md)
- [ExtApp table](/en/database/tables/extapp.md)
- [ExtAppHeadingLink table](/en/database/tables/extappheadinglink.md)
- [ExtAppGroupLink table](/en/database/tables/extappgrouplink.md)