> ## Documentation Index
> Fetch the complete documentation index at: https://superofficeas-worktree-351-fix-webapi-escaped-anchors.mintlify.site/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-worktree-351-fix-webapi-escaped-anchors/lG_0VSOpA0nSl_9s/media/loc/en/database/tables/ext_field.png?fit=max&auto=format&n=lG_0VSOpA0nSl_9s&q=85&s=0ae89830e3d8384a537e47d4ba0291c5" 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.