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

# ExtApp table

> ExtApp list table. Applications startable from SuperOffice

## ExtApp Table (133)

ExtApp MDO list item table.
ExtApp list table. Applications startable from SuperOffice

## Fields

| Name                      | Description                                                                                                                                                                                                             | Type                                              | Nullable |
| ------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------- | :------: |
| ExtApp\_id                | Primary key                                                                                                                                                                                                             | PK                                                |    No    |
| name                      | The list item                                                                                                                                                                                                           | String(239)                                       |    No    |
| rank                      | Rank order                                                                                                                                                                                                              | UShort                                            |    Yes   |
| tooltip                   | Tooltip or other description                                                                                                                                                                                            | String(254)                                       |    Yes   |
| deleted                   | 0 -> record is active 1 -> record is 'deleted' and should not be shown in lists                                                                                                                                         | UShort                                            |    Yes   |
| path                      | Path where the programfile is located; if empty, PATH is used                                                                                                                                                           | String(239)                                       |    Yes   |
| filename                  | Filename of the programfile                                                                                                                                                                                             | String(239)                                       |    No    |
| parameters                | \<template variable> \<other template variable>                                                                                                                                                                         | String(239)                                       |    Yes   |
| workdir                   | Directory set to current when loading the application, if different from application's own                                                                                                                              | String(239)                                       |    Yes   |
| icon                      | 0 indicates default Icon (from app exe file), otherwise reference to a predefined icon resource in SO                                                                                                                   | UShort                                            |    Yes   |
| availableInState          | When should this application be available from SO: 0=always, 1=on central db, 2=on travel db,4 on satellite. The value 5 (1+4) indicates that this application is available when logged in to a central or satellite db | Enum [AppAvailState](./enums/appavailstate.mdx)   |    No    |
| executeOnEvent            | Events that cause automatic execution of this app                                                                                                                                                                       | Enum [ExecuteOnEvent](./enums/executeonevent.mdx) |    No    |
| navigation                | 0=from menu, 1 = from Navigator(integration), 2 = From navigator                                                                                                                                                        | Enum [Navigation](./enums/navigation.mdx)         |    No    |
| showState                 | Maximized / minimized / restored                                                                                                                                                                                        | Enum [ShowState](./enums/showstate.mdx)           |    No    |
| registered                | Registered when                                                                                                                                                                                                         | UtcDateTime                                       |    No    |
| registered\_associate\_id | Registered by whom                                                                                                                                                                                                      | FK [associate](./associate.mdx)                   |    No    |
| updated                   | Last updated when                                                                                                                                                                                                       | UtcDateTime                                       |    No    |
| updated\_associate\_id    | Last updated by whom                                                                                                                                                                                                    | FK [associate](./associate.mdx)                   |    No    |
| updatedCount              | Number of updates made to this record                                                                                                                                                                                   | UShort                                            |    No    |
| appType                   | Application type: 1 = exe, 2 = integrated html, 3 = integrated url, 4 = browser url, 5 = external url                                                                                                                   | Enum [AppType](./enums/apptype.mdx)               |    Yes   |
| waitToFinish              | If 1, we wait synchronously for the pplication to finish before we go on                                                                                                                                                | Bool                                              |    Yes   |
| windowName                | The window which the URL address is to open in (webpanel only)                                                                                                                                                          | String(254)                                       |    Yes   |
| url1                      | URL, supports long strings up to 1k                                                                                                                                                                                     | String(1023)                                      |    Yes   |
| url2                      | Obsolete - do not use this field                                                                                                                                                                                        | String(254)                                       |    Yes   |
| configInfo                | Extra configuration information                                                                                                                                                                                         | String(2047)                                      |    Yes   |

<img src="https://mintcdn.com/superofficeas/zNQa3AO19PFK63SB/media/loc/en/database/tables/ExtApp.png?fit=max&auto=format&n=zNQa3AO19PFK63SB&q=85&s=a76a1916b2cfb30402a08a4f617ce6e4" alt="ExtApp table relationship diagram" width="914" height="835" data-path="media/loc/en/database/tables/ExtApp.png" />

## Indexes

| Fields | Types       | Description |
| ------ | ----------- | ----------- |
| name   | String(239) | Unique      |

## Relationships

| Table                                    | Description                                                                                                                                                                                                                                                                                                                               |
| ---------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [associate](./associate)                 | Employees, resources and other users - except for External persons                                                                                                                                                                                                                                                                        |
| [document](./document)                   | Documents, this table is an extension of the Appointment table.  There is always a corresponding appointment record; the relation between appointment and document is navigable in both directions. A document-type appointment record always has a corresponding document record and a record in VisibleFor specifying who may see this. |
| [ExtAppGroupLink](./extappgrouplink)     | User group link table for ExtApp, for MDO item hiding                                                                                                                                                                                                                                                                                     |
| [ExtAppHeadingLink](./extappheadinglink) | Heading link table for ExtApp, for MDO headers                                                                                                                                                                                                                                                                                            |

## Replication Flags

* Replicate changes DOWN from central to satellites and travellers.
* Replicate changes UP from satellites and travellers back to central.
* Copy to satellite and travel prototypes.

## Security Flags

* No access control via user's Role.


## Related topics

- [ExtAppHeadingLink table](/en/database/tables/extappheadinglink.md)
- [ExtAppGroupLink table](/en/database/tables/extappgrouplink.md)
- [extapp](/en/api/mdo-providers/reference/extapp.md)
- [Enum values for AppType](/en/database/tables/enums/apptype.md)
- [Enum values for AppAvailState](/en/database/tables/enums/appavailstate.md)
- [Enum values for Navigation](/en/database/tables/enums/navigation.md)