ExtApp Table (133)
ExtApp MDO list item table. ExtApp list table. Applications startable from SuperOfficeFields
| 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 | No |
| executeOnEvent | Events that cause automatic execution of this app | Enum ExecuteOnEvent | No |
| navigation | 0=from menu, 1 = from Navigator(integration), 2 = From navigator | Enum Navigation | No |
| showState | Maximized / minimized / restored | Enum ShowState | No |
| registered | Registered when | UtcDateTime | No |
| registered_associate_id | Registered by whom | FK associate | No |
| updated | Last updated when | UtcDateTime | No |
| updated_associate_id | Last updated by whom | FK associate | 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 | 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 |
Indexes
| Fields | Types | Description |
|---|---|---|
| name | String(239) | Unique |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| 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 | User group link table for ExtApp, for MDO item hiding |
| 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.